This is probably a simple fix but I can't see it. I am at 10:58 in the video. My report comes up with "#Type" for the Address, Dear [FirstName} and Days Late. To see if the query was working, I ran the OrderCollectionLetterQ without the "Between" Function in the DueDate and it produced values in a table - when I put in the Between Function - it produces nothing. My table has due dates that range from July 1 - Sep 5. My Form date range is Jan 1 to Aug 26 yet the fields won't populate in the report.
Reply from Richard Rost:
Janet, without seeing your database it's very hard to troubleshoot this kind of a problem.
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.