PC Review


Reply
 
 
Chey
Guest
Posts: n/a
 
      4th Jan 2008
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
 
Reply With Quote
 
 
 
 
Jeff Boyce
Guest
Posts: n/a
 
      4th Jan 2008
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" <(E-Mail Removed)> wrote in message
news:E335C641-0000-4E11-91DE-(E-Mail Removed)...
> 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



 
Reply With Quote
 
Chey
Guest
Posts: n/a
 
      4th Jan 2008
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

"Jeff Boyce" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:E335C641-0000-4E11-91DE-(E-Mail Removed)...
> > 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

>
>
>

 
Reply With Quote
 
Chey
Guest
Posts: n/a
 
      4th Jan 2008
I got it to work.

Thanks

"Jeff Boyce" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:E335C641-0000-4E11-91DE-(E-Mail Removed)...
> > 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

>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple Critiera Sum Array - One critiera to be between two numbers Forgone Microsoft Excel Worksheet Functions 3 29th Jul 2008 11:27 AM
Summing based on various critiera NeedHelpFast Microsoft Excel Worksheet Functions 13 23rd Mar 2008 04:24 PM
Query Question-Critiera =?Utf-8?B?Q2hleQ==?= Microsoft Access Queries 0 15th Dec 2006 01:29 AM
critiera =?Utf-8?B?Q2hleQ==?= Microsoft Access 3 26th Jul 2006 01:15 AM
Countif With Critiera JR573PUTT Microsoft Excel Misc 4 15th Feb 2006 07:08 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:43 AM.