Two into One (Tables)

[ortizimo]

I have a DB to track my video games. I would like to display both my console and portable games into one form/datasheet. I have a query where both tables are linked in the games field but only the console games show. both fields have the same name (Games). What am I doing wrong?

[pbaldy]

Unless they have very different fields, you should have one table with a field to denote which type it is. Failing that, you need a UNION query to pull them together.

[June7]

Why do you have two tables? Are the fields really different? If not, use 1 table with another field to describe as portable or console.

You were linking these two tables to each other? You are linking on names? I assume both tables don't have all the same game names in each.

[ortizimo]

Unless they have very different fields, you should have one table with a field to denote which type it is. Failing that, you need a UNION query to pull them together.

Thnx! I figure out the UNION query and this is what I have...

SELECT [Games],[ConsoleName],[Copy],[Condition]
FROM qryConsole_Main
WHERE InCollection = True

UNION SELECT [Games],[ConsoleName],[Copy],[Condition] AS'ViewOnly'
FROM qryPortable_Main
WHERE InCollection = True
ORDER BY (ConsoleName), (Games);

It works great! The only thing I haven't figure out is how to add the already checkboxes in the table (true or false) into the SQL.

[ortizimo]

Why do you have two tables? Are the fields really different? If not, use 1 table with another field to describe as portable or console.

You were linking these two tables to each other? You are linking on names? I assume both tables don't have all the same game names in each.

they are basically the same thing...the only reason is that I need everything to be separated to get clear results and datasheets that have no other data in them...

[pbaldy]

They should be in one table. Using query criteria you can easily get one, the other or both.

[ortizimo]

They should be in one table. Using query criteria you can easily get one, the other or both.

I have tried but when I make a separate query just for the hardware it counts all the records of my games in that same table and displays them as blank. This is why Im trying this.

[pbaldy]

Personally I would correct that problem rather than design around it, but it's your baby.