Where does the quantity field exist, in the client order table? If you want an inventory quantity, you probably need to put it in the products table.
For the report, you need to base it on a query that combines the products table with the client orders, and include ">0" in the criteria line for quantity. Is this for just the current user? If so, you need to limit the query to records where the order is from that user. At any rate, if you set up your data structure right, it should be a fairly simple query to produce your report. Tobi -----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Pete Harrison Sent: Thursday, November 03, 2005 9:37 AM To: AccessDevelopers@yahoogroups.com Subject: [AccessDevelopers] Reposting - Selecting records I want to create a form that displays a list of products from a query which takes the product name from a table and adds a Quantity field. The form will display the product name and the added quantity field. The user will scan down the products list and put a quantity against one or more records. I then want to produce a report showing only the products with a quantity>0 The quantity field does not exist on the products table. How can this be done? Regards Pete ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
