Search results

as its just a select query, you will not update the field [Next_Visit_Date] you can only view the next visit date by using an expression in your query: add an extra column in the query and type in: Next Visit Date : [Last_Discharge_Date] + 90 this will display the next visit date, but not update...

to put a stop just type in STOP after the sql statement you can format the date as follows (just change bthe day and year around: Between #" & ReportStartDay & "/" & ReportMonth & "/" & ReportLastYear & "# AND #" & ReportEndDay & "/" & ReportMonth & "/" & ReportLastYear & "# )) " & _

I would firstly check the queries: run query "delFacilityHits" manually followed by query "ApdFacDistAll" and see if they work ok. if its worked before, then i would guess that the queries have changed more than likely they just selct queries rather tha ction queries ie updated/append.

assuming Last_Discharge_Date and Next_Visit_Date are of date types then this would do it: [Next_Visit_Date] = [Last_Discharge_Date] + 90 ow are you trying to do this: is it an update in a query? a textbox on a form or in VBA?

Could well be the date variable in the sql statement: Between " & ReportLastYear & ReportMonth & ReportStartDay & " AND " & ReportLastYear & ReportMonth & ReportEndDay & " )) " & _ Dates are passed using the following format: Between #30/01/2009# AND #30/03/2009# so your...