If Time then report number using Now()

[TheToeOfPooh]

After some thought and advice from this board (thanks Andrew) I have been asked to see if the following is possible.

I am trying to produce a calculation that uses Now() to number reports.

If the report is run between midnight last night and mid day today (am) the number will be 1

If report is run between mid day and midnight today (pm) the number will be 2.

Can this be done and if so how would I do it please?
Basically there should always be a report 1 and 2 run each day, more than once is acceptable so two sets of a report 1 will be fine.

Bernard

 

[Andrew Fergus]

Hi Bernard

Me again! You can calculate this on the report by adding a new text box into the header (or footer), and entering the following as the control source :

=IIf(Time()<=0.5,1,2)

You could add this field into the underlying query instead of the report using the same code.

Are you going to want to store this value in a table?

Andrew

 

[Andrew Fergus]

Plus you can combine the expression with text etc like this :

"Report Number " & IIf(Time()<=0.5,1,2) & " for " & Date()

Andrew

 

[TheToeOfPooh]

Andrew - You are a wonderful man

I have taken your first sugestion and everyone here is pleased with result.

We decided on just the number (as the reports already contain alot of images, text and data).

I used an unbound text box as sugested and viola!

Thank you for helping me again.

Bernard