Variance Query

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Steven R via AccessMonster.com" <forum@xxxxxxxxxxxxxxxxx>
Date: Tue, 26 Jul 2005 21:14:06 GMT

I have a query which compares the "NOTES" field in the ContractsNew table vs.
the same field in the ContractsOld table - my syntax is simply:

<>ContractsOld.Notes

in the criteria field under ContractsNew.Notes - so simple, yet it doesn't
work - I have used this before - any troubleshooting ideas ?

Thanks !

my e-mail is
steven.j.rollins.-nd@xxxxxxxxxx
.

Follow-Ups:
- Re: Variance Query
  - From: John Spencer (MVP)

Prev by Date: Re: Summing an Expression
Next by Date: Is there a way to use a WatchDog???
Previous by thread: converting text
Next by thread: Re: Variance Query
Index(es):
- Date
- Thread