Queries for due date and N/A

[blueman9]

Hi, I am building a 2007 Access database to track peoples currencies and when they are due on training. Part of the tracker is to make a query that shows all due dates in a datasheet view. I have found a really easy way to take thier date completed and add 1 or 2 years to the date to show when they are due as needed like so:

DueDate: DateAdd("yyyy","2",[MasterData]![ThingDue])

And that works perfectly and does exactly what I need it to, but here is where I run into my problem. Certain people do not require every peice of training and so in their columns I have been putting N/A. When the query runs on a column that has people in it that are N/A it gives me this message.

"Enter Parameter Value"

I know it is looking for a date, and I don't have one there, so I was wondering if you guys had any suggestions on how to make it pass along the N/A's and still add the time to the fields that have dates in them? I tried an IIf statement but I am not sure how to put an expression in an expression... Once again thanks for any help or advice.

[Robeen]

The 'column' [is it in a Table?] in which you are putting "N/A" . . . is it a Date field? In other words - are you putting Text in a Date/Time field in your Table?
Could you send a screenshot of your query in design view?
Usually that "Enter Parameter Value" means that the Query is expecting a value and is not getting a legitimate value . . .