I need help with my query

  • Thread starter Tom via AccessMonster.com
  • Start date
T

Tom via AccessMonster.com

Hi
Ive been tring to get my query to work but Im afraid its beyond my skill
level. Here it is:

LetterOrVisitThisyear: IIf((DateDiff("yyyy",Date(),Nz([LastVisitDate],(Select
Min([DateSent])From TblSIP WHERE [tblSIP]![BusinessID] = [tblBusiness]!
[BusinessID] ))) Mod 3)=0,"Visit","Letter")

I want it to select only the records that are currently showing on my form.
How do I get it to isolate only the records that have the same BusinessID as
the form is currently displaying.

Can I change this expression to use it in a control on a form? What changes
would I make? Would I use it as the control source?

Thanks

Tom
 
M

Michel Walsh

Hi,


Try replacing your SELECT MIN(DateSend) ... with a DMIN( "DateSend",
...., ... ).


Hoping it may help,
Vanderghast, Access MVP
 
Top