G
Galen
I am trying to create a database for our church's cemetery usage and part of
that process was to track those plots and who reserved them. I created
fields for the person's First Name, MI, Last Name and telephone and then
differeniated between differnt people as to whether they were the Primary
Point of Contact or the Alternate Point of Contact with a simple yes /no box
on the same line. Now I want to add that info separated as to whether they
are an alternate or primary contact with all the other data, but don't know
how to create a query to make it tell me that in the report form I have made.
It would be set up as follows:
Primary y/n First Name MI Last Name Tele
Alternate y/n First Name MI Last Name Tele
Any help would be appreciated.
that process was to track those plots and who reserved them. I created
fields for the person's First Name, MI, Last Name and telephone and then
differeniated between differnt people as to whether they were the Primary
Point of Contact or the Alternate Point of Contact with a simple yes /no box
on the same line. Now I want to add that info separated as to whether they
are an alternate or primary contact with all the other data, but don't know
how to create a query to make it tell me that in the report form I have made.
It would be set up as follows:
Primary y/n First Name MI Last Name Tele
Alternate y/n First Name MI Last Name Tele
Any help would be appreciated.