Thank you very much
"MacDermott" <macdermott@nospam.com> wrote in message news:<FPAOb.13982$i4.8487@newsread1.news.atl.earth link.net>...[color=blue]
> Below is probably the syntax you want.
>
> But if you're going to work with this kind of thing, I'd really recommend
> that you try to understand it.
> It's not hard to count parentheses and see which kind you have more of.
>
> HTH
> - Turtle
>
> set rs1 = db.openRecordset("SELECT DISTINCT * FROM
> tblTenantTransaction
> WHERE TenantID = " & rs("TenantID") & " AND (datePart("m",[TransDate])
> = " &
> priorMonth & " and datePart("yyyy",[TransDate] = " & transYear & "));")
>
> "Hasanain F. Esmail" <hasanainf@yahoo.com> wrote in message
> news:27c08a7a.0401172114.f0fa62c@posting.google.co m...[color=green]
> > Thanks for your help.
> >
> > Pardon my poor understandign of VBA and SQL
> >
> > Can you please show me the systax
> >
> >
> > "MacDermott" <macdermott@nospam.com> wrote in message[/color]
> news:<AMaOb.11968$i4.4926@newsread1.news.atl.earth link.net>...[color=green][color=darkred]
> > > There's no closing parenthesis to match the one that's opened after[/color][/color]
> AND.[color=green][color=darkred]
> > >
> > > HTH
> > > - Turtle
> > >
> > > "Hasanain F. Esmail" <hasanainf@yahoo.com> wrote in message
> > > news:27c08a7a.0401170157.451bcc91@posting.google.c om...
> > > > Hi All
> > > >
> > > > My many thanks to DFS for helping me with my problem.
> > > >
> > > > I had posted my problem a few weeks ago and DFS helped me out with the
> > > > code.
> > > >
> > > > After having completed my other project, I got time to work on this
> > > > problem.
> > > >
> > > > However, a part of this code is giving me a problem and I have a
> > > > feeling that either and a parenthesis is missing or there is an extra
> > > > parenthesis but I dont know which.
> > > >
> > > >
> > > > This is the code:
> > > >
> > > > 'LOOK FOR PRIOR MONTH PAYMENT
> > > > set rs1 = db.openRecordset("SELECT DISTINCT * FROM
> > > > tblTenantTransaction
> > > > WHERE TenantID = " & rs("TenantID") & " AND (datePart("m",[TransDate])
> > > > = " &
> > > > priorMonth & " and datePart("yyyy",[TransDate] = " & transYear & ");")
> > > > .
> > > >
> > > > When I compile this code I get the following error msg
> > > > Compile Error
> > > > Syntax Error
> > > >
> > > > My many thanks in advance to all of you for your help.[/color][/color][/color]
