Report from mulitple fields

[OpethPHX]

Now that I have my database up and running it is time to hopefully get some reports built, but I have stumped my local Access guru on this one.

Is it possible to query a total from multiple fields? I have my table and it has a primary field and then seven other fields. Normally data only appears in the primary, but can appear in the other. The field is a data field and an amount field. My hope is the report prompts the user for a value for a field and then the report looks for it by evaluating each of the eight fields. If it matches, it adds the associated data to the report.

Will this work or have I really phrased this badly?

 

[KeithG]

So you are saying that you want to add several fields from a record together?

F1 + F2 +F3

 

[OpethPHX]

What I am hoping it would do is take the user input field, which is a parcel #. The report would then compare that to field #1, if it matches it reports the data and moves to the next record. Also, field #1 will always have data, the other 7 won't. If the input doesn't equal field #1, it moves to field #2. If that field is blank it moves to the next record, if it has data, but the wrong data it goes to field #3 and if it is right it adds to the report. Hopefully that reads better.

 

[KeithG]

Can you post an example db? Or at least your current SQL?

 

[OpethPHX]

I don't have it built yet, the report that is. I guess I was just asking more hypothetically could it be done.

 

[KeithG]

Yes it can be done if I understand correctly. You want to search 7 fields in a record for a parcal number, and if found in one of the fields display the record?

 

[OpethPHX]

That is it exactly. Thanks for your patience on this.