Question Use a date Range in a Crosstab Query

[Joe8915]

I would like to use a date range in a crosstab query.
I have tried to use "IS not null and between [BeginningDate] and [EndingDate]"

Any ideas?

Thanks

 

[pbaldy]

If those are on the same field the Is Not Null isn't necessary. Watch out for this, is this is your problem:

http://support.microsoft.com/default.aspx?scid=kb;en-us;209778

 

[themurph2000]

If those are on the same field the Is Not Null isn't necessary. Watch out for this, is this is your problem:

http://support.microsoft.com/default.aspx?scid=kb;en-us;209778

I wish I'd remember this little thing. That was the problem I was having today trying to reference text boxes on a form as criteria.

 

[pbaldy]

I only remember because it drove me crazy the first time I ran into it. I still have a flat spot on the top of my head.

 

[Joe8915]

If those are on the same field the Is Not Null isn't necessary. Watch out for this, is this is your problem:

http://support.microsoft.com/default.aspx?scid=kb;en-us;209778

Yes, that was the problem. I made some adjustments, and re thought what I wanted and came up with solution.

Thanks so much

 

[pbaldy]

Happy to help.