You an Access 2010 Guru? Help please.

No problem. Try the query in post 38. It's slightly different than the one I had listed earlier.

 

Now what I need to figure out is how to get all the other inflammation too, I need the shift, name and call type for those. I think this is a great start and I just need to do some trial and error. Adding one piece of info again and again until I find one that breaks it and then figure out how to get that info from a different query. You really have help me a lot, thank you.

 

That's where the join will come in. You create your larger query and then join to the smaller uniqueticketnumber recordset based on pkey. It will only return records which have the same pkey as the data in your uniqueticketnumber query.

 

OK, I feel stupid! I have had no issues with this sort of join in the past. But instead of beating my head against the keyboard, I figured I would reach out to you once more.

Now I need to pull the other information from that table, I am able to grab ever field, except one field without issue. All the other fields are the same for every record, but the field "TTA" is a time field that is different for every record entry.

The joins with the pKey just isn't doing it to pull only the records with matching pKey. I have tried the different join properties.

 

Have you tried removing the group by statements. Maybe something weird is going on with them. I would try eliminating the group by unless you need it. It is typically used with aggregate queries (e.g. a sum function that calculates an order total).
http://beginner-sql-tutorial.com/sql-group-by-clause.htm

 

I decided to use the same method for getting a unique Ticket number to get a unique TTA. Then rejoining them via the pkey.

Everything is working now.

Just cleaning up the hierarchy of queries to get me the final report.

Looks like I am finally getting a new computer and maybe get my Access training class approved.

Thanks for all your help.

 

Glad I could help.