Showing multiple formats for a single field on a report/query

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

Guest

My table contains 2 fields:
1. Item
2. 2005YE

"Item" are the line items on a P&L (i.e. sales, COS, OM, etc). "2005YE" has
multiple formats ($, %, etc.). How can I get the query and reports to
reflect the respective format for each item?
 
The field is not formatted in "text", but you are correct in saying that
there are 2 types of numbers in the field ... $ and %. I'm beginning to
believe that the only solution is to "transpose" (year = row and items =
columns) the tables so that the fields contain either $ or %. Is that the
solution?
 
Are you using Access? Your last post said --
An Access table would not have a field with $ and %. If you are using
Access then post a few records of data.
 
Yes ... I started the "table" in Excel and imported to Access. That was my
reference to "transpose".
 
Post a few records of your data so that folks will know what you are talking
about.

And show examples of what you would like it to do.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need to create a report using a crosstab query 2
Using a query as base for report 1
Data Changing on Report 3
Using select and crosstab queries on one report 1
Single Report from teveral tables with a single to many relationsh 1
Show one report per customer if multiple sales 0
Question about summing in a report 2
totals in report 5

Back
Top