Re: Need expression for next month's expirations??

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On Sun, 9 Sep 2007 08:36:01 -0700, SilverTip 147 wrote:

Thanks Fred for replying!!
However, it's not working yet!
This is what i typed:

[RBWA Enrolment Table] Where Format([RBWA Expiry Date],"mm/yyyy") =
Format(DateAdd("m",1,Date()),"mm/yyyy")

This is the error message I get:
"The expression you entered contains invalid syntax. You have ented an
operand without an operator."

Any suggestions?
Thanks again!
"fredg" wrote:

On Sat, 8 Sep 2007 05:42:01 -0700, SilverTip 147 wrote:

I'm using Access 2003.
I am a new user who si trying to build an expression for this query:
Whose membership expires next month??
So far I have: [RBWA Enrolment Table]![RBWA Expiry Date]

How do I finish this expression?
I am using the short form for dates?
Thank you for your help?

Select [RBWA Enrolment Table].* from [RBWA Enrolment Table]
Where Format([RBWA Expiry Date],"mm/yyyy") =
Format(DateAdd("m",1,Date()),"mm/yyyy")

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail


You have posted an incomplete statement.
In Query Design View, click on View + SQL View,
Please copy and paste into a reply message your EXACT complete query
SQL.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
.

Relevant Pages

  • Re: Jet SQL and Virtual tables/subqueries qiestions
    ... Perahps we've begin to uncover some bugs in the Access query ... If you PASTE SQL test in the following format into the SQL window ... around a field or table name within the VirtTbl1 subquery, ... I would think that producing a correct error message for that sort of query ...
    (microsoft.public.access.queries)
  • Re: How do I temporarily limit values in a query field
    ... I am getting an error message: "The expression you entered has a invalid ..or! ... This is the last few lines of the 'old' sql with an attempt to limit the records to values of <500: ... works fine until I try to put limits on it value in the qryClaimDetails query. ...
    (microsoft.public.access.queries)
  • Re: Delete Records From One Table that are Duplicated in Another
    ... Your error message indicates Access / JET think there are 2 Tables involved ... Post your Table Structure and the SQL String of your Query. ... I linked them on the Loan# ...
    (microsoft.public.access.queries)
  • Re: 3061 Error when doing everything that works in another module.
    ... Error message states that 1 parameter is expected. ... > I assume that the SQL statement is a properly delimited text string in your ... is this a reference to using the design view ... > of a query to create the SQL statement and to run the query? ...
    (microsoft.public.access.modulesdaovba)
  • Re: 3061 Error when doing everything that works in another module.
    ... built the SQL string in the query designer. ... > Error message states that 1 parameter is expected. ... >> of a query to create the SQL statement and to run the query? ...
    (microsoft.public.access.modulesdaovba)