Access 2k SQL Statement

[HallMonitor89]

I am trying to get the SQL statement right for querying an Access 2k
database

I would like to obtain the first record of Event A and the last record
of Event B of each day.

This is what I have for a query. When I run it, I get "Syntax Error
(Missing Operator)in query expression LAST [Table].[Event]" (Table name
has been changed to protect the guilty)

SELECT TOP 1 [Table].[Event], [Table].[Customer], [Table].[Date&Time]
FROM Table
WHERE ((([Table].[Event])="FirstEvent") And
(([Table].[Customer])="ACME") And
(([Table].[Date&Time])=DateValue("December 15, 2003")))
UNION SELECT LAST [Table].[Event], [Table].[Customer],
[Table].[Date&Time]
FROM Table
WHERE ((([Table].[Event])="Final") And (([Table].[Customer])="ACME") And
(([Table].[Date&Time])=DateValue("December 15, 2003")))
ORDER BY [Table].[Date&Time];


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Ray at]

Try:

LAST([Table].[Event])

or also use TOP 1 in conjuction with ORDER BY something DESC

Ray at home

"HallMonitor89" <nospam@novirus.com> wrote in message
news:OPX3ccPxDHA.1364@tk2msftngp13.phx.gbl...

>
>
> I am trying to get the SQL statement right for querying an Access 2k
> database
>
> I would like to obtain the first record of Event A and the last record
> of Event B of each day.
>
> This is what I have for a query. When I run it, I get "Syntax Error
> (Missing Operator)in query expression LAST [Table].[Event]" (Table name
> has been changed to protect the guilty)
>
> SELECT TOP 1 [Table].[Event], [Table].[Customer], [Table].[Date&Time]
> FROM Table
> WHERE ((([Table].[Event])="FirstEvent") And
> (([Table].[Customer])="ACME") And
> (([Table].[Date&Time])=DateValue("December 15, 2003")))
> UNION SELECT LAST [Table].[Event], [Table].[Customer],
> [Table].[Date&Time]
> FROM Table
> WHERE ((([Table].[Event])="Final") And (([Table].[Customer])="ACME") And
> (([Table].[Date&Time])=DateValue("December 15, 2003")))
> ORDER BY [Table].[Date&Time];
>
>
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!