after running query table shows id number not name how to fix

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

Guest

I have a table that is in the correct format. When I run a append query
against this table the format is off, there is a number where there should be
text. How do I fix this.
 
If both fields exist, the ID and the 'formatted name', and you see the id
while you expected to see the formatted name, you may have lost the
'auto-lookup' feature, in the TOOL you are using. Check ELSEWHERE to see if
the auto-lookup still works there. If so, well, use the 'view' showing the
translated id by its formatted name, or use a query that does the lookup
(with a JOIN, or something similar).


Vanderghast, Access MVP
 
Back
Top