Toby, The quantity field does not exist in a table only on the form. Once the user has added quantities to the form, all that happens is a report with only those items that have a quantity next to them is created.
Regards Pete --- In [email protected], "Toby Bierly" <[EMAIL PROTECTED]> wrote: > > 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 --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/u8TY5A/tzNLAA/yQLSAA/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/
