Ive Created a Access Data Base, and on my main table I have a field titled "Date Entered", which has the lists the date the record was created (through date() formula). What I want to do is have another field in that table that caculates the difference in days from the "date entered" column to the current date. I was using the formula:
datediff("dd", [date entered], date())
I am receiving the the error of "does not recognize the field "date entered", I think I have all the same format for the dates, but am really stumped by this one, so if anybody can give any suggestions to get this caculation, please let me know, this is my first database.