DLookup Help Please

Copper Contributor



I have a Sum Query [qPPHAVG2WK] that has three fields: [EMPLOYEE ID], [WORKDATE] and [PPH].  The Sum Query actually gives me the Average of [PPH] over the last two weeks.  This Query works just fine.


I am trying to use DLookup on a separate Query to to retrieve this Average [PPH] for each employee, but I am having an incredibly hard time.  What am I missing?  I really appreciate your help.

1 Reply

Hello scottybing,

would be nice to have more details e.g. screenshots about what you are trying to do with your queries and in which editor you are working with that.

I suppose you are writing an Access VBA code whith the VBA editor to create that query.


Or are you creating that sum within the query editor without VBA? In that case i think you can create a sql syntax in your query editor and use the SUM aggretions in your Tab "DRAFT" of your query. Maybe you dont need to work with the dlookup function, because must sums are created within the aggregations already, if you activate it. But without more information its hard to help you.


Greets, Eva.