Concatenate Like Fields

[Dean0_53]

Hello,

I have two tables I would like to combine into one table in an Access report. The problem is there isn't a like join between the two. The only difference between the two tables is one table grad students and the other is undergrad students for a specific term, but they are very limited by major or program within each table. I have created two make-tables for each, but how can I combine them both into one large report or table?



Thanks
Deano

[June7]

So you don't want to JOIN because they are not related. Sounds like you need UNION query.

Why weren't they one table to begin with? Could have another field to indicate "Grad" or "UnderGrad".

[Dean0_53]

June7,

I'm not very familiar with Union Queries. I have attached a sample database. There were not in one table to begin with because the students are two different levels. UG and GR. Also their major are different so I can't use that data to make a like join.

Thanks,

[orange]

The zip file is empty???

[June7]

No file in the Zip folder.

If the tables have the same fields, then a single table can certainly be constructed. Just have another field that identifies as 'GR' or 'UG'.

Again, you don't want to JOIN these datasets, that would make no sense. You want to merge - that is a UNION query. UNION query essentially builds the dataset that should be a table to begin with.

Different majors has no bearing on the issue.

[Dean0_53]

No file in the Zip folder.

If the tables have the same fields, then a single table can certainly be constructed. Just have another field that identifies as 'GR' or 'UG'.

Again, you don't want to JOIN these datasets, that would make no sense. You want to merge - that is a UNION query. UNION query essentially builds the dataset that should be a table to begin with.

Different majors has no bearing on the issue.

I was able to get this to work with a Union. Completely forgot about trying that.

Thanks!