Morning All
First, apologies if this is already answered in the Forum, but i could not find anything similar
I have a very large data set in excel with 1000's of rows and i cannot uses simple filters as this is not appropriate to generate subsequent reports from the data, therefore i have to use MS query to initially exclude various data, this has always served me well up to now, however I am now stuck!
Example below is nothing like the real data i am working with but to simplify my question: assume for easy to understand data that I would like to create a query based upon used cars, that shows all cars that are:
Colour: LIKE Black, or Yellow or silver, but NOT LIKE Green or blue or Red or graphite
I cannot simply state LIKE Black, or Yellow or silver, and leave it at that, i have to further specify the NOT LIKES too because of the real complex dataset I am working with (unfortunately because the data is sensitive to my company i cannot use real examples of the data or naming types of the fields)
Criteria Field: Colour
Value: Like 'Black' or 'Yellow' or 'Silver'
or: Not like 'Green' or 'Blue' or 'Red' or 'Graphite'
This doesn't work, i suspect i need to state all syntax in the first row but because of my real dataset value names which are each quite long i run out of character space to fit all into the first Value row
I assume that this (below) should work, but as said i run out of characters space for this row with my real data
Value: LIKE 'Black' or 'Yellow' or 'Silver' & NOT LIKE 'Green' or 'Blue' or 'Red' or 'Graphite'
Has anybody had experience of this, any help really appreciated
Many thanks to all
Regards
V6chevy68
First, apologies if this is already answered in the Forum, but i could not find anything similar
I have a very large data set in excel with 1000's of rows and i cannot uses simple filters as this is not appropriate to generate subsequent reports from the data, therefore i have to use MS query to initially exclude various data, this has always served me well up to now, however I am now stuck!
Example below is nothing like the real data i am working with but to simplify my question: assume for easy to understand data that I would like to create a query based upon used cars, that shows all cars that are:
Colour: LIKE Black, or Yellow or silver, but NOT LIKE Green or blue or Red or graphite
I cannot simply state LIKE Black, or Yellow or silver, and leave it at that, i have to further specify the NOT LIKES too because of the real complex dataset I am working with (unfortunately because the data is sensitive to my company i cannot use real examples of the data or naming types of the fields)
Criteria Field: Colour
Value: Like 'Black' or 'Yellow' or 'Silver'
or: Not like 'Green' or 'Blue' or 'Red' or 'Graphite'
This doesn't work, i suspect i need to state all syntax in the first row but because of my real dataset value names which are each quite long i run out of character space to fit all into the first Value row
I assume that this (below) should work, but as said i run out of characters space for this row with my real data
Value: LIKE 'Black' or 'Yellow' or 'Silver' & NOT LIKE 'Green' or 'Blue' or 'Red' or 'Graphite'
Has anybody had experience of this, any help really appreciated
Many thanks to all
Regards
V6chevy68