Re: Using SQL in Sub to fill box on mouseclick
- From: "Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxxx>
- Date: Tue, 10 May 2005 17:47:39 -0400
Your SQL statement is incorrect.
The WHERE clause comes before the GROUP BY clause.
>From the Help file:
SELECT [predicate] { * | table.* | [table.]field1 [AS alias1] [,
[table.]field2 [AS alias2] [, ...]]}
FROM tableexpression [, ...] [IN externaldatabase]
[WHERE... ]
[GROUP BY... ]
[HAVING... ]
[ORDER BY... ]
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"JayVZ" <jayvz@xxxxxxxxxxxxxxx> wrote in message
news:qJ9ge.46713$PA4.21447@xxxxxxxxxxxxxxxxxxxxxxxx
> In the form that I am working on, I have a number of text boxes that are
> filled with a query telling me which people are scheduled to work a shift.
> I also have a text box (I may need to make this a sub form, but would
> prefer not) where I want a list of all available employees for the
> specific shift to show. When I click, I want to see the list, so that I
> can make changes if needed and only chose those employees that are
> available for the shift.
>
> I have:
> Private Sub Ctl8a_4pb_Click()
> Me!txtAvailEmployees = "SELECT tblAvailabilities.Date, [First]+" "+[Last]
> AS [Full Name]
> FROM tblAvailabilities INNER JOIN tblStaff ON
> tblAvailabilities.EmployeeNum = tblStaff.EmployeeID
> GROUP BY tblAvailabilities.Date, [First]+" "+[Last],
> tblAvailabilities.Shift1
> HAVING (((tblAvailabilities.Shift1)=-1))
> WHERE tblAvailabilities.Date=[form]![frmScheduleEdit]![CalDate];"
> End Sub
>
> I get a syntax error. Is is even possible to pass SQL in a manner as this?
> If it is, where would I be messing up?
>
.
- Follow-Ups:
- Re: Using SQL in Sub to fill box on mouseclick
- From: JayVZ
- Re: Using SQL in Sub to fill box on mouseclick
- References:
- Using SQL in Sub to fill box on mouseclick
- From: JayVZ
- Using SQL in Sub to fill box on mouseclick
- Prev by Date: Re: On Current event?
- Next by Date: Remove filter after query on form
- Previous by thread: Using SQL in Sub to fill box on mouseclick
- Next by thread: Re: Using SQL in Sub to fill box on mouseclick
- Index(es):
Relevant Pages
|
