I have a number of web tables for the back end of the database I made. I have a non-web front end application for offline use, because the web friendly macros that access provided made me want to throw my computer out of a window. It will be published to the web in the future, but for now there's a regular VBA driven front end.
So I have a number of lookup fields in a table. I joined two tables in a query and would like to display the results of that query in a report. If I open the query in datasheet view, the looked up data is there. If I run the report, it displays the ID of the lookup table entry in the lookup fields. Is there a way to display this easily without a cluttered SQL query and a plethora of joins?
So I have a number of lookup fields in a table. I joined two tables in a query and would like to display the results of that query in a report. If I open the query in datasheet view, the looked up data is there. If I run the report, it displays the ID of the lookup table entry in the lookup fields. Is there a way to display this easily without a cluttered SQL query and a plethora of joins?
