I'm not a report expert. I have created many, but they are usually fairly simple and based on queries. I'm not sure how one would go about creating a report based on data typed into unbound text boxes on a form (which is what it sounds like you have) other than writing the data to a temporary table and then basing the report on that (which takes a lot of VBA programming).
I think you may want to look at revising your form and table structure so that the data gets typed into bound controls on the form. That would take advantage of Access' built-in features. I don't think there's an easy way to pass a report a bunch of unbound data. If you could give the group a lot more detail on your table structure and what you would like on the report, I think we could provide a much better answer. HTH, Toby ----- Original Message ----- From: "Pete Harrison" <[EMAIL PROTECTED]> To: <AccessDevelopers@yahoogroups.com> Sent: Friday, November 18, 2005 2:03 AM Subject: [AccessDevelopers] Re: Reposting - Selecting records > 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 AccessDevelopers@yahoogroups.com, "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: <AccessDevelopers@yahoogroups.com> > > 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 AccessDevelopers@yahoogroups.com, "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: 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 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > 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 fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/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/
