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
 
Top