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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

OpenRecordset not opening query based on many queries

Status
Not open for further replies.
JumpinJimRivers

JumpinJimRivers

MIS
Jan 14, 2002
143
US
Hello, I am trying to send a complex query to an excel spreadsheet using OpenRecordset-- and having no luck. The query is based on 5 other queries, most of them using aggregate sum functions. The big query works from the QBE so I'm wondering if OpenRecordset is not able to open a query based on other queries, or too many queries.

Appreciate any help
 
Status
Not open for further replies.

Similar threads

Kennelbloke
  • Locked
  • Solved
Split Function not working
Replies
3
Views
560
Kennelbloke
Kennelbloke
V
  • Locked
  • Helpful tip
Capture Shift Key if Pressed on A form
Replies
3
Views
657
strongm
strongm
Johnny S
  • Locked
  • Question
Create folder based on ID field MS Access
Replies
3
Views
430
MattGreer
MattGreer
ziffer68
  • Locked
  • Question
Pass Through query to create an alias for DB2 member
Replies
0
Views
2K
ziffer68
ziffer68
DarkOne72
  • Locked
  • Question
Message Box Popup on certain days help !
2
Replies
23
Views
6K
Norman Sherlock
Norman Sherlock

Part and Inventory Search

Sponsor

Back
Top