how do i use parameters & alias column names together in ms query

  • Thread starter Juliet Muir Devon
  • Start date
J

Juliet Muir Devon

In msquery I would like to use new column names using AS in sql select
statement and run parameter queries. is this possible
 
D

Dian D. Chapman, MVP

It works for Access, so I would assume it will...but it will depend on
what version you're using. I believe it should work in the last few
versions.

Dian D. Chapman
Technical Consultant, Microsoft MVP
MOS Certified, Editor/TechTrax

Free MS Tutorials: http://www.mousetrax.com/techtrax
Free Word eBook: http://www.mousetrax.com/books.html
Optimize your business docs: http://www.mousetrax.com/consulting
Learn VBA the easy way: http://www.mousetrax.com/techcourses.html



On Sat, 3 Dec 2005 05:01:01 -0800, "Juliet Muir Devon" <Juliet Muir
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word VBA - Want to test if Full Name is NOT Present in document 0
QBF & Query Malfunction 0
Merging from an Excel file with graphics 1
Alias question 5
I can't run the paramters I need in Microsoft Query 1
square brackets in parameter query 1
pass throught query by parameter 1
Null Parameter 2

Top