my report form.

[chaosguy]

I have a report form that basically allows me to generate some reports. How to exlain this. Okay, well i got to text box were the customer types in a start date and an end date. After clicking on a buttom called generate, a repot should generate with orders between those two dates. A query is used to filter out orders between the two dates. so the report is linked to the query. When i click the generate button, the report should be generated from the query based on the orders between the two dates that i entered into the text boxes "start date" and "end date" anyone have an idea of how i can go about doign this? Also can you give me the criteria to put into the "order date" field in the query. the input mask is mm/dd/yyyy.

I also need to generate a report that gives the status of an order. I know the critia to put into the query, and when i open it it prompts me for the field like it should. However, I need the codes so that i can generate a report usuing the field i entered into the text box, without it promting me for the status. Any help?

thank you in advance

Chaosguy - To die would be an awefully big adventure.

 

[Pampers]

Hi chaosguy,
Have a look at parameter query's. Base your report on such a parameter query. The values you enter in this query can then be reused in the report.


Pampers -

you're neven too young to learn

 

[chaosguy]

hey ya peeps, i think I figured a way out. thank for ur help. well thanks to pampers really, but yeah . bye

Chaosguy - To die would be an awefully big adventure.