Do you have a field named "Date"? If so, that is what could be causing you
problems. You should name your field in your table something like MyDate or
whatever describes the date.
| Hi Debbie,
|
| That's the way I did right now. For some reason when query runs with all
of
| these static information in there, it is very slow. for example: Date, can
I
| grab the date information from other place. I tried to add a text box on
one
| form called txtDate, the form name is form1. And on the report, I put the
| expression on date field, =[forms]![form1]![txtDate].value and it gives me
| the invaid name. If you can tell me what's wrong with it. That would be
| great help.
|
| Thanks,
| Sarah
| | > If I understand you correctly, it sounds like you need to add the table
| > with
| > this information to your query. Then in your page header you can use
the
| > fields from your query.
| >
| >
| > | > | For example, I like name, address show in page header.
| > | Thanks,
| > | Sarah
| > | | > | > Static information such as what?
| > | > Where do you want this information to appear?
| > | >
| > | >
| > | > | > | > | Hi,
| > | > |
| > | > | I have a report created based on one query named sales query which
| > | > includes
| > | > | all the information that I need on this report. I like to show
some
| > | > static
| > | > | information on the report, can I get them from other query or
table?
| > | > |
| > | > | Thanks,
| > | > | Sarah
| >
|
|
