Recent content by GDTRFB

MajP, absolutely, i really liked your idea of limiting the recordset to only return what i need to do the math.

Hi everyone, Thanks for all the recommendations. A little more background on my situation. The dataset comes from a data warehouse in a denormalized format ordered chronologically by timestamp. Each source/location and value combination includes roughly 35k records. In my...

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

Hi all, thanks for the suggestions. hopefully to better illustrate what i'm trying to do, I've attached a spreadsheet with some dummy data.

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

Thanks MajP for your help. I re-thought my approach based on your example and ended up going with a temporary table. Thanks again

Thanks MajP. You description and examples are very helpful. In a nutshell, i'd like to create a function, called from a query, that assigns child field values to variables from which I can perform custom calculations within the function send the results to the query. I thought about...

to help put this into context, here's an example of one the loops. thanks i = rs!ParentFK 'set ParentFK VarA = rs!ChildField1 ‘assign variable ordinal position Do Until rs.EOF ‘loop through child records with same...

hi everyone, thanks for all the input. with respect to SQL, as many of you mentioned, SQL would be preferable but unfortunately the calculation logic I need to perform is beyond what SQL aggregate functions (e.g. running sum) and subqueries can do. I showed a simple sum, but in reality I...

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