Results 1 to 4 of 4
  1. #1
    vjhannaford is offline Novice
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Dec 2010
    Posts
    3

    Doing Access7 in office 10

    Help I doing Access 7 a college class but I'm using micro soft office 10.


    I'm having problems with a Creating function and a query
    here is what I'm doing The function says
    Function Contribution(fg, threept, ft, offreb, defreb, assists)
    Contribution = (fg * 2 + threept * 3 + ft + offred * 2 defreb +assists * 2)
    Then the query says Rank: Int(Contribution([FG][3P][FT][Reb-O][Reb-D][Assists])) and I get this message The expression you entered contains invalid syntax.
    Help!!!

  2. #2
    SoftwareMatters is offline Access VBA Developers
    Windows XP Access 2003
    Join Date
    Mar 2009
    Location
    Dorset
    Posts
    274
    Which line of code do you get the error on?
    Do all the variables have values?

  3. #3
    vjhannaford is offline Novice
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Dec 2010
    Posts
    3
    I get the error on the query the 3p turns black Really I have know idea what I'm doing it for a class online.hope that helps. I'm not getting a code on the function part of this it comes up in the query part.

  4. #4
    vjhannaford is offline Novice
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Dec 2010
    Posts
    3
    I skip part of the Assignment hope she like it thanks for the help

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

Similar Threads

  1. Office 2010 and linked table manager Help
    By bobfin in forum Access
    Replies: 8
    Last Post: 08-05-2010, 07:15 PM
  2. Office versions with Access 2007
    By Coolpapabell in forum Access
    Replies: 0
    Last Post: 09-29-2009, 09:37 AM
  3. Access 97 compatable with Office 2007??
    By mkattengell in forum Access
    Replies: 1
    Last Post: 09-08-2009, 04:24 AM
  4. Replies: 4
    Last Post: 06-09-2009, 09:00 AM
  5. Replies: 1
    Last Post: 06-09-2006, 03:55 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