Hi Everyone,

I have got an Access SQL query with more than 24 columns. There are 24 columns to display the data between 2014 Jan and 2015 Dec and those columns have numbers and text. I need to filter the rows which says "Information Requested" in any of the 24 columns.

I was wondering is there any way in Access SQL to filter the data without repeating those 24 fields ?

Cheers
B.