TechSpot

#Name? error in Access 2007

By Rage_3K_Moiz
Mar 15, 2008
  1. I'm making a project for my brother and I've chosen Access to do it, since I made mine in it. I've done some of it but I'm stuck at this part. I'm trying to use the DateAdd function to add a month to a date field, but I keep getting this error. It also happens when I try to add a month to any date i.e.
    =DateAdd([m],1,9/3/2001)
    and
    =DateAdd([m],1,[Last Date of Fee Payment])
    return the same error. Last Date of Fee Payment is a separate date field in a table.
    Any and all help will be greatly appreciated.
     
  2. raybay

    raybay TS Evangelist Posts: 7,241   +9

    It appears you are using the command for an earlier version of Access. Look at the knowledge base for Microsoft Office 2007. We have found a number of such little changes in 2007.
    Also, be sure you have all the updates, and the download that allows Office 2007 to work with earlier versions.
     
  3. Rage_3K_Moiz

    Rage_3K_Moiz Sith Lord Topic Starter Posts: 5,431   +28

    Thanks raybay, I found the culprit. Apparently all I have to do is put double quotes around m instead of the square brackets. That fixed it. Thanks again for your help.
     
Topic Status:
Not open for further replies.

Similar Topics

Add New Comment

You need to be a member to leave a comment. Join thousands of tech enthusiasts and participate.
TechSpot Account You may also...