DateDiff Function

[Nixx1401]

I am trying to use the DateDiff Function but the text box where the function is located is returning the error #Name?

This is what I have in the text box
=DateDiff("d",[dteStartDate],[dteEndDate])

Attached is the database. In the frmOfficerInfo

[orange]

You have no data in your tables.
There is nothing to relate.

What were you expecting to happen? Perhaps there are some options.

[Nixx1401]

I have inserted some data in the the database and reattach. Sorry for the Inconvenience.

[orange]

Your tables are not populated. There is no linking data in the
tblTransaction.

Try this query on your TblTransaction

SELECT tblTransaction.[strID#]
, tblTransaction.dteEntryDate
, tblTransaction.dteStartDate
, tblTransaction.dteEndDate
, DateDiff("d",[dteStartDate],[dteEndDate]) AS Diff
FROM tblTransaction;

Your Datediff works.

To have your main form and sub formed linked, you must have matching data values in theLinkFields.

Yu need the registration Number populated on the transaction table

[Nixx1401]

thx included registration number in subform and Date function worked