Report Filter

steveP123

New member
Local time
Today, 04:38
Joined
Feb 19, 2004
Messages
6
I am new to Access and have been creating a databse for a few weeks. Your forum has been an endless supply of help for the novice.

I have managed to achieve everything so far and now I've hit a stumbling block.

I am creating a Purchase Order database. I have a table which I fill in and this table contains a sub table of the item details, quantity and price. After enetering all the data required I want to print the order.

I have created a reprot and using the Dlookup function I have got all the supplier, references and addresses ect on the report based on the data from the order form.

The problem I have is that when I enter the item descrition, quantity and price in the detail section of the report, it is entering the data for every single order. I want to filter it so that it only enters the data for the particular order that the report header has successfully done.

I have set my form / tables up so I have one order ID. Each item of the order then gets an individual detail ID which links to the Order ID... thus one order ID could have many detail ID's
The report header prints details or the required order ID but the reprot detail is printing every orde detail ID and I can't filter it to print based on the order ID.

Hope this makes sense.

Thanks

Steve
 
What I can gather from your description is that you would need to set up a query to get only the desired information, then have the report get its data from the query results.
 

Users who are viewing this thread

Back
Top Bottom