Search results

  1. K

    Access Forms

    Hi, I'm hoping someone can help. I created a database that will be updated by one group, and then 'selected' information viewed by another. I used forms (for the reading group) to select from dropdowns, run queries, and then display what's requested on a report. Each time the dropdown is...
  2. K

    Group and calculate by day of week

    Hi, I'm hoping someone can help me; not very good with MS Access yet and definitely not versed in VB. Using Access 2002-2003. What I'm trying to do is Group / calculate on 2 types of incidents Sorted (and 'summed up' by Day of the week. So if we had Incident1 3 times Sunday this week, 4 times on...
  3. K

    Count(*)

    Hi! I'm hoping someone can help me with this. I need a descending sort on a textbox that has =Count(*) as its source. Nothing I do (filter, sort) works. The totals display for each group (grouped by the field Service Category). When I run a query, each record has 'countofService Category'...
  4. K

    Parameter query as a controlsource

    I have a parameter query with 'From' and 'To' dates that I create a report with. Is there anyway to use the From and To dates as a control source for the report ? I'd like the report page to include the dates as a header, since they will be changing. Thanks in Advance if anyone can help!!
  5. K

    Can't save changes to a form

    Hoping someone can help with this. No matter what I do I can't save changes to a form I created about 6 months ago. I was able to when I first created it. In searching for similar problem I came across info that seemed to indicate there's 'maintenance' to be done for databases every once in...
  6. K

    Access duration calculation

    Hi! I'm new here; hoping someone else has run into this and can help. I'm calculating durations; recently added =Format(Int([text48]/60) & ":" & [text48] Mod 60,"Short Time") to 'Issue Duration' Control Source where text48 is the calculation: =((([Issue Ended]-[Issue Started])*24)*60)...
Back
Top Bottom