dlookup

I created an expression based on the response in this post http://www.mrexcel.com/forum/showthread.php?t=243389&highlight=find+previous+records Unfortunately the expression I created in the query gives me #Error This expression is part of a query that has the login and logout times for call...

I have the following DSA = DLookup("[DSA]", "Units", "[Unit]=Forms!Data![Hospital]") DSB = DLookup("[DSB]", "Units", "[Unit]=Forms!Data![Hospital]") DSC = DLookup("[DSC]", "Units", "[Unit]=Forms!Data![Hospital]") DSD = DLookup("[DSD]", "Units", "[Unit]=Forms!Data![Hospital]")...

Hello everyone, This is the 3rd issue I am posting on this forum and have so far been extremely grateful with the quality and speed of responses. Here is my latest issue: I have a table, "Daily_Volume", that has 3 fields "LogDate" (dd/mm/yyyy), Volume (Currency), and RecordCount (Count of year...

I need to read through a file and, using a DLOOKUP, find a specific record for a course taken by a specific employee. There can be multiple records per employee depending on which courses they have taken. (1 record per course) I need to put all of this on one line of a report. Any ideas? I...

Is there a way to use in VBA inside access, some function like Dlookup but to do the search in array within the code Or something like Vlookup of excel (with the TRUE or the FALSE argument) ?

Within a query, I'd like to add a field using the dlookup function. Instead of using static values in the criteria part of the function, I'd like to use a parameter to keep it dynamic. The online example suggests preceding the field value with Form! to tell Access that the field reference...

Hi, I have a specific question and a general question. The specific question is this: I currently have a form with two comboboxes called "Combo Case Code" and "Combo Case Name." I've linked the values to a query that retrieves values for fields called "Case Code" and "Case Name" in a table...