Hey, Marcia
Had I originated this sytem no way I would have called it TIME, or DIRECTN instead of DIRECTION, et al. However, this field appears in a myriad of forms and progs. Never caused a problem though.
Cheers
Terry
>
Can anyone suggest why the following code should have C5'd at the end of the 2nd SQL select below (near bottom of Scan)?>
>This is also a WAG ( Wild A** Guess < s > )
>
>TIME is a reserved word. Try changing the name of the field to something else.
>
>As my good friend, the late Tom Piper, used to say:
>
>"When it turns blue, MODI STRU"
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.