Search results

  1. G

    Subtracting Consecutive Records in Large Dataset

    Hi all, I have a dataset which lists consecutive snapshot readings grouped by different sources. Example dataset PK Location Source Timestamp ReadingValue_1 Reading_Value_2 1 HouseA GasMeter...
  2. G

    VBA Import Routine for Data Transformation

    Question: How can I transform data from columns to rows and auto-populate foreign keys using VBA from a spreadsheet import data source? Scenario I have a situation where I have to import data from a MS Excel spreadsheet into an Access DB. The spreadsheet data is in a flat file format. The DB...
  3. G

    Call VBA Looping Function from Query

    Hi all, Question: is it possible to call a VBA function which loops through the records from within the same query? I have a simple parent-child table relationship where I’ve created a VBA function (e.g. SomeFunction) to loop through the child table to: 1. Identify child values...
Top Bottom