Query Recordset sent to Excel

  • Thread starter Thread starter gr
  • Start date Start date
G

gr

Hi all,

I am sending a recordset to Excel. The recordset is from a
query output.
It works fine except that I have some fiels which are
items
choosen from comboboxes. So when the recordset is sent to
Excel, instead of displaying the values from the query, it
is displaying numbers. I think this has to do with the
Bound Columns or something of the combo box properties..

how to make excel display the "real" values?

Ex.
My query in access
Smith Sales Doc1 Finished GMD
Ravanni PIBDE Doc2 In progress SER
Ramon Sales Doc3 Finished SER

The same data in Excel
1 1 Doc1 1 1
2 2 Doc2 2 2
3 1 Doc3 1 2

Thx,
gr
 
Thank you, I read the article... but then what is a good
practice design instead of using lookup fields?? other
alternative offering the same result without all these
disadvantages?
 
gr said:
Thank you, I read the article... but then what is a good
practice design instead of using lookup fields?? other
alternative offering the same result without all these
disadvantages?
Click to expand...

Create a query. Base your recordset on the query:

Select * From qryWhatever

With a query, you can add as many tables as necessary to get the values you
want.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top