How to display a field from multiple records into a report line?

[Guest]

I am working with a weird query that has the following fields: Id, field_name, and field_value. Here are some examples of the records

001, gender, mal
001, age, 5
002, gender, femal
002, age, 2

How do I create a report that will display

001, male, 5
002, female, 2

Any helps will be highly appreciated

rayt

 

[Allen Browne]

See:
Return a concatenated list of sub-record values
at:
http://www.mvps.org/access/modules/mdl0004.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I am working with a weird query that has the following fields: Id,

field_name, and field_value. Here are some examples of the records.

 

[amishra]

try to learn normalization and create tables based on those rules.
after that go to creating reports.

You query really seems to be weird or u havent asked properly.

Cheers
Ami

 

[amishra]

try to learn normalization and create tables based on those rules.
after that go to creating reports.

You query really seems to be weird or u havent asked properly.

Cheers
Ami

 

[amishra]

try to learn normalization and create tables based on those rules.
after that go to creating reports.

You query really seems to be weird or u havent asked properly.

Cheers
Ami

 

[Guest]

Thanks for the tip Allen. Problem is solved

rayt

 

[Guest]

thanks for the "kind" words, Amit! The database is included in a "can" software package.

I will shoot myself if I created a database without proper functional-dependencies and normalization analysis and design.

rayt