[GENERAL] Use of datepart() on TimeStamp.

2000-01-28 Thread Jeffrey Silberberg
Using Access 97 I have a Database field defined as a time stamp being pulled in as a data type of date/time which is correct. My problem is that I now what to add some criteria to select it and have tried both the criteria of Date()-1 which results in an empty set, and createing a new field

[GENERAL] MS Access Issue..

2000-04-06 Thread Jeffrey Silberberg
Morning all, I have a weird problem all of a sudden. In an PG Database I have a text field that was mapping to MSA/97 as a type Memo and working fine, all of a sudden the field is mapping to Memo after I relinked it do to some changes in the PG table and truncating my data with the left