Parameter Query Help needed

[Tad Pepperling]

I am trying to use the parameter query to return data from an access
database to my spreadsheet. I have it working but I can not get it to return
to more than one row of data.

My access database table had 4 fields. Account Num, Zone, Signal, Desc.

I want to look up a selected account and return a list of all zones and
desc. associated with that account.

this is what teh SQL in the MS Query editor looks like.

SELECT ZONE.Zone, ZONE.`Desc`
FROM ZONE ZONE
WHERE (ZONE.AccountNum=?)
ORDER BY ZONE.Zone

Please Help.