September 5th, 2002, 10:38 AM
Can anyone tell me why this worked 5 mins ago, but doesn't now
Can anyone tell me why this worked before I came in here, and doesn't now?
I had 20 fields in the query. Added another two and it stopped working, so I presumed it was too many fields and removed the last two to be added thinking this would solve the problem.
CAN ANYONE HELP, IT'S DRIVING ME UP THE WALL.
I thought I had this cracked after I spent all day yesterday working on it, then the query wass to complex using IIf! Now with the Nz it suddenly seems no better.
Please let me know how you get on