Can't outer join or append.

S

Steven

I am getting daily data from units that may or may not be reporting each day.
If I use an inner join, then the units that do not report on any given day,
are dropped from the query.

I tried to do a multiple join but evidently Access will not permit more than
two tables to be joined using an outer join.

So I tried entering the data using the first day of data to establish the
original query, and subsequent days to append to it. I got an error message
stating that my original query was not updateable.

What now?
 
D

Dirk Goldgar

Steven said:
I am getting daily data from units that may or may not be reporting each
day.
If I use an inner join, then the units that do not report on any given
day,
are dropped from the query.

I tried to do a multiple join but evidently Access will not permit more
than
two tables to be joined using an outer join.

That's not strictly true; it depends on the directions of the joins.
So I tried entering the data using the first day of data to establish the
original query, and subsequent days to append to it. I got an error
message
stating that my original query was not updateable.

Please describe your tables, the relationships among them, what exactly you
are trying to do with your query, and the SQL you've tried. My guess is
that you're going to want to use a form/subform arrangement to enter your
data, but I don't have enough information to do more than speculate.
 
D

De Jager

Steven said:
I am getting daily data from units that may or may not be reporting each
day.
If I use an inner join, then the units that do not report on any given
day,
are dropped from the query.

I tried to do a multiple join but evidently Access will not permit more
than
two tables to be joined using an outer join.

So I tried entering the data using the first day of data to establish the
original query, and subsequent days to append to it. I got an error
message
stating that my original query was not updateable.

What now?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top