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
Default

David,
   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,
Mike
Reply With Quote