Recent content by amunafc

Let me go back and see how I can handle these tables them I will upload it again.. I just want a query that can put the data from both tables together,

Beloved Gurus Attached is an MS Access database zipped one. This db has two table with few common fields and few uncommon ones. Please help me to come up with a Union Query for these tables, am desperate. Regards Amuna

Thank again, I managed to fix all the problems. I am now a hero because of your assistance

boblarson Hey! that was wonderful, thank you a million times. I have four more tables to be added and I will follow the rules.

Dear Gurus Can someone help me fix the error I am getting when running my query I have attached? Please download it and run the 'Union Query'Query1 Regards Amuna

hi the tables here are getting the infor from a table called 'All Data' and I have a make table queries that comes up with those four tables so here there is no any relationship

Dear Guruz I have attache my simple database. What I want is to create one query i.e. a union or anything that can put all the information from the five tables together. After that I want to design a simple report containing all the information from those different tables. Yours Amuna

Thank you so much. I was about to drop it out. Thank once again 1000x:):):):)

I have managed the query 'Union' but it's got some bug. Please could help to remove the bug? Try to run the query and see where the bug comes from:D:D

I want a union query from the two tables and after that I want to run 'Make Table Query' so that the data from both tables should appear in one table

JoanneJames Yes I want to come up with one query when I combine the common field in both tables.

Please help me with this union query from the tables provided. Amunafc:D:D

Dear All Happy new year guys... I thank you all for the good work you did to me in 2010. Amunafc

ghudson Dazed & Confused hahahahaha my friend I am tired of writting these codes

I have attached a database and Excel sheet. Please write a code so that when I click the button it should automatically take me to where an excel sheet is. Thanks