Where are all the MVPs? Urgent Q!

G

Guest

I posted this yesterday, and reposted it today, but there haven't been any
replies. I realize that you all visit and participate in this forum as
volunteers, but usually this forum moves pretty quickly. (Maybe everyone is
glued to Katrina coverage? Taking a break because it's the end of the summer
in the US?) I am desperate for advice and suggestions.
students' records in an Access database that was here when I came on the job
a
while back. I don't know much about relational databases and the bosses have
bought me the Absolute Beginner's Guide to Access (which helped me not be so
fearful of Access) and sent me on one training seminar. My only other
computer background is in word-processing, as a secretary (and that was quite
a few years ago). So most of my information comes from what I can find on
the internet combined with my little book, tsk. So I appreciate all that I
have and will learn from this newsgroup and it's resources.

Now the question. We are getting new members from our website. However,
there is a chance that some of the kids who reply to our website are already
in our database (there are at least two that I definitely know of). My boss
wants us to have the most up-to-date database of qualifying youth in our
city, by starting a new database of just web-site respondents. IMO, I should
just create a new field, name it something like "webhit", and add the new
kids to the d/b, and give some data for that field for the kids who replied
to the website but are already in our system (like maybe the website hit's
transaction number, or simply a yes/no option) to be able to tell which
records are a result of the website's form.

What is the best way to do this (and the simplest)? I do NOT know anything
about programming, other than how to use the design wizards in Access.<<
 
D

Duane Hookom

You could add a field to your table and store the "source" of the
information. I would probably use a small lookup table of the different
sources much like the Shippers table in Northwinds.mdb.

I would not create a new table or new database.
 
J

Jeff Boyce

Just an FYI ... the folks who frequent these groups, including the MVPs, are
international. If you didn't get responses right away, ... maybe it was
random variation?!

Jeff Boyce
<Access MVP>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top