Access Memo Fields

[Guest]

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,

 

[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,

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

 

[Joseph Meehan]

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,

What you are suggesting, if I understand correctly, is a typical newbie
error that is regretted later when they need to undo it.

The beauty of a relational database is exactly what you are trying to
eliminate.

This can be done using a make table or update query, but the real answer
is more likely the use of a query to display the information the way you
want to see it and not combine information. This you do with a query. It
then looks and acts like it was in a single table.

 

[Guest]

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.

 

[Joseph Meehan]

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.

I have zero experience with interfacing with FrontPage so I will not be
able to offer much.

 

[Guest]

Joseph - Thanks for your response. I really do appreciate your trying to help!

 

[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