Access Query: Count number of records in each week
Posted on 2006-11-27
I would like to create a query that counts the number of records in another query grouping them what week the records were entered. I know how to do the grouping and counting, but I don't know how to tell what week the record was entered. Please tell me how to add a field to my current query that will tell me what week the record was entered. I would like the weeks to start on Thursdays, and end on Wednesdays, and I would like the field to be named [Week]. The name of the query is [qry_master], the date field in my query is [DateAcpt], and the table the query is pulling from is named [tbl_Main]. Thank you in advance for your help, and please be aware that I am somewhat of a novice user. I need this ASAP, and I will be very grateful to the person that helps me out. Thanks, Jon.