>from tblClientDailes cd
>inner join tblClients c on c.clientName = cd.clientName
>where cd.dailliesDate between '#date1#' and '#date2#'
>and c.acctStatus = 'A'
>and cd.clientName like '%marsh%'
>group by c.clientName
>
Thanks for the quick response! Excuse my ignorance, but what do you mean by cd on the from line?
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
