Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Andrzejek on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

3 different fields to same row

Common Formulas

3 different fields to same row

by  CarolS  Posted    (Edited  )
When creating a report with multiple columns/rows from the same table you have to create an alias for each different set of data.

As you indicated, when requesting 3 variables in the same field of your table you will receive data from only one variable and zeros for the remaining 2. I found that if you add the table to the report again, CR will inform you that the table is already added and will create an alias for you. You then link that table to the others and create a formula linking that field to the alias table.
Register to add this FAQ to your archive
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top