Search results

I'm running a report of products by aisle in a retail store. I have the report sorting on the aisle number. Is there a way to make it re-number beginning at page 1 again for each aisle? I'm trying to avoid having to indicate which aisle number and having this company have to run a new report...

I realized I was unclear...I need the report to total all of the QOH for each Hazard Class, and print that total at the bottom of each section. I also need those totals saved somewhere, as they have to be used to generate another set of reports that compares that total to a set of parameters for...

I'm having trouble creating reports in Access. I have a database of several linked tables. I'm getting the required fields from the various tables into my report just fine. My issue is that I need to get the results of a query, titled QuantityOnHandQuery, into my report. I'm not having any...

SELECT SP.[Store Product Key], (([P].[Package]*[P].[Size]*[SP].[Cases])/[P].[ConversionRate]) AS QOH FROM Product AS P INNER JOIN [Store Products] AS SP ON P.UPC = SP.UPC; That's my entire query. When I run it, I get a table. That's fine. It's the report that's asking for the parameter value.

OK one more question...I deleted the QOH field from my StoreProducts table. I also deleted that field from my report, and then created another QOH field in the report...but when I do a Print Preview on the report, it's asking me to enter a parameter value for Store Products.QOH. Evidently I...

Maybe I should explain. This is a database of hazardous products for sale at a retail store. We have a contract with a major company to provide the required reports, individualized for each store. I must run three reports using this information. Report 1: Must return QOH for each...

Hi. I'm a basic Access user, but a company contacted the temp agency I work for and asked for someone who can create a relatively simple Access application. I have the tables all created and linked and a lot of information in them, but I have one field that has to be populated by the results of...