Query Export formatting issues

[jle0003]

I have a table, let's call it tblRegion. It looks like this:

RegionID (PK)
RegionName

I have another table, tblState. It looks like this:

StateID (PK)
RegionID (FK)
StateName

In the lookup properties for tblState.RegionID, I have the follwing selections:

Display control: Combo Box
Row Source Type: Table/Query
Row Source: SELECT [tblRegion].[RegionID], [tblRegion].[RegionName] FROM tblRegion;
Bound Column: 1
Column Count: 2
Column Widths: 0";1"

I have a query that returns the RegionID and StateID based on some other criteria. When I run the query in Access, the output looks like this:

EventID EventDate RegionID StateID
01 7/31/2013 Southeast AL
02 8/01/2013 Northeast MA

But, wen I export the query results in a text file (comma-delimited values) I get:

EventID,EventDate,RegionID,StateID
01,7/31/2013,3,1
02,8/01/2013,2,4

I want:

EventID,EventDate,RegionID,StateID
01,7/31/2013,Southeast,AL
02,8/01/2013,Northeast,MA


How do I get the export to display the RegionName and StateName (like it does in the Access query output)? When I select "Export data with formatting and layout" it puts several dashes and vertical bars in my text file and I only want comma-delimited values (like above).

Please help!

Thanks!

[alansidman]

You need to add the lookup table as part of your query joining it to your main table. Display the lookup values and not the values in your main table. If you are running a report and exporting that, make sure that the query is used as a record source and not your main table.

Alan