diode Posted January 23, 2007 Share Posted January 23, 2007 Hello,I want to write a report or form or something in which you can specify a year or table name, and then it goes and searches that table for that year. I took Access in college several years ago, but we never designed anything that let you type in data that the report or form used in order to determine which table to search. I was thinking about using a combo box or list box and then put in the years in that so it knows what to select. The place I work for wants me to do this, and I'm not even sure it's possible. I hate to make this topic because the board is MSSQL, but that was the closest I could find here. Sorry about the inconvenience. But anyway, I googled, searched the Help in Access, and all resources at my disposal, but I am not finding anything, and I was wondering if anybody knew anything about this. Thanks lol :)diode Quote Link to comment https://forums.phpfreaks.com/topic/35298-ms-access-how-to-make-a-query-or-form-select-among-different-tables/ Share on other sites More sharing options...
diode Posted January 23, 2007 Author Share Posted January 23, 2007 Oh I forgot to add this. The problem seems to be that the query has to be able to take information or parameters from the criteria you choose so it knows which tables to select from and join.Thanks :)diode Quote Link to comment https://forums.phpfreaks.com/topic/35298-ms-access-how-to-make-a-query-or-form-select-among-different-tables/#findComment-166842 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.