Access 2013 Query Help

Mac1206

Board Regular
Joined
Jun 3, 2016
Messages
184
I need a query to find all records that has "does not meet the requirement:" in the Fault_Message Field...See Table below...Thanks

SITE_IDACCOUNTBill DayFAULT_MESSAGE
2147798021ICB0350:CBM3700:Service EE200 does not meet the requirement: 1B Include if all
27114246011ICB0350:CBM3700:Service ML256 does not meet the requirement: 1A Include if one
27226926021ICB0350:CBM3700:Service ML257 does not meet the requirement: 1A Include if one
27051590011ICB0350:CBM3700:Service ML267 does not meet the requirement: 1A Include if one
24668435011ICB0350:CBM3700:Service ML455 does not meet the requirement: 1A Include if one
280523031ICB0350:CBM3700:Service ML987 does not meet the requirement: 1A Include if one
2308087081ICB0350:CBM3700:Service ML987 does not meet the requirement: 1A Include if one
23479469011ICB0350:CBM3700:Service ML987 does not meet the requirement: 1A Include if one
24586780011ICB0350:CBM3700:Service ML987 does not meet the requirement: 1A Include if one
24518973021GatewayError: RC=9999, MSGNO=CBM5578, MSGTEXT=Account must be active, or must have a pending Install WO., SourceLocation=ICB0312 OrderException_1{#0,Key=null,ReturnCode=9999,MessageNumber=CBM5578,MessageText=Account must be active, or must have a pen
24636482021GatewayError: RC=9999, MSGNO=CBM5578, MSGTEXT=Account must be active, or must have a pending Install WO., SourceLocation=ICB0312 OrderException_1{#0,Key=null,ReturnCode=9999,MessageNumber=CBM5578,MessageText=Account must be active, or must have a pen
27317855011GatewayError: RC=9999, MSGNO=CBM5578, MSGTEXT=Account must be active, or must have a pending Install WO., SourceLocation=ICB0312 OrderException_1{#0,Key=null,ReturnCode=9999,MessageNumber=CBM5578,MessageText=Account must be active, or must have a pen

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
Add this criteria to the "FAULT_MESSAGE" field:
Code:
[COLOR=#333333]Like "*does not meet the requirement:*"[/COLOR]
 
Upvote 0

Forum statistics

Threads
1,214,636
Messages
6,120,666
Members
448,977
Latest member
moonlight6

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top