Is there a way of pulling Table Name into a query

[accessmatt]

Hello, does anyone know if there's a way to insert Table Name into a query in order to use as an identified. The problem I'm having is that I have multiple tables with same exact field names however they refer to different "types". I want to join them but also have a way of identifying the type I'm querying.



Thanks,

[ranman256]

In the query design, make a hardcoded field to be added, and put the table name in. TBL: "myTable"

[JoeM]

Sounds like you may have a design issue. Instead of having multiple tables of similar structure for different types, you should have a single table with all your types, and a "Type" field that you use to denote which type each record is. This is a normalized design, and make many tasks much easier to perform.

[pbaldy]

Sounds like a normalization problem. I'd have a single table with an additional field for type.

[pbaldy]

Dang slow typing skills on an iPad!

[accessmatt]

ranman256, thanks what was simple and helpful. JoeM & pbaldy I agree that the design is not ideal but it's unavoidable based on reasons outside of my control. thanks!