Parameter Queries & inputting data

[vanilladan]

Hi guys,
This is a simple question - something I've done before and now forgotten!

Basically, I have a SELECT query which displays details of a particular Customer's Discounts, based on an underlying table. However, the table does not contain the ACCOUNT no (and I don't want it to).

I want the Account number to exist only within the query.
And I want the Query to prompt for this info every time its run.

I was sure I achieved this with a Parameter query last time (something to do with an additional field containing the same info as the paramater query itself).

Any help out there?
cheers,

Vanilladan

 

[vanilladan]

Got it!

Sorry guys - incredibly easy.

(For those who might not know: simply enter the "parameters" in the query 'Field', e.g.)

Account No: [Enter Account No] )

cheers anyway,

Vanilladan
(I need more coffee!)