Tables and Queries

[Guest]

I have a table that has information such as MMA01, MMA02, MMM14, MMM23
I am running a query to join this table with a table that has what MMA and
MMM stand for. I am having trouble getting this to pull the right
information. How do i set up the table so that MMA## = Machine and MMM## =
Man Power in the query? Thanks for the help

 

[Duane Hookom]

It looks like your table is un-normalized. What are you storing in these
fields? Have you considered normalizing?

 

[Guest]

A work around until you normalize is to create a select query and in design
view pull down the asterisk from the table. Next pull down the field that
contains your "MMM" to the field row of the grid. Type a label in front of
the field name and edit to look like this--
My M_s:Left([YourField],3)
Save.
Use the query instead of the table to join on the My M_s fields.