Two tables

[Khallie]

I have two tables: Table 1 has a "family number" field
where all students in the same family have the same
number. I want a field in table 2 to be the letters "GP"
plus the related family number in table 1. In other
words, there is a family number in table 1 that is, say,
100. I want table 2 to have a field that says GP100 (or
GP plus the family number). How do I write that? Thanks!

 

[Anne Troy]

As an expression in a query or form. This uses concatenation:

="GP"&[OtherTableName!FamilyMemberFieldName]
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->

 

[Khallie]

Thanks Anne. How would I write that in a union query?

-----Original Message-----
As an expression in a query or form. This uses concatenation:

="GP"&[OtherTableName!FamilyMemberFieldName]
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->

I have two tables: Table 1 has a "family number" field
where all students in the same family have the same
number. I want a field in table 2 to be the letters "GP"
plus the related family number in table 1. In other
words, there is a family number in table 1 that is, say,
100. I want table 2 to have a field that says GP100 (or
GP plus the family number). How do I write that?

Thanks!


.

 

[Anne Troy]

Why are you using a union query?
Perhaps you should make a query for this, and THEN write your union query
based on this...

Thanks Anne. How would I write that in a union query?

-----Original Message-----
As an expression in a query or form. This uses concatenation:

="GP"&[OtherTableName!FamilyMemberFieldName]
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->

I have two tables: Table 1 has a "family number" field
where all students in the same family have the same
number. I want a field in table 2 to be the letters "GP"
plus the related family number in table 1. In other
words, there is a family number in table 1 that is, say,
100. I want table 2 to have a field that says GP100 (or
GP plus the family number). How do I write that?

Thanks!


.