Search results

  1. M

    Access query will not list certain date

    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...
  2. M

    Autonumber field in DB Anywhere

    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
  3. M

    Using Between in an IIF statement

    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...
  4. M

    Thermometer chart on form

    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...
Top Bottom