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!
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!