I am creating a small database to use for my clinical audit data collection analysis.
I have created the main data table.
Created a simple query
The table contains date of birth field and date patient seen.
DateDiff function used to calculate Age in the query.
The Age field works ok in the query.
However this fails to insert in the table.
If I manually enter data in the query it inserts ok. But the DateDiff won't insert into table.
Will need some help with other functions too.