Newsgroups are very good for getting help on specific problems by explaining
what you have done, what you expect, and what you are seeing. They arenot
a good source for sending someone a database and asking them to determine
"why it isn't working". Many of us are reluctant to receive and execute
databases from sources we don't know -- there is too much "mischief" and
"malware" and people who enjoy causing it.
--
Larry Linson, Microsoft Office Access MVP
Co-author: "Microsoft Access Small Business Solutions", published by Wiley
Access newsgroup support is alive and well in USENET
comp.databases.ms-access
Newsgroups are very good for getting help on specific problems by
explaining
what you have done, what you expect, and what you are seeing. They are not
a good source for sending someone a database and asking them to determine
"why it isn't working". Many of us are reluctant to receive and execute
databases from sources we don't know -- there is too much "mischief" and
"malware" and people who enjoy causing it.
--
Larry Linson, Microsoft Office Access MVP
Co-author: "Microsoft Access Small Business Solutions", published by Wiley
Access newsgroup support is alive and well in USENET
comp.databases.ms-access
As I believe I said, you can (1) explain what you have done, (2) what you
expect, and (3)what you are seeing -- and post that here. Then people may
have enough information to ask additional pertinent questions so they can
help you. For general informaion on effective use of newsgroups, take a look
athttp://www.mvps.org/access/. Certainly, you must say what data you
maintain in your application, and details of what output you want to showin
the 'stock report'.
MVP Allen Browne, in his website athttp://allenbrowne.com/, has information
on inventory that many have reported as helpful.
You will find a list of MVPs' websites and other useful resources athttp://sp.ntpcug.org/accesssig/. Some of those resources will contain links
and references to other resources.
Chapter 9 of "Microsoft Access Small Business Solutions" contains good
information on needs for Inventory Management and detail information on data
needed to support Inventory Management functions. (Caveat: Although I did
not write that chapter, I am one of the co-authors of that book.)
There are Microsoft online forums... you can likely find the links somewhere
in the pages following:http://office.microsoft.com. I have not found the
forums to be as easy to use, nor as helpful, as newsgroups. Another
newsgroup where knowledgeable people participate is
comp.databases.ms-access, accessible through many newsservers (some free,
and some with a charge -- the server I use is "news.individual.net" whichis
inexpensive but not free, and does not carry binaries newsgroups).
I do not have any specific references on explanations of "how to create a
stock report without knowing what else is in the application", and am
certain that would be an impossible reference to find.
Of course, there are those who will assist you for a fee, but I do not make
specific recommendations or references of that kind.
--
Larry Linson, Microsoft Office Access MVP
Co-author: "Microsoft Access Small Business Solutions", published by Wiley
Access newsgroup support is alive and well in USENET
comp.databases.ms-access
Sir
Then what is the solutions to solve my problem. is there any good
inventory sample software is available
Regards
Rajesh kainikkara
As I believe I said, you can (1) explain what you have done, (2) what you
expect, and (3)what you are seeing -- and post that here. Then people may
have enough information to ask additional pertinent questions so they can
help you. For general informaion on effective use of newsgroups, take a
look
athttp://www.mvps.org/access/. Certainly, you must say what data you
maintain in your application, and details of what output you want to show
in
the 'stock report'.
MVP Allen Browne, in his website athttp://allenbrowne.com/, has
information
on inventory that many have reported as helpful.
You will find a list of MVPs' websites and other useful resources
athttp://sp.ntpcug.org/accesssig/. Some of those resources will contain
links
and references to other resources.
Chapter 9 of "Microsoft Access Small Business Solutions" contains good
information on needs for Inventory Management and detail information on
data
needed to support Inventory Management functions. (Caveat: Although I did
not write that chapter, I am one of the co-authors of that book.)
There are Microsoft online forums... you can likely find the links
somewhere
in the pages following:http://office.microsoft.com. I have not found the
forums to be as easy to use, nor as helpful, as newsgroups. Another
newsgroup where knowledgeable people participate is
comp.databases.ms-access, accessible through many newsservers (some free,
and some with a charge -- the server I use is "news.individual.net" which
is
inexpensive but not free, and does not carry binaries newsgroups).
I do not have any specific references on explanations of "how to create a
stock report without knowing what else is in the application", and am
certain that would be an impossible reference to find.
Of course, there are those who will assist you for a fee, but I do not
make
specific recommendations or references of that kind.
--
Larry Linson, Microsoft Office Access MVP
Co-author: "Microsoft Access Small Business Solutions", published by Wiley
Access newsgroup support is alive and well in USENET
comp.databases.ms-access
Sir
Then what is the solutions to solve my problem. is there any good
inventory sample software is available
Regards
Rajesh kainikkara
Rajesh Kainikkara said:if u accept i will send
the original database.
Sir> if u accept i will send
> the original database.
As I wrote before, I don't receive and execute databases unless I am
personally acquainted with the sender.
I also try to assist by answering questions in the newsgroups, so that
others can benefit from the Q & A exchange -- thus, I don't do "free remote
consulting" using newsgroups as a point of contact (and, in fact, I don'tdo
even "for-fee remote consulting" using newsgroups as a point of contact).
Larry Linson, Microsoft Office Access MVP
As I wrote before, I don't receive and execute databases unless I am
personally acquainted with the sender.
I also try to assist by answering questions in the newsgroups, so that
others can benefit from the Q & A exchange -- thus, I don't do "free
remote
consulting" using newsgroups as a point of contact (and, in fact, I don't
do
even "for-fee remote consulting" using newsgroups as a point of contact).
Larry Linson, Microsoft Office Access MVP
Sir,From your previous post about tables, and the current one about tables,
relationships, and the report (I think I have reconstructed a reasonable
format for the report -- you must understand that lines as long as you
include in your report will be "line wrapped" by the newsgroup clients and
news servers).
I have additional questions.
From what table or other source do you expect to obtain the "Original Stock"
for this period? (I see no table where you appear to maintain the current
level of stock, but, presumably, you do not want to go back to "the
beginning time covered by the entire database and sum all the transactions"
to obtain it).
When I use the word "transaction", I mean either a Sale or a Purchase. (FYI:
you would, I believe, make developing and maintaining the database simpler,
thus easier, if you only had a single table for Transactions, with an
indicator of sale or purchase; and, very likely, one table for Entity, for
both people and organizations to handle both customers and suppliers, with
an indicator for whether the record is for a customer or a supplier.)
A related question: how do you intend to obtain the "balance" figure on each
line of the report? Do you have a table that we don't know about that you
update after each transaction, or do you expect to calculate the balance
after each transaction during the query that is record source for the
report.
My own personal preference is to use descriptive names, without spaces in
them, for database objects such as tables and fields. And, for my
convenience, I am going to reformat your field names in that manner as I
work to help you, and use my reformatted names in my responses. For
example, I will render your field "p inv no" as PInvNo.
--
Larry Linson, Microsoft Office Access MVP
Co-author: "Microsoft Access Small Business Solutions", published by Wiley
Access newsgroup support is alive and well in USENET
comp.databases.ms-access
Sir
Here is the details of my database
sales table "s invocie no " is related to sales details "s invoice no"
purchase table "p invocie no " is related to purchase details "p
invoice no"
product table" item" is related to purchase details "item" & sales
details "item"
Stock report format Item Name................... Date
From.............. to.................
Date Particulers
Inwards Outwards Balance
01/12/10 Opening
Stock
100
02/12/10 Abc Distributors(supplier)
500 600
02/12/10
Anil(customer)
60 540
03/12/10
Rajesh(customer)
40 500
I think it may be enough .
Regards & Thanks
Rajesh Kainikkara
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.