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!
-
Union Query vs Join Types
Hi All: I have three queries that independently return the values I want. Please see below. However, when I try to query all the fields at once, I get undesirable results(Of course I'm using Access's built in QBE interface). Query one sums on values between criteria from my TOTAL table (not...- EXlhell
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
-
#Name? Error, How to query data and run report
Dhookom/Lameid, Thank you both for your help. Both methods work great. I went with Lameid's suggestion because my select statement is more complex than select all from one table. I'm going to start a new thread about join types and unions because I'm getting lost in the syntax. Below are...- EXlhell
- Post #6
- Forum: Microsoft: Access Modules (VBA Coding)
-
#Name? Error, How to query data and run report
Duane, Thanks for the quick response. I really appreciate you helping me out. For some reason I get a data type mismatch error on the below line of code. The record source of the report has been set to SELECT * From dbo_TOTAL_RS, I see the report's filter property loading correctly, and...- EXlhell
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
#Name? Error, How to query data and run report
Hi All, I'm tired of Excel and constantly updating links in workbooks, so I'm linking tables to our SQL server in hopes of querying data to generate reports. After failed attempts trying to recreate examples from the FAQ section, I'm reaching out for help. Ultimately, I want to query a...- EXlhell
- Thread
- Replies: 5
- Forum: Microsoft: Access Modules (VBA Coding)
