[AccessD] Set value in a report textbox

Rocky Smolin rockysmolin at bchacc.com
Tue Oct 30 16:15:23 CDT 2018


Enter criterion for field PE_Fam-spot of "A"? You'd get all the Households and only one name per.  Unless more than one person has "A" rank.

HTH

R


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tina N Fields
Sent: Tuesday, October 30, 2018 2:04 PM
To: ACCESSD
Subject: [AccessD] Set value in a report textbox

Hii,

I have a report for my local Salvation Army, that is to be a signature 
sheet for the family picking up the Christmas stuff.

When we developed it, they wanted only the household name and the 
assigned family number to be displayed at the top of the report. Turns 
out, though, they'd really also like the first name of the parent of the 
household.

The tblHouseholds doesn't have any  person names in it, of course. So, I 
want to put a textbox alongside the Household name box to be populated 
with the first name of person A in the household. The tblPeople has the 
foreign key matching the household ID. (Using John Colby's naming 
convention, HH_ID from tblHouseholds is foreign key PE_IDHH.)

How do I do this? I have the PE_Fname in the query, and I have the 
person's rank in the family (they insisted on this), so each 
individual's record has a PE_Fam-spot field.  How do I display the 
PE_Fname of the person with the PE_Fam-spot of "A" where PE_IDHH equals 
HH_ID?

It feels as though this should be simple, but I'm just not getting it.

Thanks for any help you can give me.

T

-- 
Tina Norris Fields
231-322-2787
tinanfields-at-torchlake-dot-com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list