Same Field Names - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Same Field Names

Thomas Corbett

6 years ago

I have a form built with four fields, Feild1, Field2, Field3, Field4 and Field5. I want to see this data in a single form separated into the 12 months. I have created 12 queries to separate the data into the months. I have totaled the fields in each query and would like to show the totals for each field in their respective months but am have trouble. I can get the first month of data in but I am have trouble with any remaining data. I believe it might have something to do with using the same field name. Any help?

Richard Rost @Reply

6 years ago

Is it four fields or five? :)

I don't understand what you mean by "separated into the 12 months." Can you give me more of an idea of exactly what this data is?

You shouldn't need 12 separate queries. I'm guessing one query with the right criteria will work. Yes, can't have the same field name.

I need to know a LOT more about this in order to help you. This might be something to send to me via my Consulting page because I might need to see your database, or at least some screen shots of what you're trying to do.

	Thomas Corbett OP @Reply 6 years ago
Hi Richard, it is 5 fields that take its data from 12 queries one for each month

	Richard Rost @Reply 6 years ago
You're probably going to have to UNION them together and then you can perform calculations on the whole set.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View