List field in report - Need result

[DwayneS]

I have a table with a list field. The values are--
1;Sales
2;purchases
3; etc ...

When I list it in a query, I get "Sales", "purchases", etc.. as I expect.

When I put the field on a report (using the query as the source), I get 1 2 3 etc...

How to get Sales, etc on the report?

Dwayne Streeter, CPA, CITP

http://www.cpe-interactive.com

 

[Blorf]

Hi. is the 1;sales one value in one field, or are there two fields, 1 in the first, and sales in the second?

Is there a chance that your report in only including the first field?

Or, is there a chance your table is giving relational results in a query that are not being reflected in your report?

ChaZ

 

[DwayneS]

Tks for quick comeback. The field is defined like this in the field:

Display control: List Box
Row Source Type: Value List
Row Source: 0;Sales;2;Production;3;Purch; 4;InventTransaction;5;InventLossProfit;6;InventTransfer;7;SummedUp;8;ProdLine;9;BOMLine;10;BOM;11;WMSOrder;12;Project;13;InventCounting;14;WMSTransport;15;QuarantineOrder;16;SFAQuotation;20;Asset

Dwayne Streeter, CPA, CITP

http://www.cpe-interactive.com

 

[Blorf]

Hi, what you listed looks like it comes from the data tab on the controls properties.

Select the All Tab, and look for column count, and column widths.

Make sure the column count isn't just one.

I suspect the column widths will be something like 1;0;0 blah. The Zeros are likely your problem, as they make the other values, like sales, display in zero inch widths.

Play with that. Hopefully it's the problem.

ChaZ

 

[dhookom]

I recommend not ever using lookup fields defined in tables as per

http://www.mvps.org/access/lookupfields.htm.

Lookup values should be in tables. You can use the tables as row sources for list or combo boxes. You can also include the lookup tables in the record sources of reports.

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]