What works best

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a situation were I have client from three different cities, all I want
to do is keep a track of the answer they given to five question (yes or no).
My problem is I am trying to set a query for each city and question. My
problem is what I am try to solve or end result is I want to sort the city
with all the questions than in turn take that information at export to an
excel shread sheet (just the results).
On the excel spreed sheet I just want the total number that answer yes for
question one and so one.

Am I making this hard than I am thinking or to complex.

please give me show advise.
thanks
roger
 
Hi Roger,

I see something like the following tables:

*Clients*
ClientID, autonumber
Client, text

*Cities*
CityID, autonumber
City, test

*Questions*
QuestionID, autonumber
Qnum, integer --> question number, for ordering
Question, text

*Questionairres*
QairreID, autonumber
ClientID, long integer -- FK to Clients
CityID, long integer -- FK to cities

*Answers*
AnswerID, autonumber
QairreID, long integer -- FK to Questionairres
QuestionID, long integer -- FK to Questions
ynAns, yes/no

if you store the information in this manner, it will be very
easy to get the statistics you are looking for.

Once the data is in, you may wish to use a Crosstab query to
see Question numbers as columns across the top

Warm Regards,
Crystal
Microsoft Access MVP 2006

remote programming and training
strive4peace2006 at yahoo.com
*
Have an awesome day ;)
 
ok, that looks better, only thing what does the FK to Client and FK to city
stand for. This is my first time making such a complex database. So forgive
me for the wierd questions.

thanks
Roger
 
you're welcome, Roger :)

ClientID, long integer -- FK to Clients
CityID, long integer -- FK to cities

ClientID is defined in the child table as a long integer.
It is a foreign key, FK, to the ClientID field in the
Clients table.

CityID is defined in the child table as a long integer. It
is a foreign key, FK, to the CityID field in the Cities table.

Warm Regards,
Crystal
Microsoft Access MVP 2006

remote programming and training
strive4peace2006 at yahoo.com
*
Have an awesome day ;)
 
Back
Top