ms access

[samson]

Hello All,

I have this peculiar challenge in my access application. Below is the scenario:

I have a field named DESTINATION and i want to retrieve only those records that meet four(4) criteria. Below are the criteria: - LOS-QOW, LOS-ABV, LOS-QCB & LOS-ENU.

My approach:

I used all of these criteria in the query but it wouldnt work. I dont know what im doing wrong.

Please, is anyone out there that can assist.

Thank you in advance.

Samson Ojo

[RonR]

I can help you with this if you are using VB 6, but I do not use SQL commands.



let me know if you are interested.

[samson]

Hi RonR,

Thank you for your response.

I dont mind at all. Please let me have it.

Note: Im using MS Access but anything you bring could be adapted in Visual Basic for application (VBA).

Thank you very much.

Samson.

[Allan Murphy]

Samson

Try this coding

SELECT Departure.*

FROM Departure

WHERE (((Departure.Flight_Destination)="LOS-ABV" Or (Departure.Flight_Destination)="LOS-QOW" Or (Departure.Flight_Destination)="LOS-QCB" Or (Departure.Flight_Destination)="LOS-ENU"))

ORDER BY Departure.Flight_Destination;

The above query will display ALL fields for the selected destinations. I created a query using your Departure table and put the following

"LOS-ABV" Or "LOS-QOW" Or "LOS-QCB" Or "LOS-ENU" in the first criteria line of the Destination column

You may need to change the code to suit your requirements for the fields etc.

[RonR]

do you want to find the records that meet only ONE of the 4
criteria?

once I know for sure, I will send you some code.