Cannot Join, Help - Microsoft Access Expert 6


	Back to Access Expert 6 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Cannot Join, Help

Rudolpho Galicia

7 months ago

Hello All,

I'm following along at the 8:34 mark, I added the necessary fields in my query; from the OrderT" and the "CustomerT" that included the Join Properties as well as clicked on the #2 Include ALL records from 'OrderT' and only those records from the 'CustomerT' when the joined fields are equal.

IN addition I added all the necessary Criteria needed for the "DueDate" of <=Date() and the "IsPaid" with "False". When I ran the Query and Access Dialog Message Box popped up Saying Cannot join on Memo, OLE, or Hyperlink Object (OrderT.CustomerIDID=CustomerT.CustomerID).

What am I missing??

	Rudolpho Galicia OP @Reply 7 months ago
I ment OrderT.CustomerID=CustomerT.CustomerID)

	Kevin Robertson @Reply 7 months ago
Check you haven't made a mistake with the data types in either of those Tables. CustomerID in the Customer Table should be AutoNumber. CustomerID in the Order Table should be Number.

	Rudolpho Galicia OP @Reply 7 months ago
Thank you, Sir, I will check shortly

	Rudolpho Galicia OP @Reply 7 months ago
I checked, and well, yes, the CustomerID in the "Order Table was something other then Number" That's why It didnt work. Thank you I was racking my brain for hours. Maybe I should be working on this stuff so late at night lol, Thank you again Kevin RG

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Expert 6.

Next Unseen

New Feature: Comment Live View