I'm lost

[nval005]

I have a table and it has:

namefield
surnamefield
state1
state2
state3
match(Y or No)
importDate


I would like to make a query+ report so that in the report it looks like this:

<<Name>> <<Surname>>
<<state1>> <match>
<<state2>> <match>
<<state3>> <match>

in one line, at the moment I made a query and the name shows 3 times...

can anyone here give me some hints how to show the name once + the match. Thanks in advance

Cheers...

 

[The_Doc_Man]

Your data set is not normalized.

What you showed us is called a repeating group. I won't say it is illegal, because almost nothing is illegal. But it leads to abominations of problems when trying to make queries - like yours - work correctly.

Google-search keyword "Database Normalization" and limit your reading to the hits from colleges and universities you know - usually .EDU sites. If you normalize your database to at least 3rd normal form with Access, you are in good shape to make complex queries work reasonably with simple syntax.

What you've got right now is neither normalized nor easy to control. (But then you've already noticed that...)

 

[nval005]

hi Doc,

thanks for the reply, I knew something is wrong with that table that ASP programmer did for me, the data on that table was from XML from another system, I'll probably make a VBA to import the results from that table back to the main table and create the fields... thanks for the tip!!! Thanks...