Adding new field in access report 2

[nissan240zx]

Hello All,
I have created a report to display records. Simple..
To explain the scenario let me use these values.
Say the table name is "Data_Collection_2005", which I use to display my report called "Data Collection 2005".
This part works fine.
Now I have a query that updates dates (to store the last updated date value of data processing, which I call it "Last_Process_Date". This table has 2 fields (Process name, Date). Process name stores the name of the process and date ofcourse stores the date value.

Now I want to display the Date value from this table in my "Data Collection 2005" report.

Please advise. Thanks in advance.


Nissan 240ZX.

 

[THWatson]

Nissan
Can you add a text box and use the DLookup function?

Tom

 

[nissan240zx]

Hello Tom,
Say for example if my table name is Last_Process_Date and if the field name is Last_Mod_Date.
How do I display that field value in my report using DLookup.
Can you advice..

Thanks

 

[dhookom]

Is there only one record in the table Last_Process_Date? If so, add a text box with a control source of:
=DLookup("Last_Mod_Date","Last_Process_Date")

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[nissan240zx]

Duane,
You are genius.
Worked like Magic.

Wish I could give 5 stars for that.
Thanks..


Nissan 240 ZX...best Nissan Ever