User Profile

Collapse

Profile Sidebar

Collapse
nevzab
nevzab
Last Activity: Sep 14 '07, 09:02 PM
Joined: Sep 14 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • nevzab
    replied to How do you query a table without duplicates in access
    in Access
    If the duplicates are identical, i.e. the duplicated names are identical, then all you have to do is click on the Totals button on the toolbar in your query. Ensure that the TOTAL field is set to 'Group By' for your Name field....
    See more | Go to post

      Leave a comment:

    • nevzab
      started a topic Footer caculation on Continuous Form
      in Access

      Footer caculation on Continuous Form

      Using Access 2003

      I have created a continuous form with an iif statement in the detail section which i'd like to sum in the footer. The iif statement is in a text label called [count]; iif([coninc]='Correct',1,0) . When I attempt to add a text label to the footer as follows, =sum([count]), it returns error?

      Please help me...it's driving me nuts!
      See more | Go to post
      No activity results to display
      Show More
      Working...