Search results

I am not sure I understand. If I enter 8/9/06 all records are returned with the date of 8/9/06 regardless of the time, but when I enter 8/10/06 no records are found. It is true that the default for this field was NOW() but I checked and none of the records for 8/10/06 have 00:00:00 as the time...

I have a query that reports on records according to date. The criterea line of the date field has [Enter Date]. I have confirmed that there are dates from 8/1/06 through 8/10/06 in the table, but when I enter the date 8/10/06 the query returns no records. But it does return records for all...

Has anyone had to set up an AUTONUMBER field in Db Anywhere (v 3.08p). The program does not have AUTONUMBER as a field type so I was wondering if this can be accomplished using some function or other coding. Thanks mtom5

Problem solved Thanks JOE C !! I used you format tip and replaced some parens with "'s and it worked Here is the working expression Expr1: IIf(Format([CALL IN],"Short Time") Between "07:00" And "15:30","1st Shift",IIf(Format([CALL IN],"Short Time") Between "15:31" And "23:30","2nd...

I am trying to display Shift information in a query by using the following IIf(Time([CALL IN]) Between (07:00) and (15:30),"1st Shift",IIF(Time([CALL IN]) Between (15:31) and (23:30) ,"2nd Shift",IIF(Time([CALL IN])Between (23:31) and (06:59) ,"3rd Shift"," "))) and I am getting a message "The...

Thanks Thanks SJ. That tip worked great !!

I am using a one column chart on a form (unbound object) which references a query that sums a field in my table that tracks monetary amounts. As I enter records and go to the next record the chart does not update. It only updates when I close and then open the form. Has anyone had experience...