471,108 Members | 1,298 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,108 software developers and data experts.

MSQuery Question

I have a worksheet written by another programmer that I have to modify.
He uses MSquery to extract from a SQl 2003 DB. That part I understand
and I can duplicate. The hard part, is that for each row that is
displayed three additional columns show up (in all seven queries) and
in one case he changes the sorting of the query as well. These
functions use the columns output by MSquery. There very simple
functions and tests. In the SQL I can not find them or any reference to
them. There is no module in VBA. No add-in, just the MSQuery. How can
he do this. What should I be searching in Google to understand this
feature?

Jul 23 '05 #1
1 1345
On 23 Jun 2005 08:28:04 -0700, catsinheat wrote:
I have a worksheet written by another programmer that I have to modify.
He uses MSquery to extract from a SQl 2003 DB. That part I understand
and I can duplicate. The hard part, is that for each row that is
displayed three additional columns show up (in all seven queries) and
in one case he changes the sorting of the query as well. These
functions use the columns output by MSquery. There very simple
functions and tests. In the SQL I can not find them or any reference to
them. There is no module in VBA. No add-in, just the MSQuery. How can
he do this. What should I be searching in Google to understand this
feature?


What is sql 2003?

It helps if you post some SQL and examples.

Tony
--
http://www.dotnet-hosting.com
Free web hosting with ASP.NET & SQL Server
No ads - No trials - Innovative features
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Stevey | last post: by
3 posts views Thread by BerkshireGuy | last post: by
reply views Thread by catsinheat | last post: by
10 posts views Thread by glenn | last post: by
53 posts views Thread by Jeff | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.