Date Range Selection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I have a date column in a table and I only want to see march thru june,
can I do this in a table or does it have to be done in a query?
 
Thomas

You could use a filter and the "Between ... And ..." criterion/function, but
then you'd still be in the table. Access tables store data, Access queries
retrieve/show data (and give you better control).

By the way, if you ask for date values where Month([YourDateField]) is
between 3 and 6 (the month numbers for March and June), you'll get those
months for EVERY year. Do you need/want to also limit the
Year([YourDateField]) to a specific year?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Jeff,

It is within the same year. How is that done in the criteria of a query?
Is it a build? or simpler than that?
--
Thomas


Jeff Boyce said:
Thomas

You could use a filter and the "Between ... And ..." criterion/function, but
then you'd still be in the table. Access tables store data, Access queries
retrieve/show data (and give you better control).

By the way, if you ask for date values where Month([YourDateField]) is
between 3 and 6 (the month numbers for March and June), you'll get those
months for EVERY year. Do you need/want to also limit the
Year([YourDateField]) to a specific year?

Regards

Jeff Boyce
Microsoft Office/Access MVP


T Miller said:
If I have a date column in a table and I only want to see march thru june,
can I do this in a table or does it have to be done in a query?
Click to expand...
Click to expand...
 
Back
Top