E.G. Query with two Tables Joined Fails

[BillB]

I have two tables that I have joined and have attempted to run a query.

It's an Inner-Join with two similar fields joined.

Each time I run it it fails.

Any suggestions?

[Linlin]

Make sure the fields have same data type.

[BillB]

They do.

[Linlin]

What do you mean by "failed"?

do you want to post your log file?

[BillB]

I finally got the join to work and successfully output a joined data set.

I just used two fields that associated in both tables.

Not sure why the other fields I used didn't work.

Any clues and thanks for your quick response.

[ballardw]

It is  hard to diagnose code issues without code.