STATE EMPLOYEE REQUESTS HELP WITH REPORT!!!

[Guest]

I need a query that will give me a value of 1 for each record that is not
null in any one of twenty fields (text datatype).

In other words, I need to search twenty specific fields and if any of them
has anything in it then I need to count that record in my report.

THIS CAN'T BE THAT HARD...PLEASE TELL ME HOW TO DO THIS!!!

 

[Jeff Boyce]

If you have a table that includes twenty fields, any one of which might hold
the value you seek, you have... a spreadsheet! A relational database would
use one field for the value, and a second field for the "qualifier" (what
your table's doing with "twenty fields").

While it is physically possible to do, you will only make more work for
yourself and for Access if you don't get the data structure right to start
with.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/