Search results

I would run a query of that query that takes out the date and sums the total. emxpl: que1: date Total (datasheet view) 7/28/02 350 7/29/02 300 7/30/02 400 Query 2 will run of query 1 but will only include the total...

I just thought of something you could do, if you want you can set up 2 or 3 different reports that do the same thing but only return the values you want. Exmp: run a query that retrurns all values less than 20 and then run another query that retruns values between 20 and 40 and so on. build a...

if you have a date field enter this in the criteria >=[Start Date] and <=[End Date] when you run the query it will ask you for a parameter. you can choose any time period you want. if you want to know the day of the week use: Day:format([date],"dddd") in a new column, when you run the query it...

The easiest thing you can do is import the report to word or excel and then put in the page breaks

Hello: I am trying to run a query that needs to look at two different time periods. the query is being run using two different queries. one keeps track of salesman refusals per account and the other gives a total amount of refusals per account YTD. I need to include all fields in salesman...

Thanks David, it Worked Great

In the past (Access 97)I have used the expression Day:Left(format([date],"long date"),3) to return the day of the week next to the date. example 4/01/02 = Monday. I been trying to use this expression in Access 2002 and it doesnt work, does anyone know an easier way to get my query to tell me...