The way the information is pulled now is I have assigned variables to each question (e.g., Age = AG) I use a lookup table to find AG and pull the value from the adjacent cell. This method allowed me to change the order of the questions if needed. I would like to something similar is Access...
Sorry to confuse you. THe data entry form is an excel file sent to clients. They input their information and send back via email. I am looking for a way to input this information into a db.
Whats up everyone I am a fairly new user to access and I am trying to develop a database to hold quarterly data from multiple companies. What is the best approach getting the information off the companies data entry form into the database. The data entry form does change over time so I cannot...