Results 1 to 4 of 4
  1. #1
    RudeRam is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    2

    Question Creating Custom Fields

    I want to add a custom field to a query I've built, however when I add the name Keys Cost: I get the error box stating The expression you entered contains invalid syntax.



    Did this change from 2007 to 2010?

    Thanks
    Rick

  2. #2
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    What did you include after the

    Keys Cost:

    part?

  3. #3
    RudeRam is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    2
    Thanks for the reply:

    Just as the book I am reading say add a colon after the field name, do I have to add something else after the colon?

  4. #4
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    Yes, you need something even if you just use

    MyField:Null

    but I don't see the point of that since it isn't going to be updatable and so therefore you won't be able to use it for anything. What is it you are really trying to accomplish with this?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 06-20-2011, 03:56 PM
  2. creating custom switchboard
    By cnstarz in forum Forms
    Replies: 0
    Last Post: 05-25-2011, 12:18 AM
  3. Creating Custom Ribbons
    By disco_stu in forum Access
    Replies: 1
    Last Post: 07-13-2010, 06:10 PM
  4. Replies: 1
    Last Post: 12-16-2009, 04:17 AM
  5. Creating a *Good* Custom Message Box
    By Jerimiah33 in forum Forms
    Replies: 1
    Last Post: 11-09-2005, 04:47 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums