View Single Post
  #2 (permalink)  
Old March 21st, 2004, 06:27 PM
Dataman Dataman is offline
Authorized User
Join Date: Jun 2003
Location: Glendale, AZ, USA.
Posts: 75
Thanks: 0
Thanked 0 Times in 0 Posts

   This solution will work in the query for your report.

   iif([Frequency]="D", Count([Frequecy])*250, iif(Frequency=7W, Count([Frequency])*365))

   The code may not be exact, but you get the idea. Just keep adding iif statements for each of the frequency's you want to test for. I'm sure it can be done with in the query.

Hope this helps,
Reply With Quote