Query ?

[Guest]

How do i make a query which has additional fields the master table does not
have?

(I query a Yes/No field from the master list, so now I have a Last Name, and
a field with a check box, but I want to add more fields to just this table,
not the master table). How can I do this?

I know it sounds confusing, please do help.

 

[Guest]

Open the query in design view and add the field name followed by a colon and
an example of the data it is to contain.
1 for integer
2.333 for number-single
"A" text

 

[Guest]

Perfect! Thank yo so much!

Open the query in design view and add the field name followed by a colon and
an example of the data it is to contain.
1 for integer
2.333 for number-single
"A" text