Duplicates and appending

  • Thread starter Thread starter DBarker
  • Start date Start date
D

DBarker

I have access to a database that I usually pull data in
using Crystal and then take it to Excel and then into
Access. I know there has to be an easier way to start
with access and get the data that I need. Now my issue is
that the data that I am pulling say I have one record that
has multiple Note fields that correspond to that ID. I
need to pull in that ID will all the Note fields that
correspond to that ID. I tried an append but was having
problems with that. Oh and I already have an ODBC
connection setup so that is not an issue. But how can I
from access get the data I am looking for?????????????
DESPERATE~
 
I have access to a database that I usually pull data in
using Crystal and then take it to Excel and then into
Access. I know there has to be an easier way to start
with access and get the data that I need. Now my issue is
that the data that I am pulling say I have one record that
has multiple Note fields that correspond to that ID. I
need to pull in that ID will all the Note fields that
correspond to that ID. I tried an append but was having
problems with that. Oh and I already have an ODBC
connection setup so that is not an issue. But how can I
from access get the data I am looking for?????????????
DESPERATE~
Click to expand...

Why do you feel that you need to append ANYTHING?

If you have two tables in a one-to-many relationship, one for records
with ID as the Primary Key, and a second Notes table with ID as a
foreign key, just create a Query joining the two tables; or use a Form
based on the main table and a Subform based on the notes table. You're
using a relational database; that's what it's designed to do!
 
Dear all,

I have multi .mdb files and form linked one mdb to another.
That form contains functions such as docmd.runsql, dlookup/dsum, etc that
linked to specified table.
My question is how to open that form without having to link to the table
those functions using?

Thanks,
Alvin Warouw
 
Well actually I inherited this database and it is not
setup to be a relational database it is just a flat
database. I have not had time to reconstruct the whole
database as of yet but that is my ultimate goal and to
make the process more automated.
 
I have access to a database that I usually pull data in
using Crystal and then take it to Excel and then into
Access. I know there has to be an easier way to start
with access and get the data that I need. Now my issue is
that the data that I am pulling say I have one record that
has multiple Note fields that correspond to that ID. I
need to pull in that ID will all the Note fields that
correspond to that ID. I tried an append but was having
problems with that. Oh and I already have an ODBC
connection setup so that is not an issue. But how can I
from access get the data I am looking for?????????????
DESPERATE~
Click to expand...

I guess I don't understand, then.

If you have an ID field, and multiple records with duplicate data
except for the Notes that correspond to that ID, can't you just use a
query with a criterion on the ID?

Could you give an example of the structure of your flat-file table and
how the notes are stored?
 
Back
Top