User Profile

Collapse

Profile Sidebar

Collapse
philfreer
philfreer
Last Activity: Oct 20 '06, 01:40 PM
Joined: Oct 10 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • philfreer
    replied to ACCESS Query Calcs: Number
    Sander, thanks. That answered another problem I was experiencing, but I think that I didn't write up the problem correctly. What I'm trying to do is calculate how many, for example, Mondays did I shedule pickups in Area "A", not how many pickups were performed. Inotherwords, during a 1 year period, how many Mondays were spent in Areas "A", or "B", etc. regardless of the number of pickups that were performed. Again, thanks,...
    See more | Go to post

    Leave a comment:


  • philfreer
    started a topic ACCESS Query Calcs: Number

    ACCESS Query Calcs: Number

    Former Access user trying to recall how I would do this in a query for a nonprofit furniture bank: I have related tables (extracted from super-old PFS files) with records of individual donor pickups that include, among others, the following fields: DateOfPickUp, DOW (day of week, e.g., "Monday", "Wednesday" , etc.), Area (of Pickup, e.g., "A", "B", "C", & "D"). I'm trying to calculate,...
    See more | Go to post
No activity results to display
Show More
Working...