Search results

I already have them entering the beginning and ending years on the form. Say they want to run the query for the month of May, they would input 5/1/2003 and 5/31/2002, So the month totals are calculated, but I also need the YTD totals also. So I dont know how to pull the year from what they are...

Im running a query that sums the costs occuring from 1/1/2003 to a year entered by the user in a form. So right now the critieria in my query looks like this: between #1/1/2003# and [forms][myForm][date2] Which works fine. But i want the query to work for any year, right now it will work for...

The queries I am using count the number of permits in a particular instance and sum the permit fees. I have 3 queries for each instance. The month, the YTD and the previous YTD. If there is no instances for that particular month, etc. No rows are returned. When that happens I want it to...

I want my report to show zero values for all values there is no data for. Problem is that when my queries return no value there is no row at all, so i have no null values to work with. (this problem is in the summary fields, where there is no data for the month the report is generated for)

I have a report with many (about 8) subreports. Each subreport is a total field so it only displays one value. When I preview the report all the values show up on the print preview but when I print the report, all the values in the subreports are blank. But... If i have a label in the...