Quarter Query

  • Thread starter Thread starter DavidW
  • Start date Start date
D

DavidW

How do you make a query that is for yearly quarters
I noticed in the insert query, that you can do one there, but does the
quarters keep accumalating with years, better yet how would you use this in
a form?
 
-----Original Message-----
How do you make a query that is for yearly quarters
I noticed in the insert query, that you can do one there, but does the
quarters keep accumalating with years, better yet how would you use this in
a form?
Click to expand...
Hi David,
hard to give you a precise answer. The best I can do is
suggest that you use online help to lookup date functions.
You are likely to need an extra column that calculates the
month (using Month() function) and in another the year
(using Year() function). Possibly, your critera for the
month column will be the month numbers for a quarter.

You will need to consider that a query can calculate
values. For example quarter totals. A query can return a
filtered list. For example return only records within a
date range that represents a quarter. A query can also do
both.

Luck
Jonathan
 
Back
Top