I'm extremely new to access and my query is perfectly fine, but when I created a report from it, one field is displaying the ID instead of the data. What am I doing wrong?
I'm extremely new to access and my query is perfectly fine, but when I created a report from it, one field is displaying the ID instead of the data. What am I doing wrong?
not sure. you did not provide the example.
just change the SOURCE of the data in the box.
Are you using table lookup for that field?, if so, don't.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Majority of the other fields are pulling from table lookups and they're fine. It's just this one field.
Sorry, I'm not sure what you mean by changing the source?
I have a table called "Store" that is pulled into another table where there is a second field for "Sold Date" that is just filled in normally. I created a query that pulls this plus other information, that automatically displays "Sold Date" as today, and that query works perfectly. I created a report off of this query, but when I open that report, the "Store" part is not showing the Store name, it is showing the table ID from the Store table, so instead of information like Wal-Mart or Target, it is only showing 1 or 2.
What RanMan means is you have the wrong field for the report?
You need to use the field that is the description for the field that is having a lookup on it.
What you really have is the ID, obfuscated by the lookup to appear be the description, but it is always the actual ID.
Not sure how your others are working.
A query from a table with lookups will show the looked up field, just as it would if you viewed the table. However I have just created a report on a query from the table with lookups and that shows same as query, so somewhere you have the wrong source for your Store control.
I just tested on my very first DB that has table lookups (but I know what they are actually doing and have left them as DB is finished.) Since that DB I have learnt not to use them, even when I knwo exactly what is happening with them.
Upload your DB with enough to see the problem with instructions on how to replicate, if you cannot resolve this. It sounds like you are using the Store FK from another table?
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba