By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,470 Members | 949 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,470 IT Pros & Developers. It's quick & easy.

how to create a report for continues form

P: 5
I am working on a fast food restaurant database, one of the forms is a continues form that I use for entering sale information such as type of food, quantity, price ,.... what I want to do is to create a report for the current displayed records of the continues form to make a recipe for the customer. can anyone please help me to do that?
4 Weeks Ago #1
Share this Question
Share on Google+
3 Replies


twinnyfo
Expert Mod 2.5K+
P: 3,385
honar,

It sounds like you are asking for the final product, rather than assistance on a particular point.

However, I think the key to your approach will be to have a ReceiptID that manages all the items on each receipt. Then, printing a Report that is built on a ReceiptID should be fairly straightforward.

Perhaps there is something beyond this that has not been explained?
4 Weeks Ago #2

P: 5
twinnyfo

my problem is when the form is open and I entered one more records, I want to make a report for those records only, how I know which records to get from the table and put them on a report?
4 Weeks Ago #3

twinnyfo
Expert Mod 2.5K+
P: 3,385
honar,

The answer to your question has less to do with reports than it has to do with table design and structure. For example, if you have a table tblReceipts, it should have a primary key and list the date of the receipt and maybe a few other generic bits of information like who took the sale. These data are specific to the entire Receipt. Then, you have another table with Receipt items. It uses the primary key from tblReceipts but each record is for a single item. It may include other things such as the cost for each item or the number of items.

So far, we haven't talked about reports or forms. However, when your tables are designed this way, your forms naturally fall into place and when you create a report (one receipt), you filter by the Receipt ID, and only the items that apply to that receipt are displayed.

I don't know your experience level with MS Access, but these principles are foundational to good DB design.

Again, I think you are asking for more than assistance with a small sticking point. I think you need additional training in the basics of DB design. We've all been there at one point or another.
4 Weeks Ago #4

Post your reply

Sign in to post your reply or Sign up for a free account.