List times in 30 min increments 1

[LakotaMan]

Hi all, I need to create a blank "worksheet" for a client. This report should have times in 30 minute increments, starting from a value taken from a form, and then a space beside each time for a reading.

The client wants to print the report and then write down the readings next to each time. Later, this info will be transferred to a readings table I have in the database.

Something like this:


Time Reading

4:30 am reading data
5:00 am reading data
5:30 am reading data

etc.

What concerns me is that the beginning time will be a variable, and I don't know how to set this up on an unbound report.

Any help you can give me on this will be greatly appreciated, as always.

Tru

 

[Blorf]

You have a time field on a form, and a report that references the time field?

If so, in your report, you refer to the form like this:

=Forms!YourForm!Time

(Time being the name of the field on the form).

In the report, on each line (You mention unbound) do this:

=[Forms]![form1].[Time]+TimeValue("00:30 AM&quot
=[Forms]![form1].[Time]+TimeValue("01:00 AM&quot
=[Forms]![form1].[Time]+TimeValue("01:30 AM&quot

And so on.

ChaZ

Ascii dumb question, get a dumb Ansi

 

[LakotaMan]

ChaZ, that is beauteous-- Works like a charm.

--Thank you so much!!!
Tru

 

[Blorf]

You are quite welcome.

May the force be with you.

ChaZ

Ascii dumb question, get a dumb Ansi