day dependent query

[emitecaps]

Hi,

i want to find all records in my database for a particular issue date.
the issue dates are weekly, every saturday format dd/mm/yy
i want to run this query to show all bookings in the table 'Use' appearing for this weekend.
Eg. if today is 19 may it would find all bookings for 21 may.
the query could be run anytime between monday and friday
i'm trying this but it isn't working....any suggestions?
i think it's the bit after weekday that's causing the problems...but i'm not sure!

SELECT Use.*, Use.[Issue Date]
FROM Use
WHERE ((Use.[Issue Date])=Weekday(Date())+2);

 

[PHV]

WHERE Use.[Issue Date] = (Date - Weekday(Date) + 7);

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[emitecaps]

thanks...that's really helpful!