access DLOOKUP

[a.markogiannakis]

Hello I am new to access,

What I am trying to do is using the DLookUp Function to access data
from a table in my access database and present it in a access report.

On that cell this is the data contained

You are paid until the end of [Paid until] Thank you for your payment.

where Paid until is a variable in the report..How can i present this
variable??


Thanks

 

[fredg]

Hello I am new to access,

What I am trying to do is using the DLookUp Function to access data
from a table in my access database and present it in a access report.

On that cell this is the data contained

You are paid until the end of [Paid until] Thank you for your payment.

where Paid until is a variable in the report..How can i present this
variable??

Thanks

What is the field datatype of [Paid Until]?
I'll guess it's a Date datatype, not text.
How do you determine which record's date in the table is the correct
one?

In an Unbound text control on the report:

="You are paid until the end of " & DLookUp("[Paid
until]","Tablename","[CustomerID In Table] = " & [CustomerID In
Report]) & ". Thank you for your payment."

You'll need to enter the correct field and table names.
The above assumes [CustomerID] is a Number datatype.

Look up DLookUp in VBA help as well as
Restrict data to a subset of records.

 

[a.markogiannakis]

Thanks mate