Hi Dlookup is not working to well, I have followed this part of the course to exactly as is in the video, the dates are just dates the format is d/mm/yyyy changed it to dd/mm/yyyy then back. I moved onto to lesson two, same problem, is possible the database has become corrupted?
Reply from Alex Hedley:
I've had major problems with DLOOKUP and the date format, I think it's due to Access expecting it in mm/dd format. I format the date before passing it to the function and it seems to work well.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.