Query ?

N

Nancy

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.
 
K

KARL DEWEY

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
 
N

Nancy

Perfect! Thank yo so much!

KARL DEWEY said:
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
Click to expand...
 
Top