Larry, Thanks for that info. In my Access table I am using a text field for the date as I have not figured out how to input as a date format from a ZSQL method. The types I am aware of are string, nb, float and int. Is there another type for date format input? Thanks alot. Rob