Results 1 to 7 of 7

Thread: MS Access HELP!!!

  1. #1
    Registered User
    Join Date
    Feb 2008
    Posts
    4
    Thanks
    0
    Thanked
    0 times in 0 posts

    MS Access HELP!!!

    Hi, I am relatively new to MS Access and what seems to be a simple task is really annoying me because I don't know how to do it.

    I have a table with check boxes in called 'Recieved' and another called 'Recieved 2' basically. Once all the boxes are ticked in each section then a task is finished.

    How do I calculate the percentage of ticks that I have in a query?

    I have done a basic count query so I have a colum that says the number of how many true's and how many false's there are but I don't know how to turn that value into a percentage using the same query.

  2. #2
    TiG
    TiG is offline
    Walk a mile in other peoples shoes...
    Join Date
    Jul 2003
    Location
    Questioning it all
    Posts
    6,213
    Thanks
    45
    Thanked
    48 times in 43 posts

    Re: MS Access HELP!!!

    SELECT AVG(CAST([fieldname] AS float))
    FROM [table]

    Cast as float included incase you might need to cast as float.

    TiG
    -- Hexus Meets Rock! --

  3. #3
    Registered User
    Join Date
    Feb 2008
    Posts
    4
    Thanks
    0
    Thanked
    0 times in 0 posts

    Re: MS Access HELP!!!

    Thank you for your help TiG however I still have a slight problem. When I am in my design view and I am looking at the sections I can change i.e. Field; Table; Total; Sort; show; criteria.

    Where do I put the suggested statement and does it need to be in a new colum?

  4. #4
    TiG
    TiG is offline
    Walk a mile in other peoples shoes...
    Join Date
    Jul 2003
    Location
    Questioning it all
    Posts
    6,213
    Thanks
    45
    Thanked
    48 times in 43 posts

    Re: MS Access HELP!!!

    have you not got a button to use SQL view? (think its just those words on the panel where design view is)

    TiG
    -- Hexus Meets Rock! --

  5. #5
    Registered User
    Join Date
    Feb 2008
    Posts
    4
    Thanks
    0
    Thanked
    0 times in 0 posts

    Re: MS Access HELP!!!

    I have put that in the SQL view and it comes up with an error of missing operator and highlights the AS before float. If I remove the AS float function I get another error stating undefined CAST in expression

    Chris

  6. #6
    TiG
    TiG is offline
    Walk a mile in other peoples shoes...
    Join Date
    Jul 2003
    Location
    Questioning it all
    Posts
    6,213
    Thanks
    45
    Thanked
    48 times in 43 posts

    Re: MS Access HELP!!!

    I've not got Access to play with here, the logic of what i've said is correct, its just a matter of getting the access syntax right. I don't have Access here any more as its 0 use to me with MS SQL.

    I'd suggest looking up cast in the access version you are using and just ensure you've got the command written in line with that.

    Also I can't remember if Float is accepted in Access and you may need to use Number.

    TiG
    -- Hexus Meets Rock! --

  7. #7
    Registered User
    Join Date
    Feb 2008
    Posts
    4
    Thanks
    0
    Thanked
    0 times in 0 posts

    Re: MS Access HELP!!!

    Thanks TiG, I'll see what I can sort.

    Your help has been much appreciated

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. urgent help with c++ function access
    By haelly in forum Welcome to HEXUS!
    Replies: 1
    Last Post: 17-12-2007, 05:11 PM
  2. Internet access through wireless, file access through LAN
    By Impeller in forum Networking and Broadband
    Replies: 2
    Last Post: 15-11-2007, 09:08 PM
  3. Belkin F5D6130 802.11b Wireless Access Point
    By Howard in forum Reader Reviews
    Replies: 4
    Last Post: 10-12-2004, 11:20 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
  •