Date Range Selection

[T Miller]

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?

 

[Jeff Boyce]

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]

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

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

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?