Multiple fields in one table need to join

[Kathleen Badeau]

I have a grant funding database. In the database, from a single funding source, I can have up to 20 Grantees (all different) funded. I've named the 20 fields, Grantee 1, Grantee 2, etc up to 20. I now want to combine these grants into one field so that I can do a reports as to which Grantee has gotten funding and from where.

The only thing I can think of is a union query but it will "seem" to take forever doing it that way. Is there not a better and more efficient way of doing the combining?

As for the why I did it this way...it was the only way I could think of at that time.

 

[Kathleen Badeau]

Thanks Pat. This is what I plan on doing (separating the regional payment information from the rest of the table).