try this
select * from tableName
where columnName like '%.mcxl'
and columnName not like'%0%'
and columnName not like'%1%'
and columnName not like'%2%'
and columnName not like'%3%'
and...

so a staff person resides in more than one room?

also, if you can give me some specifics about how your database, I might be able to help you figure something out

well, it doesn't really make any sense to. let's say you add a new part that is going to be used on half of your cars. How is access suppose to know which ones to link to? All of them? the most...

i'm confused. what do you want it to populate with?
are you trying to have it do something like
you add
partid = 567, name = carburetor
and
carid = 256, name = chevy
at the same time and...

ok, so you put entries in the cars table and entries in the parts table and then entries in the CarParts table to link them. Which table is having the problem?

cyclic reference means you have fields that try to compute off of each other that form a loop.

Something like
Field a = b+1
Field b = c+1
Field c = a+1

you need to figure out where this...

sorry, but you are going to have to give me some details about how your tables are setup. does it look something like this?

table cars
CarID number
CarName vtext

table parts
PartID number...

do you mean a composite key or a computed field?

did you try googling "calculate body fat percentage formula"

this may sound silly, but have you made sure it isn't read only?