Search results

  1. T

    VBA Delete table module

    Hi all, I have an access database (97) and I have a main table (Rectrans) and several child tables (ADV, CBL etc) Basically, I want to be able to delete records that are more than 7 years old from the last date in the Rectrans table, and any related records in the child tables. Here is the...
  2. T

    Select Qry into a Delete Qry

    All, I have a select query: SELECT RECTRANS.ContractNumber, Max(RECTRANS.TransactionDate) AS MaxOfTransactionDate, DateAdd('yyyy',7,Max([RECTRANS].[TransactionDate])) AS Expr1 FROM RECTRANS GROUP BY RECTRANS.ContractNumber HAVING (((DateAdd('yyyy',7,Max([RECTRANS].[TransactionDate])))<Now()))...
  3. T

    joint expression problem - query

    guys, when I try to edit queries in my database, i get an error message: microsoft access cannot represent the joint expression transaction.number = tempimport.field1 in design view. * one or more fields may have been deleted or renamed * the name of one or more fields or tables specified in...
Back
Top Bottom