Re: Variable in SQL statement
From: Al Reid (areidjr_at_reidDASHhome.com)
Date: 02/26/04
- Next message: Larry Daugherty: "Re: Environment Variables in Access 97 Link Path"
- Previous message: Don Starkey: "Variable in SQL statement"
- In reply to: Don Starkey: "Variable in SQL statement"
- Next in thread: Val Mazur: "Re: Variable in SQL statement"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 26 Feb 2004 16:45:59 -0500
deSVLG.rscmdIGArpt.Open "SELECT Address, City, FirstName, IGADate, IGAFee,
LastName, MemberNo, StateZip, Remarks FROM SvlgMain WHERE MemberNo >= " &
MemNo
"Don Starkey" <imdonnie@msn.com> wrote in message
news:eUoywvK$DHA.808@TK2MSFTNGP12.phx.gbl...
> I have a SQL statement:
>
> deSVLG.rscmdIGArpt.Open "SELECT Address, City, FirstName, IGADate,
IGAFee,
> LastName, MemberNo, StateZip, Remarks FROM SvlgMain WHERE MemberNo >= (
> MemNo)
>
> Where (MemNo) at the end is a variable integer
>
> I can operate the program OK by using MemNo as a Parameter in the data
> designer, but would prefer to use the variable in the text recordset
> opening.
>
> Can a variable be used in a SQL statement, and if so, how?
>
> Thanks
>
>
- Next message: Larry Daugherty: "Re: Environment Variables in Access 97 Link Path"
- Previous message: Don Starkey: "Variable in SQL statement"
- In reply to: Don Starkey: "Variable in SQL statement"
- Next in thread: Val Mazur: "Re: Variable in SQL statement"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
