Excel - Querytable - SQL

[si_the_geek]

Assuming you have a Where clause, this condition will check for "between 07:00:00 and 20:00:00 "yesterday" ":

DateField Between (DateAdd('d', -1, Date) + #7:00:00#)  And  (DateAdd('d', -1, Date) + #20:00:00#)

...I'm not entirely sure if DateAdd is apt for this, but it hopefully will be (it is supported by Jet, which I presume is what is used).

[Mitch_s_s]

Spot on Si!

Not in work till Thursday now, so I'll check it out then and will let you know!

Thanks!

Mitch

[Mitch_s_s]

This is the string I've got when my code runs

can see you what the error is?

It's connects to an access database, my SQL isn't too hot!

Is there any where I could learn more advanced stuff like this?

SELECT * FROM PRDADMIN_EVENT WHERE (((PRDADMIN_EVENT.EVENTTYPEID)="RNDZ") AND ((PRDADMIN_EVENT.DATEEVENT) Between (DateAdd('d', -1, Date) + #7:00:00#)  And  (DateAdd('d', -1, Date) + #20:00:00#) AND ((PRDADMIN_EVENT.DESCRIPTION)="Reply Received - Outstanding = 0"));