Sql Statement problem with a Date() - number of days

[ynott]

I have a SQL Statement that I'm having a problem with:

Dim sSQL As String, sLen As Integer, stCaption As String, sAgeB As
Integer

sAgeB = 777

sSQL = "SELECT [Qry_All_Reg].* FROM [Qry_All_Reg] WHERE "

'sSQL = sSQL & " [Qry_All_Reg].[DOB] < now() - sAgeB AND"
sSQL = sSQL & " [Qry_All_Reg].[DOB] < now() - 777 AND"
The line with the "now() - 777" will work, but the line before it will
not. I made sAgeB equal to 777 and made sAgeB an Integer but it
doesn't work.

What am I missing?

TIA

[Jeff Pritchard]

Should be

sSQL = sSQL & " [Qry_All_Reg].[DOB] < now() - " & sAgeB & " AND"

Jeff

<ynott> wrote in message news:1b********************************@4ax.com...

I have a SQL Statement that I'm having a problem with:

Dim sSQL As String, sLen As Integer, stCaption As String, sAgeB As
Integer

sAgeB = 777

sSQL = "SELECT [Qry_All_Reg].* FROM [Qry_All_Reg] WHERE "

'sSQL = sSQL & " [Qry_All_Reg].[DOB] < now() - sAgeB AND"
sSQL = sSQL & " [Qry_All_Reg].[DOB] < now() - 777 AND"
The line with the "now() - 777" will work, but the line before it will
not. I made sAgeB equal to 777 and made sAgeB an Integer but it
doesn't work.

What am I missing?

TIA

[Alex]

ynott <> wrote in message news:<1b********************************@4ax.com>. ..

I have a SQL Statement that I'm having a problem with:

Dim sSQL As String, sLen As Integer, stCaption As String, sAgeB As
Integer

sAgeB = 777

sSQL = "SELECT [Qry_All_Reg].* FROM [Qry_All_Reg] WHERE "

'sSQL = sSQL & " [Qry_All_Reg].[DOB] < now() - sAgeB AND"
sSQL = sSQL & " [Qry_All_Reg].[DOB] < now() - 777 AND"
The line with the "now() - 777" will work, but the line before it will
not. I made sAgeB equal to 777 and made sAgeB an Integer but it
doesn't work.

What am I missing?

TIA

take sAgeB out of the speech marks i.e.
sSQL = sSQL & " [Qry_All_Reg].[DOB] < now() - " & sAgeB & " AND"