Join querie help for a newbie

[qurn]

I just got done creating a join querie (two tables one relationship to make one querie) and now I can't edit the fields. is this normal? if its normal is there any way I can edit the fields?

 

[Exodus]

yes this can happen. Why I'm not sure I'm the Gurus around here can explain it. Is it possible you have records in iether table that are not in the other? Or did you use the group function on this query that will do it also.

 

[qurn]

Is it possible you have records in iether table that are not in the other?

Yes I think so. In the related colomns one had allot of null values where the other was completely filled up. but that is kinda what I need in order to compare and contrast

did you use the group function on this query

I don't know please tell me more.

 

[Exodus]

So have a left or right join here right.

the group is that Greek looking E in the tool bar when you use it you can group, count, sum ect in the query. It doesn't sound like you are using it.

Are you trying to find records that are in one but not the other.

 

[qurn]

Are you trying to find records that are in one but not the other.

Yes. I know it doesn't realy follow rule of good database design or normalisation but I have my reasons for keeping the two seperate.

 

[Exodus]

Are you keeping the same information in both tables? Ie fields
If so it is a bad move but thats your choice.

For comparing tables Access 2k has query wizard that will do this for you
you will have to create one for each side of the join though example

records in A not in b
records in B not in a

What editing are you trying to do

 

[qurn]

I work for the state in the amusement safty division (notice avatar). so I'm comparing a list of rides to a engineering log, that I converted to access for easy reference. I'm comparing manufacturers and serial numbers. Now this one log is also on paper so I cant change it in any way, this is for my boss who perfers a reference to any old records we may have. The engineering log was put together horibly too.

so I would have to make two seperate quiries more or less. I seem to remeber making join quiries before and not having this problem. how can access tell it's the same info in different tables?

 

[Exodus]

It will ask you which fields you want to compare

 

[Exodus]

Are you trying to move records that are not in one table to the other?

 

[qurn]

mostly copy and paste stuff.

 

[Exodus]

Entire records ore just fields?

 

[qurn]

just fields

 

[Exodus]

So you would basicly be updating records from one to the other.
I would use the update query. Make sure your logic is acurate and make copies of your tables before you run it on the originals. Thats the best I can offer.

 

[qurn]

Forgive my ignorance, but how do I use a update query?

 

[Exodus]

I usualy use the design grid to build my queries. On the tool bar there is the query section in it you will see the different types of queries select update

this will put a row in the design grid for update to

basicly you will degsing your query with criteria for the fields you want to change then put what you want it to change to in the update to.