Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
 
 
Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
Old 07-28-2015, 12:40 AM   #1
dougiej
Newly Registered User
 
Join Date: Jul 2015
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
dougiej is on a distinguished road
ODBC puzzle

I have a query which looks at a linked table (ODBC to SQL Server) in order to return a list of sub-accounts associated with an account. If I run it as a pass-through query it executes correctly, returning a list of the sub-accounts. If I run it as a query in Access it return the correct number of records but each sub account has the same name as the main account, as follows.

Result of pass through:
Main Sub
A X
A Y
A Z

Same SQL in Access:
Main Sub
A A
A A
A A

dougiej is offline   Reply With Quote
 

Tags
odbc , sql server

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to make a puzzle HRakibul Forms 6 09-29-2014 03:58 AM
Another Security Puzzle! PearlGI General 13 05-22-2008 07:39 PM
A coding puzzle Uvuriel03 Reports 5 05-07-2008 11:26 AM
A little puzzle? Simon_MT General 2 11-30-2007 10:29 AM
puzzle... ariel81 General 9 03-01-2007 12:13 PM




All times are GMT -8. The time now is 04:51 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World