critiera

[Chey]

How do I get the box to appear when i open my report? I want it to ask for
month year so I can type in for example 10/2007.

Thanks

 

[Jeff Boyce]

One approach would be to add a control on the report and set its
ControlSource to something like (untested):

=[enter a mm/yyyy]

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Chey]

I have a field in my report that it is suppose to query it by though. I have
done the between dates but I don't need multiple date. I just need one. I
believe I put it in the critiera before.

Thanks

One approach would be to add a control on the report and set its
ControlSource to something like (untested):

=[enter a mm/yyyy]

Regards

Jeff Boyce
Microsoft Office/Access MVP

How do I get the box to appear when i open my report? I want it to ask
for
month year so I can type in for example 10/2007.

Thanks

 

[Chey]

I got it to work.

Thanks

One approach would be to add a control on the report and set its
ControlSource to something like (untested):

=[enter a mm/yyyy]

Regards

Jeff Boyce
Microsoft Office/Access MVP

How do I get the box to appear when i open my report? I want it to ask
for
month year so I can type in for example 10/2007.

Thanks