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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Adding total fields from subreports - empty fields cause error
Perfect! Thanks a ton man, I appreciate it!- jimjawn
- Post #9
- Forum: Microsoft: Access Reports
-
Adding total fields from subreports - empty fields cause error
Sashanan: I'm trying to do EXACTLY what you're doing, but I'm having mad difficult problems. I have a report that has 2 subqueries that will return different subtotals, I need to add those subtotals together into the main form into a 'totals' field. I cannot for the life of me, figure out how...- jimjawn
- Post #6
- Forum: Microsoft: Access Reports
-
Complex Access Join (For Me Anyway)
Sweet! Thank you. I realized after I posted the message that there really wasn't a many to many relationship in the example I gave, although I do have a number of them in the query. You helped me solve the problem though, and the sytax you used for you queries definitley helped me. The...- jimjawn
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Complex Access Join (For Me Anyway)
Okay. I've run aground and don't know how create this query. If anyone could help me, i'd be much obliged. I guess the real problem that I'm having in my inability to decipher how Access defines its JOIN statements. I can't seem to figure it out. Anyways, any help would be appreciated. I...- jimjawn
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
