Comments by shyam2020

shyam2020 25-Nov-13 10:54am View

Thanks a ton Mike! I will set the query with (now - 1) and (now + 16). :)

shyam2020 25-Nov-13 10:09am View

Actually, when opened via MS Access, I don't see any time component, although, while pulling the data in Query builder, I saw the date was along with the time component..

Will that be a problem, also by removing the '=' symbol and increasing the numeric, what actually happens? Thanks.

shyam2020 25-Nov-13 10:06am View

Hi Mike, Thank you so much for the code! I got the query working below:
WHERE (CPREdt >= now) AND (CPREdt <= now + 15)

For some reason Access is not willing to recognize CURDATE and yes, DATEADD is allowed in Access, but it kept giving me errors. The above method with 'Now' is viable... :)

shyam2020 25-Nov-13 9:40am View

Uhm, no, it shows the same error: Undefined function 'CURDATE' in expression.
I checked the link you provided and do see the Date Time functions for available for Access, but why is it not being accepted in the Query builder?

shyam2020 25-Nov-13 9:25am View

Hi..Nope, it say: Same error except for the message which now says:

Undefined function 'TODAY' in expression.

shyam2020 25-Nov-13 9:10am View

Hi!

Thanks for the code, I tried with the same but it still doesn't work..
Another error message is being displayed instead.:

SQL Execution Error.

Executed SQL statement: SELECT CPR, FName, LName, CPRIdt, CPREdt, nation, Gender FROM Emo_master WHERE (CPREdt >= NOW()) AND (CPREdt <= dateadd([day], 15, NOW()))

Error Source: Microsoft Access Database Engine

Error Message: No value given for one or more required parameters.

shyam2020 25-Nov-13 8:50am View

Thanks for the reply. Although it still doesn't work, there is a change in the error message now. It now only shows the below:

Error in WHERE clause near ')'.
Unable to parse query text.

I'm still wondering where is this mysterious ')' ??

shyam2020 25-Nov-13 8:35am View

Sorry for the typo, actually there is no space between the DATEADD and the opening parentheses. I just copied the query from the Query Builder and the space just appeared in this page.

shyam2020 25-Nov-13 8:17am View

I get the error in the query builder.

"SQL Syntax Errors Encountered"

The following error were encountered while parsing the contents of the SQL pane:

Error in WHERE clause near ')'.
Error in WHERE clause near ','.
Unable to parse query text.

What can this mean? I couldn't find any syntactical errors in the query though..

Comments by shyam2020 (Top 9 by date)