Search results

I'm gonna admit it right now, I'm not very experienced with tweaking reports so be patient. Rak, the problem with your queries is that they count all the records with track being 'sales' (or in the other case 'technical') in the entire table. I'm trying to show monthly totals. I have my...

I'm trying to make a report that shows three fields: Date, Company, and Track. The 'track' field can only have two values, sales or technical. In this report I need to show for each month, and for each company, how many records exist for sales, and how many exist for technical. So far, I...

That did the trick. Thanks a lot KeithG.

I'm working on this inventory database. So I have a select query called "trigger query" that lets me know what items need to be orderd. Then I have an append query that adds those items to a table called ORDERS. From the trigger query, I have the fields Item Number (which is a primary key in...