Help with MS Access

[chetan.bhalla]

Hi Everyone,

I need help with MS Access :

I do have a table and a query with me. There are certain entries in the Table named LOVs-IVORY.The 2 fields are :
LOVs-IvoryRORReasonCHr0682310iIvoryHKr2933710iIvoryJPr5191810iIvorySGr0432001iIvorySGr0432101iIvoryUKr4599710iIvoryUKr4599711iIvoryQAc3507701iAIvory
I need to ensure these values are not included in the final result of the Query.I would just give you the outlook for the final derived data from which these values need to be excluded :
Order ReferenceCountryRegionCityADc0627261iAANDORRAEMEAANDORRA LA VELLAADc0627277iAANDORRAEMEAESCALDESADc0628001iAANDORRAEMEALES ESCALDESADc0631063iAANDORRAEMEAANDORRA LA VELLAADc0631491aAANDORRAEMEAESCALDESADc0631491bAANDORRAEMEAESCALDESADc0633371iAANDORRAEMEAANDORRA LA VELLAADc0634456aAANDORRAEMEALES ESCALDESADc0634456bAANDORRAEMEALES ESCALDESADc0636717aAANDORRAEMEALES ESCALDESADc0636726iBANDORRAEMEAESCALDES

Can anyone help me with this.Any help would be appreciated.

Regards,
Chetan Bhalla
MS Access Beginner.

 

[amaztheking1]

you just posted another thread above u...