Access 2003 Query Calculation

jorgan · Joined: 28 Mar 2005 Posts: 65

I wrote query in Access 2003 that calculates difference between two days and gives result in days. Query looks like this: “DateDiff(“d”,[strCutDate],[Now()])+1”. The problem is that Access asks me to input value for Now(). I do not know why is this happening because Now() is a function that gives current date, right? Do you have solution for my problem with this query?

marijn · Joined: 16 Apr 2007 Posts: 3

Hello. The solution for your problems with Access 2003 query calculation is simple. Your problem is caused by syntax error. Instead if [Now()], which tells Access that this is control and not a function, use Now() (remove []) which represents function. Even better option is to use Date() function because you are not calculating difference between exact time of the day but between whole days. So, your query should look like this: “DateDiff(“d”,[strCutDate],Day())+ 1”

H-Desk.com - PC Security matters - Protect your PC privacy

Access 2003 Query Calculation

LIFEFORM SOCIAL COMMUNITY NETWORK