I'm fairly new with Microsoft Access so please bear with me. I have created a report based on a table.
However, evrytime I preview this report, it will open all the data from that particular table. What I need to do is create a button that will ask for a date range. Subsequently, the report must only show the data from the dates I have specified. Like I said, I am fairly new at this so if there is some Idiot proof way to explain this, I would appreciate it very much.
I hope Im not bugging anyone on this board, but I have another question that I think is related to my first question. I have modified the built in template for the Order Entry in access 97. However, this only allows you to print Invoices not Packing lists. When you press the Preview invoice, it show only the invoice of that particular customer entry. But I need a packing list too (which doesnt show pricing etc.) So what I did was copy the Invoice and save it as a Packing List. Then I deleted some fields that I did not wish to be seen. But when I click on preview report on the button I created, it previews ALL the records. Not just the particular customer entry that is on the screen. It might sound stupid to some but any help is appreciated.
Thanks!
JEP
However, evrytime I preview this report, it will open all the data from that particular table. What I need to do is create a button that will ask for a date range. Subsequently, the report must only show the data from the dates I have specified. Like I said, I am fairly new at this so if there is some Idiot proof way to explain this, I would appreciate it very much.
I hope Im not bugging anyone on this board, but I have another question that I think is related to my first question. I have modified the built in template for the Order Entry in access 97. However, this only allows you to print Invoices not Packing lists. When you press the Preview invoice, it show only the invoice of that particular customer entry. But I need a packing list too (which doesnt show pricing etc.) So what I did was copy the Invoice and save it as a Packing List. Then I deleted some fields that I did not wish to be seen. But when I click on preview report on the button I created, it previews ALL the records. Not just the particular customer entry that is on the screen. It might sound stupid to some but any help is appreciated.
Thanks!
JEP