Search results for query: *

i keep getting error messageges, are the commers and things in the right places, i can see open commers in your txt but no closed )

this is how i got the number of dead SELECT aaa.Name, aaa.Priority, Count(*) AS Outcome FROM aaa WHERE (((aaa.thirtydaymortality)="Dead")) GROUP BY aaa.Name, aaa.Priority; obviously i can change the word alive for dead and get the numbers, but i want to be able to say Dr Blue (from name field)...

i have a query with the following headings Dr>Priority>count of mortality>alive/dead The query basicly shows how many people of each priority died. (by doctor) this works great i also want to be able to show how many of each procedure are alive, how do i do this? how do i count how many

i havent got a field with number of survived, the query just has the number of dead for each procedure, dont know how i would get number of survived in.

this id for p-mortaaa SELECT aaa.Name, aaa.Priority, Count(*) AS CountOfDied FROM aaa WHERE (((aaa.thirtydaymortality)="Dead")) GROUP BY aaa.Name, aaa.Priority; and p-mortamp SELECT amp.Name, amp.Priority, Count(*) AS CountOfDied FROM amp WHERE (((amp.thirtydaymortality)="Dead")) GROUP BY...

sorry i should of explained, im fairly new to access, and have never heard of Union or sub report, ? how do i do this? thanks

i have 3 quiries built for 3 audits(p-mortaaa, p-mortcea, p-mortamp). each quiry shows the same kind of data for the 3 different audits I need 1 report that shows all 3 results, but dont know how to do that. i could open a new report, but it only lets me choose 1 query. any ideas?

got that working now, thank you so much, now i need to get a % or the death rate for each procedure?

thanks, i put it word for word in SQL view, and got an error This expression is typed incorectly or is to complex to be evaluated, for example a numeric expresion may contain to many complicated eliments, try simplifyning the expresion by assigning part of the expression to variables that mean...

I may sound daft, but do i write that all on 1 line. Do I write the bits in Capitals? I use access 97, and in the query page i have the folowing lines Field Table Total Sort Show Criteria Or what info do i put where?

Im am new to Access, and am learning myself and have built a DB that i am fairly happy with, but theres 1 thing i cant get it to do. I want to build a quer. the data that goes in is via radio buttons, and text. you type in the persons name (a doctor) and then tick boxes to put data into 2...