Search results

Yes success SELECT DateValue(DateOfCal)+182 AS NextCal FROM TblCalibItems; Things is I need to use another column (MonthsCal) for the integer number of months and sometimes may include Feb etc... so really need to use a function that can do all this accurately...

sorry I did mention in my 3rd post... I wasn't sure if it was significant or not :-) I assumed the drivers would "just" run it on Access ...

Then if I use with DateAdd I get [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. SELECT DateAdd("m", 6, DateValue(DateOfCal)) AS NextCalibration FROM TblCalibItems;

Not sure what a pass-though query is... I am sending the query to this method in PHP if that helps? /////////////////////////////////////////////////////////////////////////////////// // db_query - this does global error handling... all subsiquent chould use this...

[Microsoft][ODBC Microsoft Access Driver] Undefined function 'Nz' in expression. SELECT DateAdd("m", 6, DateValue(Nz([DateOfCal], Date()))) AS NextCalibration FROM TblCalibItems; And tried: [Microsoft][ODBC Microsoft Access Driver] Wrong number of arguments used with function in query...

I used DateValue() to convert. Got a syntax error I removed the ";" and put ","... fixed the syntax error... then [Microsoft][ODBC Microsoft Access Driver] Undefined function 'Nz' in expression. SELECT DateAdd("m", 6, Nz(DateValue(DateOfCal), Date())) AS NextCalibration FROM TblCalibItems...

The query does have "m" ... it's after it's interpreted that it goes to [m]... fixed the second , ... thanks So the query is: SELECT DateAdd("m"; 6; Nz([DateOfCal]; Date())) As NextCalibration FROM TblCalibItems; Response: [Microsoft][ODBC Microsoft Access Driver] Syntax error in query...

thank you for baring with me! I tried (I tried single quotes too)- SELECT DateAdd("m"; 6; Nz([DateOfCal], Date())) As NextCalibration FROM TblCalibItems; Syntax error in query expression 'DateAdd([m]; 6; Nz([DateOfCal], Date()))'.

Ahh I see, super useful to know... (I am running this via ODB remotely on a database I did not create, so I am quite disconnected form the things, and I normally use mysql... so not up to speed yet...) I ran the above query: SELECT DateAdd("m"; 6; IsNull([DateOfCal], Date())) As...

:ROFLMAO: I have no idea what this means...

Thanks Ahhh starting to make some sense, not sure how to check if it is null (it didn't recognize Nz) I tried: SELECT DateAdd("m", 6, IsNull([DateOfCal], Date())) As NextCalibration FROM TblCalibItems; I got - Wrong number of arguments used with function in query expression 'DateAdd([m], 6...

Hi I am trying to run the following query: SELECT DateAdd("m", 6, DateOfCal) FROM TblCalibItems; IE adding an integer number of 6 months to a date DateOfCal. Any pointers? Thanks

Thank you :-) ... is great to find such a friendly knowledgeable community...

Thank you both so much... We will be stepping away from Access longer term... in the mean time, guess I need to keep my code tight!

Hi All, (this is my first post!) I am connecting to a customers MS access database, with a web interface via ODBC drivers (and PHP). To connect to the database I have the path. But it seems literally any username and password combination will let me in! Can you advise where this is...