Search results

  1. C

    Creating & Populating Temporary Table from String

    I'm trying to create a temp table, which is populated by a string, (taken from a recordset). My problem is incorporating the String into the SQL statment, and making it work, What I'm trying to do is to create a temp table, and populate it with the first record of the recordset, (which is an...
  2. C

    Problem Referring to Table Field

    Hi, I'm trying to run an if statment, on the records in a field (called "Current_Month"), in an existing table called ""Current_Months_Lag1_Data". The IF statements work fine - and simply perform a different action for different data in "Current_Month". I am having problems referring to...
  3. C

    Append Data from 2 Tables (w/ matching fields) into a 3rd Table - with DAO Recordset

    Hi, I'm trying to replace an Append query - which is pretty slow to run. The query appends data from fields 2 tables (based on a JOIN between the 2 tables) into a 3rd table. To achieve this, the query needs to review all records on Table 2, and find matches in Table 1. (After reading...
  4. C

    Using IfNull as criteria for Recordset

    Hi, I have a table called "CRP_Match_Master", where one of the fields called "861_Reference" contains some null entries. I want to use VBA to display the table records on a form, where "861_Reference" has Null entries. I have tried to achieve this using a DAO recordset, where the recordset...
  5. C

    Problems with Simple Cumulitive 'Running' Totals.

    Hi, I have a very simple table called "ABC Analysis Table_02", with 2 fields [Item] and [Max 12 Months Dmd Value]. The table is sorted by [Max 12 Months Dmd Value], descending. I want to create a query using DSUM to calculate a cumulitive running total on field [Max 12 Months Dmd Value]...
Back
Top Bottom