consolidated analysis - query

J

Joe

I have a big query of month-by-month sales of products
(name of the product and the number of times it was sold
each month) for a few years. using this query, I want to
make a form that shows the number fo times a particular
product was sold on a half yearly basis.

Any suggestions are thankfully welcome!

With Regards,
Joe
 
G

Guest

Add a column to the query something like WhichHalf: Month([SoldDate])
This will give you 1 to 6 for the first half of the year and 7 to 12 for the
second half
so you can check on <7 or >6 for half yearly totals.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Queries-Form 1
counting unique values in query 6
Combining 3 queries 2
Parameter Query 2
Help needed with query for weekly totals 4
Query to update qty on insert in another table 1
Query help please. 3
Normalizing Monthly Sales Data 5

Top