Dates ARE Killing my BRAIN..>!!!

[paulmcdonnell]

Hi guys, Happy easter. (If you're of that persuasion)

I'm trying to extract the 1st day of the week for each week number on a report. Ie I have 10 records in week 14, 5 records in week 15 and 3 records in week 16. I now want access to tell me which weeks these are in 'English' e.g. week 14 means week commencing 01/04/02

I just can't seem to get this right and now I'm getting that 'going round in circles' feeling...


Any ideas guys??
Cheers

Paul

 

[David R]

Please post your questions in only one place, otherwise the help you receive may be fragmented and unhelpful, plus it may waste people's time. If you can't pick what Forum it belongs in, General is always a safe bet.

Try the response to your other thread here: http://www.access-programmers.co.uk/ubb/Forum1/HTML/007650.html

HTH,
David R