reports

[Alice]

Hi there,
I've made a report in access, and one of the bits of data i want it to show is the date from a form. Trouble is the form automatically puts today's date unless you change it. This doesn't transfer to the report - it just puts a blank in its place.

Any ideas please?

Alice

 

[Corticus]

On 2002-12-12 11:16, Alice wrote:
Hi there,
I've made a report in access, and one of the bits of data i want it to show is the date from a form...

From where on the form are you attempting to retrieve a date? (txtbox, box with control source set to field on table, etc.)

Corticus
This message was edited by Corticus on 2002-12-12 11:23

 

[Alice]

[No message]

 

[Alice]

It's a text box, with a default value set to =date()......

 

[Corticus]

Okay,

Do you have the control source of the textbox set to a date field on the table from which you are generating the report? This should stamp every record with the date on which it was entered. If you put this field on the report it should give you a date for each record...is this what you want?

Corticus
This message was edited by Corticus on 2002-12-12 11:32

 

[Alice]

Sorted - corticus, you're a genius...!

love, alice

 

[Corticus]

On 2002-12-12 11:40, Alice wrote:
Sorted - corticus, you're a genius...!

love, alice

<img src = "http://www.linda-goodman.com/ubb/blushing.gif">

hardly!

Thanks, though, you made my day!

Corticus
This message was edited by Corticus on 2002-12-12 12:05