S
SusanC
I'm trying to find out if like fields in similar tables contain the
same values or if some contain a different value. The fields will
contain 1's and O's Some tables do not contain all fields.
Example:
Region 1 Region 2 Region 3
Item _______Flag___Item______Flag ______Item_______Flag
hammer_____0 _____hammer___ 0 ________hammer____1
screwdriver__1 _________________________screwdriver_1
wrench______0____wrench ____0 _________wrench ____0
file_________1____ file________0
The result I would want would be the records of the items that have
differing values in "flagged."
In this case, it would be
Region 1__________Region 2 _____________Region 3
hammer ____0_____hammer______0 _______hammer____1
file________1 _____file__________0
How do I search the rows for one value, a 0 or a 1??
I created queries that would pull out everything with an O and
everything with a 1. I could create some kind of query to compare the
two, but it doesn't pull in the rows that aren't in every table. I
also thought about getting an average of each field. Then I'd see if
they were whole numbers or fractions. The fractions would contain 0's
and 1's.
I could use append tables to create one table and normalize my data,
but when I do, it doesn't include all the fields, even when I created a
master table with all fields to append to. It has to be easy to pull
data into because we are pulling this data out of another master
database that contains databases for about 30 regions, and it would be
easiest to just import or paste the data from each region into its own
table, since we can't just pull in columns, since every region does not
have every product. The data will have to be imported or pasted in
everytime we run this program.
Thanks for any help. I can do simple stuff, but this is a challenge I'd
really like to figure out. Wouldn't hurt my reputation around here
either, since no one else can figure out how to do itl
So . . . how can I deal with those blanks (values) to get the results
I need?
same values or if some contain a different value. The fields will
contain 1's and O's Some tables do not contain all fields.
Example:
Region 1 Region 2 Region 3
Item _______Flag___Item______Flag ______Item_______Flag
hammer_____0 _____hammer___ 0 ________hammer____1
screwdriver__1 _________________________screwdriver_1
wrench______0____wrench ____0 _________wrench ____0
file_________1____ file________0
The result I would want would be the records of the items that have
differing values in "flagged."
In this case, it would be
Region 1__________Region 2 _____________Region 3
hammer ____0_____hammer______0 _______hammer____1
file________1 _____file__________0
How do I search the rows for one value, a 0 or a 1??
I created queries that would pull out everything with an O and
everything with a 1. I could create some kind of query to compare the
two, but it doesn't pull in the rows that aren't in every table. I
also thought about getting an average of each field. Then I'd see if
they were whole numbers or fractions. The fractions would contain 0's
and 1's.
I could use append tables to create one table and normalize my data,
but when I do, it doesn't include all the fields, even when I created a
master table with all fields to append to. It has to be easy to pull
data into because we are pulling this data out of another master
database that contains databases for about 30 regions, and it would be
easiest to just import or paste the data from each region into its own
table, since we can't just pull in columns, since every region does not
have every product. The data will have to be imported or pasted in
everytime we run this program.
Thanks for any help. I can do simple stuff, but this is a challenge I'd
really like to figure out. Wouldn't hurt my reputation around here
either, since no one else can figure out how to do itl
So . . . how can I deal with those blanks (values) to get the results
I need?