Search results

  1. P

    Updating Table from a Query

    0 down vote favorite Hi, was wondering if anyone can help me out with this. I have a table and a query both of which have the same [Resource ID], [Resource Name] fields. I am trying to update the [CBL_1_Date], and the...
  2. P

    Counting Rows in Query Groups

    Hi, I've been rattling my brain over this all day and was wondering if someone can help me out. I have a query with about 7500 records that are grouped as follows and sorted by Mtr_Reading ID Name Event_Start_Time _Hour, Mtr_Reading 2210 XYZ 7/15/2013...
  3. P

    Problem accessing recordset fields with variable names

    Help! I have a query with enumerated field names (i.e. CBL_1_kW,CBL_2_kW,CBL_3_kW,......CBL_10_kW) I'm trying to construct the field names with a counter and feed them into an array where I can sort them later. (i.e. rs!["CBL_"& Str(i) & "_kW") The problem I am having is that the program...
Back
Top Bottom