I am still trying to figure out what you are trying to do. You have a form with a list of products and allow a user to somehow assign a quantity to each one. I'm assuming these quantities are assigned in a text box. Are these bound or unbound text boxes? It almost sounds like you are trying to run a query for a report using unbound text boxes on the form. Is this correct? You say the quantities are not stored anywhere.
Toby ----- Original Message ----- From: "Pete Harrison" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, November 10, 2005 1:09 AM Subject: [AccessDevelopers] Re: Reposting - Selecting records > Tobi, > > The problem is that the quantity does not exist in any table. There > is a products list which I will display with a quantity input box. > > If the user enters a quantity, the report needs to show this entry, > if the user leaves it blank, the report should not show it. > > Regards > Pete > > --- In [email protected], "Tobi Hoffman" > <[EMAIL PROTECTED]> wrote: > > > > 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: [email protected] > > [mailto:[EMAIL PROTECTED] On Behalf Of Pete > Harrison > > Sent: Thursday, November 03, 2005 9:37 AM > > To: [email protected] > > 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 > > > > > > > > > > > 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/
