Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: sgab
  • Order by date
  1. sgab

    suvivor

    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 )
  2. sgab

    suvivor

    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)...
  3. sgab

    suvivor

    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
  4. sgab

    Help

    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.
  5. sgab

    3 quries in 1 table

    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...
  6. sgab

    3 quries in 1 table

    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
  7. sgab

    3 quries in 1 table

    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?
  8. sgab

    Help

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

    Help

    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...
  10. sgab

    Help

    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?
  11. sgab

    Help

    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...

Part and Inventory Search

Back
Top