Find dates in multiple fields

[Kimm]

Hi All,

How can I find a date range in multiple fields? Example...I have 24 date fields and I have to pull all the records between 01/01/2007 and 01/31/2007? I have to do this for each set for each month. Please help! ;)

Edited July 10, 2007 by Guest

[comment]

Put the dates in another table, where each date (or pair of dates, according to your previous description) is a related record.

[Kimm]

I have been trying to figure out separate tables forever. I get so close but it never works. I always feel if I could get it to work that I could understand and it would finally click in my head. IS there any other way to do this in one table? I created an if statement with a range of 1/2007 then to flag with January 2007 and it gives me everything no matter what the date.

[comment]

It's possible to do it in one table - but it would a cumbersome patch trying to cover a basic design flaw. You just need to learn about relationships. See if the attached file can get you started.

Related.fp7.zip

[Kimm]

Well I didn't think that would ever be possible but it worked! I can't thank you enough. I did the same thing that you had in your database, the only thing that I can't get to work is the cStartMonth and name (company) won't show on the preview of the report? It shows in Browse, breaks it down properly by month. I made sure the layout was in the new table and did the sub-summaries the same? Any ideas?

[Kimm]

OK Nevermind, I realized what I did wrong. It works now!! THANK YOU FOR ALL YOUR HELP!!