Access database table

[Guest]

I have a database of research. I need to add the researchee's initials to the
records in an existing table. I then plan to merge tables but be able to
indentify the respondent's words. I can do this in a query by inserting an
iIf expression but then I can't merge the queries - or can I?

Any help on this problem will be very greatly appreciated.

EdD student at Huddersfield Uni.
Wendy Thelwell

 

[John Vinson]

I have a database of research. I need to add the researchee's initials to the
records in an existing table. I then plan to merge tables but be able to
indentify the respondent's words. I can do this in a query by inserting an
iIf expression but then I can't merge the queries - or can I?

Any help on this problem will be very greatly appreciated.

EdD student at Huddersfield Uni.
Wendy Thelwell

I have no idea how you are planning to insert the initials; what you
will use as initials for Wendy Ed Student, William Extraordinarily
Stupid, and Winny Extremely Smart (are they all WES and does it
matter?); nor what you mean by "I can't merge the queries" - what are
you trying to "merge"???

Note that data is stored in Tables, and only in Tables. A calculated
field in a query has no independent existance. You can use an Update
query to update the value of a field in a table, but as a rule you
should not store derived data, such as initials.

John W. Vinson[MVP]