Combine multiple forms without duplicates

[dbowe]

I have 3 forms with the same fields that users are entering datainto and I
would like to combine them in a query without duplicates and then produce a
report. Any assistance would be greatly appreciated. I am a new access 2003
user.

 

[KARL DEWEY]

Forms do not store data, they lose everything when closed. Data is stored in
tables.
How is the data stored in your tables? Three separate or all forms using
the same table?