Week Report

[timdodgson]

Hi every one

I am very new to this so thanks in advance for any help
The problem is
I have a simple access database with a two tables one holds customer informatio the other holds transaction information
what i want to do is a weekly report
the nearest i have got i think is
strSQL="SELECT * FROM sub WHERE DATEPART('ww', datevisit) = "& db_weekly_report &";"
db_weekly_report is populated from, a form
datevisit is a colum name in the database which is set to date/time

Any help PLEASE

oh sorry to say this query returns no records



Tim Dodgson
timdodgson@msn.com

http://www.timdodgson.co.uk

 

[Sheco]

I find it easiest to get the query working in Access before you add the ASP element to the mix.