Search results for query: *

got another function to work - now the problem is getting the data arranged the way I want it arranged... Weekly Report: Format(DateAdd("ww",DatePart("ww",[Date],1,3),#1/1/2002#),"mm/dd/yyyy") this function will seperate the dates in my db weekly starting from...

I need help with creating a query that will take the current date and return the data from the previous week - I cannot use [start date] [end date] in my criteria because I need to create a crosstab query after I have the one week of data selected....any ideas on how I may be able to get this done?

I need help with a query - I need to create a query that will use the current date and only pull records for the previous week - I will even take help with a query that will select the specified week . I need the week becasue once I have selected the week, I will then need to use a crosstab...

I am trying to set up a query to search by name and by dates....I am able to let the users search by dates by letting the users enter in the dates they want to search by - the problem I'm having is the user can't remember the names they want to search by, so I can't have them search by name,is...