Print reports by date range from multiple fields

[pittypat]

I have a database that I created to act as a schedule report. In the main table 12 of the columns are the months of the years, and listed as Jan, Feb,...and so on. The data entered to these fields is an actual date i.e 2/15/01. I know it sounds like a strange way to layout the table but visually it works well because the user can look at a whole year at a glance. Here is my dilemma, because of the volumn of date I need to be able to print by date range. How can I set a criteria that will look for a date range across 12 different fields? Or have I painted myself into a corner. Thanks for the help.

PittyPat

 

[MichaelRed]

Painted? More like GLUED | Cemented ...

I think it is a HUGE mistake to do what you have described.

Dbs are NOT for " ... easy viewing ... ". That is what forms / reports are for.

Current data base design favors depth over bredth, so you are DEFFINITLY going aginst the tide here.

Stop.

Back up (to the starting point).

Get a book on relational database design.

Read it.

Read it again.

Start over.

Have I said it clearly?


MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over

 

[pittypat]

Yes, you have clearly indicated that you are a jerk! Your not as smart as you think you are and your comments to my question show you are full of yourself. I had a simple question that you could not answer. If you don't know the answer just don't reply.

 

[buzcut]

PittyPat-

Indeed I think you're in a little bit of a bind here. What you're talking about is multiple field parameters that realistically should be only one parameter. I've never done a DB like yours in that fashion, and I've never tried such a complex parallel query.

I'm not sure if you know this, but if your date was in just one field, say txtDate, then the criteria would simply be "Between #01/01/01# And #12/01/01#".

I'm going to try your request, and if I am successful, I'll give you a holler.

buzcut