Recent content by dorothyh

some fields are blank :( This does not fix the problem. The field are still blank.

I will try it tonight but the uniqueness is in the combinations of the two fields. There are hundreds of records with the same name and thousands with the same path but the uniqueness is in the combination of the two. I think I have tried this but I will check it again.

Some blank columns join field I will explain from the beginning: I am trying to put information together from records that did not get loaded. The records that did not get loaded are in the query [Fail Log]. I also need to get the information from the system that gets me information about...

Some blank columns join field How does it say that? I am dong a left join. Does a left join means something different in access then other relational databases? If the 2 tables are joins, I should be able to pull columns from both tables. This is just a small example. In the real tables I...

As stated, I created a query that join 2 tables. but when I add a field from the av table the field is blank. av table has name,color, deth [master Without Matching av] query has name,color SELECT [master Without Matching av].name, [master Without Matching av].color, av.deth FROM [master...