Re: Select Query By Month.

Tech-Archive recommends: Fix windows errors by optimizing your registry

It looks to me that the Parameter is:

[Date - (MM/DD/YYYY)]

in the WHERE Clause

I would simply change the WHERE Clause to:

.... WHERE [Invoice Date] BETWEEN [Enter StartDate (MM/DD/YYYY):]
AND [Enter EndDate (MM/DD/YYYY):]

You will also need to change the SELECT Clause as you referred to the (old)
Param in the SELECT Clause.

--
HTH
Van T. Dinh
MVP (Access)


"Terry" <Terry@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5FEE29E9-2AA3-44C0-A330-973D3C450F20@xxxxxxxxxxxxxxxx
> Van T. Dinh,
>
> I apologise for the delay in my response, meetings.
>
> I am sure that is where the problem originates, Unfortunately that was the
> only way that I could get it to identify the MONTH. Listed below is the
SQL
> of the [Accounts By Month Query].
>
> SELECT [Account Info Table].[Account Number], [Invoice Info
Table].[Invoice
> Number], [Invoice Info Table].[Invoice Date], [Date - (MM/DD/YYYY)] AS
[Date
> Entered], [Account Info Table].Attention, [Account Info Table].Message
>
> FROM [Account Info Table] LEFT JOIN [Invoice Info Table] ON [Account Info
> Table].[Account Number] = [Invoice Info Table].[Account Number]
>
> WHERE (((Month([Date - (MM/DD/YYYY)]))=Month([Invoice Date])) AND
> ((Year([Date - (MM/DD/YYYY)]))=Year([Invoice Date])))
>
> ORDER BY [Invoice Info Table].[Invoice Date];
>
> All assistance is appreciated.
> --
> Terry
>


.

Relevant Pages