Report seperates single person data into multiple lines

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

Guest

I have a table that assigns a number to different phone types, i.e. cell,
e-mail, etc. I wrote an expression to place each into its own column
(=IIf([phonetype]="5",[phone]). I changed the number for each field to
corespond to the column that it needed to be in. But when I run the report
it gives me one line for each phone type. Since it duplicates the persons
other information in each line, such as birthdate, anniversay date, etc, I'm
stumped as to what is causing this. Please help.
 
Try this --
Build a reference table with the type numbers and word descriptions.
Build a crosstab query for the phone information.
Open the crosstab query in design view.
Add the reference table and join on the type number.
Change the column heading from the type number to the word description field
of the reference table.
 
I neglected to say that the expression I wrote was in my report, not in the
table. Do these instructions still apply? Thx.


KARL DEWEY said:
Try this --
Build a reference table with the type numbers and word descriptions.
Build a crosstab query for the phone information.
Open the crosstab query in design view.
Add the reference table and join on the type number.
Change the column heading from the type number to the word description field
of the reference table.

Michele O said:
I have a table that assigns a number to different phone types, i.e. cell,
e-mail, etc. I wrote an expression to place each into its own column
(=IIf([phonetype]="5",[phone]). I changed the number for each field to
corespond to the column that it needed to be in. But when I run the report
it gives me one line for each phone type. Since it duplicates the persons
other information in each line, such as birthdate, anniversay date, etc, I'm
stumped as to what is causing this. Please help.
Click to expand...
Click to expand...
 
Yes. Use each type (word that is) for source of text field in the report.

You may need a set of phony records with all types.

Michele O said:
I neglected to say that the expression I wrote was in my report, not in the
table. Do these instructions still apply? Thx.


KARL DEWEY said:
Try this --
Build a reference table with the type numbers and word descriptions.
Build a crosstab query for the phone information.
Open the crosstab query in design view.
Add the reference table and join on the type number.
Change the column heading from the type number to the word description field
of the reference table.

Michele O said:
I have a table that assigns a number to different phone types, i.e. cell,
e-mail, etc. I wrote an expression to place each into its own column
(=IIf([phonetype]="5",[phone]). I changed the number for each field to
corespond to the column that it needed to be in. But when I run the report
it gives me one line for each phone type. Since it duplicates the persons
other information in each line, such as birthdate, anniversay date, etc, I'm
stumped as to what is causing this. Please help.
Click to expand...
Click to expand...
Click to expand...
 
OK, I have figured out why it puts each on a new line. Now the question is,
can it be avoided.

It's my make-table query that is doing it. I am combining three table into
one and running the report off of that. However, when the table is created
it gives each type of phone number a separate line in the new table, hence
the separate line in the report.

Thx so much.
 
OK, I have figured out why it puts each on a new line. Now the question is,
can it be avoided.

It's my make-table query that is doing it. I am combining three table into
one and running the report off of that. However, when the table is created
it gives each type of phone number a separate line in the new table, hence
the separate line in the report.


KARL DEWEY said:
Yes. Use each type (word that is) for source of text field in the report.

You may need a set of phony records with all types.

Michele O said:
I neglected to say that the expression I wrote was in my report, not in the
table. Do these instructions still apply? Thx.


KARL DEWEY said:
Try this --
Build a reference table with the type numbers and word descriptions.
Build a crosstab query for the phone information.
Open the crosstab query in design view.
Add the reference table and join on the type number.
Change the column heading from the type number to the word description field
of the reference table.

:

I have a table that assigns a number to different phone types, i.e. cell,
e-mail, etc. I wrote an expression to place each into its own column
(=IIf([phonetype]="5",[phone]). I changed the number for each field to
corespond to the column that it needed to be in. But when I run the report
it gives me one line for each phone type. Since it duplicates the persons
other information in each line, such as birthdate, anniversay date, etc, I'm
stumped as to what is causing this. Please help.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top