Hello all.
I work in the field of Pharmaceutical regulatory affairs. I'm new to Access but have identified it as the best way to solve a problem in my current contract role (To avoid creating a massive spredsheet). I have a lot of experience of writing small pieces of software but only for personal use. Most of my recent experience comes from VBA mostly in Word and a little in Excel.
I'm joining this forum to seek advice regarding lookups in tables and how to use queries instead. I've come here because I've done extensive searching on the interweb and have seen the blog talking about how bad lookups in tables are but I am non the wiser on how to use a query instead.
I'll post my actual initial question in the tables forum.
Thank for any forthcoming advice.
Steve
I work in the field of Pharmaceutical regulatory affairs. I'm new to Access but have identified it as the best way to solve a problem in my current contract role (To avoid creating a massive spredsheet). I have a lot of experience of writing small pieces of software but only for personal use. Most of my recent experience comes from VBA mostly in Word and a little in Excel.
I'm joining this forum to seek advice regarding lookups in tables and how to use queries instead. I've come here because I've done extensive searching on the interweb and have seen the blog talking about how bad lookups in tables are but I am non the wiser on how to use a query instead.
I'll post my actual initial question in the tables forum.
Thank for any forthcoming advice.
Steve