Thanks... can you be a little more specific on how I would actually do that? Right now, I am using [Enter Date] and [Enter machine] in the query.
-How do I include the prompts in the new form for the criteria?
- What would I do once I create a button to have it hide the form and run the...
I am working on a report that pulls all of it's data from a query with criteria (prompts for a date and a machine). In the report footer, I am using the SUM command on the data, but also have several graphs. When I run the report, it runs fine... but it asks me to enter the same criteria again...
I have a query that selects records from a certain machine on a certain date. The records include [Weight Out] and [Shift] fields. I would like to be able to sum the weight produced by each shift (1-3). I am putting a text box in the Report footer with the control source: DSum("[Weight...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.