Query filtering

[Guest]

Simple question, how do I fiilter out values that dont have a contactID but
show up in my query. Also how do I get the query to show the associated field
values rather than the number values stored in the fields in a contact table,
stored from a combo box choice on a form?

 

[Guest]

In query Design View set criteria for contactID to Is Not Null.

Join contact table, uncheck Show for contactID, and pull down the contact
field.

 

[Guest]

Many thanks Karl for your time, its us newbies that appreciate your tips and
advice.

 

[Guest]

Just a quick problem/s, Does my RepsID have relationship with my ProgID (add
a repsID field to my prog table) or do I add progID to my reps table and take
it that way. It just seems to at the moment repeat the list in my combo box
for all progID's. Bearing in mind I have tables for Reps, Sets, Tempo, Rest
all have separate IDs autonumers keys and are combos on my form that need to
go onot my report through my query and show text value not autonumber value!