Home

DLookup Help Please

%3CLINGO-SUB%20id%3D%22lingo-sub-355674%22%20slang%3D%22en-US%22%3EDLookup%20Help%20Please%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-355674%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20Sum%20Query%20%5BqPPHAVG2WK%5D%20that%20has%20three%20fields%3A%20%5BEMPLOYEE%20ID%5D%2C%20%5BWORKDATE%5D%20and%20%5BPPH%5D.%26nbsp%3B%20The%20Sum%20Query%20actually%20gives%20me%20the%20Average%20of%20%5BPPH%5D%20over%20the%20last%20two%20weeks.%26nbsp%3B%20This%20Query%20works%20just%20fine.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20use%20DLookup%20on%20a%20separate%20Query%20to%20to%20retrieve%20this%20Average%20%5BPPH%5D%20for%20each%20employee%2C%20but%20I%20am%20having%20an%20incredibly%20hard%20time.%26nbsp%3B%20What%20am%20I%20missing%3F%26nbsp%3B%20I%20really%20appreciate%20your%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-355674%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-355962%22%20slang%3D%22en-US%22%3ERe%3A%20DLookup%20Help%20Please%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-355962%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20scottybing%2C%3C%2FP%3E%3CP%3Ewould%20be%20nice%20to%20have%20more%20details%20e.g.%20screenshots%20about%20what%20you%20are%20trying%20to%20do%20with%20your%20queries%20and%20in%20which%20editor%20you%20are%20working%20with%20that.%3C%2FP%3E%3CP%3EI%20suppose%20you%20are%20writing%20an%20Access%20VBA%20code%20whith%20the%20VBA%20editor%20to%20create%20that%20query.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOr%20are%20you%20creating%20that%20sum%20within%20the%20query%20editor%20without%20VBA%3F%20In%20that%20case%20i%20think%20you%20can%20create%20a%20sql%20syntax%20in%20your%20query%20editor%20and%20use%20the%20SUM%20aggretions%20in%20your%20Tab%20%22DRAFT%22%20of%20your%20query.%20Maybe%20you%20dont%20need%20to%20work%20with%20the%20dlookup%20function%2C%20because%20must%20sums%20are%20created%20within%20the%20aggregations%20already%2C%20if%20you%20activate%20it.%20But%20without%20more%20information%20its%20hard%20to%20help%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGreets%2C%20Eva.%3C%2FP%3E%3C%2FLINGO-BODY%3E
scottybing
Occasional Visitor

Hello,

 

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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies