Search results for query: *

There is only a couple queries that might not return records. The other queries will definitely return records, so on 3 of the text boxes on the report I used dsum and dcount. All this just to show a 0 on a report. :) Its all about the totals and seeing the numbers,thats all. I'll have to wait...

Perfect !!!!!!!!!! Life is Good again. Thanks guys for all your help. Dean

SORRY BOUT THE WHOLE CAPS THING. LOOKS ALOT NEATER IN THE DB. ALRIGHT HOW ABOUT THIS: DLookUp("SUM(NZ([BODIES],0))","[TRANSDATA]","[CODE] = 'A'" & "AND [DATE]>=#2/1/05#" & "And [DATE]<=#2/28/05#") BUT I STILL GET "NULL" IN THE IMMEDIATE WINDOW. IT'S BECAUSE THERE IS NO RECORD THERE. WORKS GREAT...

THIS IS ONE OF THE QUERIES THAT IS PART OF THE ABOVE POSTED QUERY: SELECT Sum(TRANSDATA.BODIES) AS SumOfBODIES, TRANSDATA.CODE, Count(TRANSDATA.ID) AS CountOfID FROM TRANSDATA WHERE (((TRANSDATA.DATE)>=[START DATE] And (TRANSDATA.DATE)<=[END DATE])) GROUP BY TRANSDATA.CODE HAVING...

WHATS YOUR IDEA JOHN?

EACH RECORD IS CODED, QUERY ON THE CODE, SUM ON THE # OF BODIES AND COUNT ON THE AUTO ID NUMBER. GIVES ME SUMOFBODIES AND COUNTOFID AND THATS ALL I NEED TO FILL IN THE BLANKS FOR THE REPORT. VERY BASIC REPORT.

NOW THATS WHAT I'M TALKING ABOUT. THATS EXACTLY WHAT KEEPS HAPPENING, AND IT MIGHT BE ANOTHER TABLE NEXT MONTH WHO KNOWS.I'M SURE THERE IS A SIMPLE THING I COULD DO, BUT I KEEP DRAWING A BLANK ON THIS. MY MIND IS FRIED. :) I'M GOING TO CHECK OUT THAT SIGHT AND I'LL GET BACK TO YA. THANKS AGAIN.

SELECT MEDICAL.*, [HALL OF JUSTICE TOTAL].*, [AIRPORT TOTAL].*, [POLICE ASSIST TOTAL].*, [MOTOR VEHICLE STOP TOTAL].*, [MILEAGE TOTAL].*, [TRANSPORTS FOR CCCF].*, [OTHER AGENCIES].*, OUTOFCOUNTY.*, [TRANSPORTS FOR MUNICIPALITIES].*, ARREST.*, * FROM MEDICAL, [HALL OF JUSTICE TOTAL], [AIRPORT...

Using multiple queries to fill in the data for a report. Queries extract data from 1 table, they are based on dates. They give me the sum of people transported and the number of trips. I put all the tables into 1 query and added (query name)* to get all the fields available. There are no links...

I have a db running access and I have corrosponding image files in seperate folders. They are unique in the id number that is issued. I have a report that I want to either link or embed the images into the report but I have 6000 different reports with different images that have to generated. How...