Max Value in a Form Control

[thefonz37]

I have a database I'm designing to track data entry errors. On the
switchboard form of the database, I would like to add a text box at the
bottom to give a visual reminder of how current the data is in the database.

I tried adding a textbox and using the expression builder to make it equal
to: "=Max([tbl_All_Errors]![CORRECTION_DATE])", but when the form loads, the
value given is "#Error".

I also tried building a query to just grab the dates and then using the Max
function to pull out the Max of just that list of dates, but that hasn't
worked either.

What am I doing wrong?

 

[Noëlla Gabriël]

Hi,

check out the DMax function, beware alle the arguments have to be given as
strings though:

= DMax("CORRECTION_DATE","tbl_All_Errors")

 

[thefonz37]

Fantastic! Thanks so much.

Hi,

check out the DMax function, beware alle the arguments have to be given as
strings though:

= DMax("CORRECTION_DATE","tbl_All_Errors")


--
Kind regards
Noëlla

I have a database I'm designing to track data entry errors. On the
switchboard form of the database, I would like to add a text box at the
bottom to give a visual reminder of how current the data is in the database.

I tried adding a textbox and using the expression builder to make it equal
to: "=Max([tbl_All_Errors]![CORRECTION_DATE])", but when the form loads, the
value given is "#Error".

I also tried building a query to just grab the dates and then using the Max
function to pull out the Max of just that list of dates, but that hasn't
worked either.

What am I doing wrong?