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!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Query dropping records
I have created the following in Access 2007 where I want ALL records from Hospital Addresses listed, whether or not there is a corresponding record in Hospital Contacts. All dropped records have no Hospital Contact record; but, I believe that is what my relationship type covers. Can anyone...- cc143most
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
#NUM!
I am dividing in my report and getting #NUM! results that I want to get rid of. I originally used the "Nz" statement to give me a 0% result where appropriate. Then, I found DHookum's advice to someone to use the following: =IIf([Pot]=0," ",[Obtained]/[Pot]) Now, when I have 1 potential and...- cc143most
- Thread
- Replies: 3
- Forum: Microsoft: Access Reports
-
Crosstab with Multiple Values
I have the following code that works great (thanks Duane). I get columns such as "Declined Jan", "Obtained Jan", etc. However, my Link_Total doesn't have the month, which I need. Any ideas? TRANSFORM Count([Qry_Orig].[Link]) AS [CountOfLink] SELECT [Qry_Orig].Month, [Qry_Orig].Branch...- cc143most
- Thread
- Replies: 13
- Forum: Microsoft: Access Queries and JET SQL
