Adding conditiona criteria to select data i.e. greater than relevant value

[Dhiresh]

HI VBA Gurus….

I have an Access Query that makes another table (for selected columns) and 3 of these have ‘Ascending’ sorts. This is working great.

However, I want to add conditions to this requirement

1. if in column “OTHER1” = X then get a relevant code number from “Levels” and if the level value is 1 then select all data for values greater than 0 (i.e. 1 and above); if the level value is 2 then select all values greater than 1 (i.e. 2 and above); if the level value is 3 then select all values greater than 2 (i.e. 3 and above) and so on – limit is 5.
2. Exclude all data where the word “Blanks” appears in Column “Level”
3. Retain ‘Ascending’ sorts for the 3 colums

I guess this can be done using VBA and I have very little knowledge of this.

Please can someone help.

Thanking you in advance.
Dhiresh

[June7]

Why do you need to make table?

Don't understand item 1. If 5 records have X and 1 of them has Level 1 and 2 have Level 3 and 2 have Level 5, which criteria should be applied as filter?

2. criteria: <> "Blanks"

3. apply sort order in query or in report