advanced filter

[melissaperusse]

Hi there,

I have this issue: I have a query which sums the total expenses for
each month. On my report I use this information to show how much was
spent quarterly. What I am interested in is showing only the first
half of the year. But when I go to my query and ask it to do an
advanced filter for "Month" and I add the critera of Between 01/01/06
And 06/30/06. I turn up 0 records.

Am I crazy or can it be done?

Thank you,

 

[Duane Hookom]

I'm not sure what you mean by "advanced filter" but if the column is "month"
and you enter a "date", this would cause your result. A month has a numeric
value from 1 to 12 while dates have numeric values like 38923 (today's
date).