Access Memo Fields

T

TXGirl

I have an Access db that is populated from a FrontPage website. The
information is submitted to a table called "Results." I need to combine
records from the table when the Name, date, and year are the same, so that I
have only one record with all the Details ( which is a memo field ) in one
field.

I'm a newbie, so any help would be appreciated.
Thanks,
 
J

John Vinson

I have an Access db that is populated from a FrontPage website. The
information is submitted to a table called "Results." I need to combine
records from the table when the Name, date, and year are the same, so that I
have only one record with all the Details ( which is a memo field ) in one
field.

I'm a newbie, so any help would be appreciated.
Thanks,
Click to expand...

I'd really have to question this! Storing multiple pieces of
information in a single field is rarely a good idea. You're using a
relational database; use it relationally - might it not be better to
have two tables in a one to many relationship, so that the Name and
Date are in one table (the date includes the year so don't use a
separate field), and the Results are stored, one result per record, in
a separate linked table?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
T

TXGirl

Thank you and John for responding.
Let me expand on the problem. The users submit their information through a
FrontPage submission form. They are not allowed to edit any previous
entries, so they are entering multiple entries with the same Name, Date, and
Year, but with different information in the Details field. The manager wants
to be able to pull the information, from FrontPage, and see one record for
TXGirl, October, 2004 and all the Details. ( I didn't create the database, it
was generated by FrontPage, I just get to support it.)

I have used a make table query to create a new table, and I have created an
update query to populate it, but all this is done manually. Is there a way
to automate it so that when an entry is made in FrontPage and submitted that
the update query is automatically run?
Thanks again for your help.
 
C

Chuck Wood

If I understand you correctly, what you want to do is create a form or
report (which?) that aggregates the details field of a database into one
"field" and only shows one instance of the Name, Date, and Year. Is this
correct?

If so, there are a couple of ways to do that.

Chuck Wood
 
Top