Hi guys, I have a query in which i want to use a dlookup which i have embedded in a function. Strange thing is that the first record returns the correct...

Here is the SQL from the Query Builder in Access. It seems to run OK, it just does not update the Location field in my Import_From_RPM table. UPDATE...

Hi all, I'm running a query which generates a report for me on vehicles. Within the report I have a field which consists of an account code called What I...

In Table1, I store an inflation rate value with the following properties: - data type = number - fieldsize = double - format = percent - decimal places =...

Hello all: I'm trying to do something a little funky here and I'm not sure if I'm approaching it the right way. I'm running an update query that will contain...

For some reason I have the hardest time with DLookup syntax. Please help! I'm trying to lookup a contact name in tblMembership where MEMBER_ID...

Hi All, My Problem seems pretty simple but i just dont seem to be able to get my head round it. I am trying to use Dlookup in a query criteria to find a...

I have the following dlookup on my main form(frmProject), looking up values based of a combox(combo883) in a continuous subform(frm_Project_detail_subform)....

I am currently generating a set of records from a table using a query. These are grouped by equipment number in a report (example below)… Equipment:...

I have an access 2000 app that I am creating a subform. This subform has data from two tables: BidHistory -------------- Bid OrderID Orders -----------

I need to do a Dlookup and have looked at all the examples and can't seem to get mine to work on a form. Form Name: CC2 Eval Info Form Table to do Lookup:...

Hi all, Probably one of the many having fun with Dlookup! Wonder if anyone can help. Trying to produce some data on whether certain members of staff have...

Hi all, I have a dlookup() problem (who hasn’t?) in a query. The query has (amongst others) the following fields : DateOfPurchase Discount Item Price

I'm trying to create a query that shows many loans and lots of information about the loans. This query should be fed from a master loan table that shows the...

Hello All I have the following query which won't work: SELECT ., DLookUp("!","","!=") AS Expr1 FROM ; I have tried it with and without the quotes, and with...

Does DLookup work in an expression in a query? I have this expression -(DLookUp("","tblmaintabs","= ")) Which works fine as a calculated control on a form but...

I have a query that I am using the Dlookup function to find values from another table. The criteria of the Dlookup is based on a field in the external table...

I work for a Hotel corporate office. I am trying to create a database to store and track any customer complaints and the resolution. Everything is going...

Howdy - I have the following in a query field: Expr1: DLookUp("","tblPlans"," = !") plAge65Units & plName come from the table tblPlans cePlan is located in...

Hi, The field SL03004 is type "date/time" and SL03002 is type "text", both located in table SL03L000 Faktnr1 is the name of the combobox (that in itself is...