User Profile

Collapse

Profile Sidebar

Collapse
Drivememad
Drivememad
Last Activity: Mar 20 '07, 01:51 PM
Joined: Nov 6 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Drivememad
    replied to Record for every date
    in Access
    Hi All

    Thanks for your help and responses, I have got this one sorted now

    Cheers
    See more | Go to post

      Leave a comment:

    • Drivememad
      replied to Record for every date
      in Access
      Thanks Nic

      I know what you mean, but I'm not sure that that is what I am looking for, so I'll have a sleep over the weekend and think about what I am really looking for and stop wasting everyones time

      Cheers again Nic
      See more | Go to post

        Leave a comment:

      • Drivememad
        started a topic Record for every date
        in Access

        Record for every date

        Hi

        Not 100% how to do this but I am sure it can be done, so your help would be greatly appreciated.

        For example, I have a crosstab qry to count admissions and group by day. At the moment if there isn't an admission on a particular day then the records may jump from 15/11/2006 to 17/11/2006. What I would like to do is have a continued list to show the 16th as well showing a zero count.

        I have created...
        See more | Go to post
        • Drivememad
          replied to Max date between two dates
          in Access
          Many Thanks

          Sorted my query based on your SQL.
          It was simple really....derrr , mental blockage

          Once again thanks
          See more | Go to post

            Leave a comment:

          • Drivememad
            started a topic Max date between two dates
            in Access

            Max date between two dates

            Hi
            Can anyone please help me with the loookup function or VBA for my problem?

            Query 1 is a list of all patient results (multiple)
            Query 2 is a list of all inpatients at a given point in time.

            I want to report on the max result date where it is between Date1 and Date2 in the inpatient list.

            Thanks in advance
            Julie
            See more | Go to post
            No activity results to display
            Show More
            Working...