too many fields

[PROXI]

Ok... My manager has just asked me to make a report for her that has too many fields to fit into a query. I need to generate a report from this query to give to her. Is there a way that I can make 2 queries and then merge the 2 onto a report. If so, Is there a way that I can do this using dialogs in the query criteria (ex. between [Enter start Date:] and [Enter End date:]), or would I have to use a form so that it will have a filed that both queries could look back to and not have to reinput the data. If anyone can help me out on this I would appreciate it.

There are 17 fields in my report that need to be there btw.

Thanks,

PROXI

 

[CajunCenturion]

17 fields should not present a problem. I would verify that all the field names are properly spelled, and if you're still getting an error, let's post the query and take a look at it.

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[Blorf]

Agreed. 17 fields is pretty small. My record is actually in the hundreds.

Can you describe in more detail the problem with the number of fields?

CajunCenturion is probably write with his suggestion, but maybe we can spot something.

ChaZ

Ascii dumb question, get a dumb Ansi

 

[PROXI]

I actually ended up fixing the problem. The problem was not that it wouldn't fit on the report. It was that in a querie, there are only 16 fields to fill in. I just used expressions, and combined fields where I could to take up less spaces. But thank you for your responses

Thanks,

PROXI