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 GaliciaOP
@Reply 10 months ago
I ment OrderT.CustomerID=CustomerT.CustomerID)
Kevin Robertson
@Reply 10 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 GaliciaOP
@Reply 10 months ago
Thank you, Sir, I will check shortly
Rudolpho GaliciaOP
@Reply 10 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
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 6.
