I wish to display one record in a Report as a customer quotation, I call in two tables, one of customer details and another called quotation which contains order enquiries there maybe several records within this report that may need to be displayed, They are linked with Customer Code. But when i display the quotation report it always shows all customers at once and I just want it to display the one? anyone help?

Change the query that is used as the report's recordsource to include selection criteria. Open the QBE grid and in the criteria line for the CustomerId field put -

[Enter Customer Id]

When the report runs, it will prompt you for a CustomerId.