SQL Pass Thru Query & Forms

A

AccessLisa

Hi, I"ve created the following SQL Pass Thru Query and it works GREAT....
however, I want to replace the Where clause 'Las Vegas' piece with a link to
a forms Drop Down box, where if the drop down box selection is 'Ashburn', it
will auto requery the SQL below to pull data for Ashburn. Any ideas?

SELECT DISTINCT TOP 10 [MTD vs Budget], Hospital_ID_Name,[BU Roll]
FROM ALLINONE
Where [BU Roll]='Las Vegas'
order BY [MTD vs Budget]DESC

Thanks!
 

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

Top