Having trouble with SELECT statement on a query

[Diamond]

I am having a very difficult time trying to figure out how to write out a select statement in a query. I was told previously to use DATEADD to add days to a check box. I would like to add, say, 365 days to a check box and have it show the next test date. I really don't have any idea how to write it out. I am putting the following into a query in the field name: SELECT [AcctNo], [SerialNo], DATEADD(day,365,LastTestDate) as NextTestDate from TestHistorytbl. I keep getting an error message saying: You have written a subquery that can return more than one field without using the EXISTS reserved word in the main query's FROM clause. Revise the SELECT statement of the subquery to request only one field. I don't know what all this means and I need help. Any help is appreciated.

[jzwp11]

You said that you are trying to add days to a check box. Is that correct? Technically you can do that but you would most likely end up with a date of 1/1/1900 which is probably not of any value.

I am going to assume that your field LastTestDate is a date field, and as such, the query would look like this

SELECT [AcctNo], [SerialNo], DATEADD("d",365,LastTestDate) as NextTestDate
FROM TestHistorytbl

The "d" tells the function the interval( "d"= days). You can use "yyyy" for year, "m" for month, "q" for quarter (check out the help section to find out what other intervals are available.