I use following query in the Access Report.
but is not working, it not display the record where airline='BA' etc.
there is problem in where cluase airline.
when query run it ask the start date and end date and airline,
I have to give airline ie BA, it should display record
which airline is BA, but is display all records.

Please check the syntax of where clause to use following query in Access Report ?

SELECT [customer].[salesdate], [customer].[pname], [customer].[refco], [customer].[airline], [customer].[travfr], [customer].[travto], [customer].[outamt], [customer].[tcollect], [tcollect]-[outamt] AS Expr1
FROM customer
WHERE [customer].[salesdate] Between [ Start Date (m/d/y) ] And [End Date (m/d/y) ] And customer.airline='#customer.airline#';

regards.

Mateen

try this

SELECT [customer].[salesdate], [customer].[pname], [customer].[refco], [customer].[airline], [customer].[travfr], [customer].[travto], [customer].[outamt], [customer].[tcollect], [tcollect]-[outamt] AS Expr1
FROM customer
WHERE [customer].[salesdate] Between [ Start Date (m/d/y) ] And [End Date (m/d/y) ] And customer.airline=[input_airline];

I think the #'s were throwing it off possibly, as well as setting the variable to the same name as the field, customer.airline=customer.airline will always evaluate as true.

Thanks a lot.