Recent content by OpethPHX

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

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

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...

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...

Thanks for the replies and CStr did exactly what you said. A follow-up question would be can you do that operation in the table itself? The reason I want to is that would then be the link to join it with another table. If not, I am sure I can find a work around, but that seemed most logical.

First off a big thank you to this forum... have solved a lot of questions I have had and some I never knew I had. Keep in mind this is all from a non-programmer so my question(s) might not be technically sound. The issue I have is I have built a database to track documents that we process. It...