MSQuery

Jul 8, 1998

HI all,
I`ve a problem to access SQL7 B3 from MSQuery......(simply crash)
(I`ve create DSN from Control Panel and ODBC TEST it`s OK)
Any suggestion?
Thanks

View 2 Replies

MSQuery Quandary

Mar 3, 2006

Ok,

I need to pull out of the database the oldest invoice for each of my clients. Yet i think either or both of myself and MSQuery criteria are limited in this capacity.

please help.

Effectively

ClientA inv00001
ClientA inv00004
ClientA inv00007
ClientA inv00008
ClientB inv00002
ClientB inv00003
ClientB inv00006
ClientC inv00005
ETC...

Where i need to pull out just the bold records... sql script syntax or MSQuery criteria advice is appreciated.

cheers,
Oosters

View 5 Replies View Related

MSQuery Question

Jul 23, 2005

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 understandand I can duplicate. The hard part, is that for each row that isdisplayed three additional columns show up (in all seven queries) andin one case he changes the sorting of the query as well. Thesefunctions use the columns output by MSquery. There very simplefunctions and tests. In the SQL I can not find them or any reference tothem. There is no module in VBA. No add-in, just the MSQuery. How canhe do this. What should I be searching in Google to understand thisfeature?

View 1 Replies View Related