Not sure if i am wording it right.

In a query i have calculated field that is using Date().
Instead of Date() I want to use a value in a table that only has 1 record.
How can i reference that table ?

Well, you could use the DFirst() function to retrieve the value

eg,

DFirst("[FieldNameHere]","TableNameHere")

Well, you could use the DFirst() function to retrieve the value

eg,

DFirst("[FieldNameHere]","TableNameHere")
great !!!!
thanks

Happy to help :)