Well, I didn't import "everything" exactly. I used the wizard to leave off
the duplicate information.
The spreadsheets contain information about candidates that we have
assessed
at a consulting firm. There is a lot of data for each one (raw scores,
percentiles, other rankings) and there are different scales they could be
ranked on, based on their position. We call that the "Report Form" in the
spreadsheet and there are 12 possibilities. When I imported the data, the
lines of data that had a value for that column have that report form name.
However, I moved this data to Access because last week my assistant made a
sorting error and almost destroyed 2 years worth of data. I want her to
use
Access from now on to enter the data.
So, to make sure we don't have spelling errors, etc., I want a drop down
for
the Report Form entry. But, in my form, if I change what is now a text box
to
a list, there is no data in the entry anymore. Is there a way, other than
just creating a new entry on the form and leaving the old one there as
well,
to keep the data I imported, plus use a list to add new data?
Thanks,
Kim
Jeff Boyce said:
Kim
If you actually only "imported everything [from Excel]", your tables in
Access are probably not particularly well-normalized. Access has some
great
features/functions, but it "expects" to be working with relational, not
'sheet, data.
"How to" depends on how your data is structured. Please provide more
specific information about your data ...
Regards
Jeff Boyce
Microsoft Office/Access MVP
kimhelms said:
I imported everything and I can create a form with the wizard, but I
would
like to be able to use a list box for one of the entries moving
forward.
The
issue is if I change the entry in the form from a text box to a list, I
lose
the data that came over in the import as text. I hope I'm explaining
this
well.
Thanks,
Kim
