No announcements
Found 320896 threads
-
0 VotesQuery DLookUp
Hi Dean, Are you saying two more tables other than the ones already in the query? If so, which table in the current query is related to them?Answered | 25 Replies | 494 Views | Created by DeanGarber - Wednesday, December 6, 2017 4:34 PM | Last reply by .theDBguy - Thursday, December 7, 2017 8:18 PM
-
4 Votes
Dlookup - Query parameter
I have this code in a textbox in a report: =DLookUp("Remedy","Qryremedy","student = " & [student]) Now, that ...Answered | 10 Replies | 8279 Views | Created by hrubesh - Thursday, July 14, 2011 5:04 PM | Last reply by hrubesh - Tuesday, August 2, 2011 6:24 AM -
0 Votes
Queston About Sub Query using Dlookup
) rather than DLookup, since that lets the database engine try to optimize the query. However, it doesn't sound like the database engine is doing a great job with ...Answered | 6 Replies | 2814 Views | Created by ryguy72 - Thursday, April 19, 2012 5:37 PM | Last reply by Dirk Goldgar - Thursday, April 19, 2012 8:52 PM -
0 Votes
Update Query with Dlookup - Type Conversion Error
Hi, I don't think your DLookup() is retrieving any value. My guess is it is returning Null values, which can't be converted into a Number; hence the ...Proposed | 5 Replies | 1481 Views | Created by Kristoffer Valukis - Thursday, January 4, 2018 6:36 PM | Last reply by Terry Xu - MSFT - Friday, January 5, 2018 5:47 AM -
1 Votes
Saving Data from a Query that uses DLookup
>>I got the bar code part figured out.. Do you know if I can save data from a query using dlookup (to gather data from two separate tables)? DLookup ...Answered | 7 Replies | 513 Views | Created by MIDHUNJ - Monday, January 11, 2016 12:34 AM | Last reply by msdnPublicIdentity - Monday, January 18, 2016 7:26 PM -
0 Votes
Calling a passthrough query via dlookup() executes the stored procedure twice?
dlookup which references the passthrough query and returns the new > identity column value, it executes twice. > > I've worked around itUnanswered | 9 Replies | 5813 Views | Created by rusticloud - Thursday, January 13, 2011 8:02 PM | Last reply by Amko4217 - Monday, April 18, 2011 1:50 PM -
0 Votes
Dlookup (data from query)
Hi Danny Where is the field in which you want to display the result of the DLookup()? Is it in the Subreport? If not, you will not be able to access the data. And you can't ...Unanswered | 5 Replies | 3447 Views | Created by Danny Gan - Saturday, July 23, 2011 4:52 AM | Last reply by Henry Habermacher - Wednesday, July 27, 2011 5:46 AM -
1 Votes
Dlookup, multiple criteria, in SQL query
. I have not used the Lookup Query Wizard. I found that a DLookUp was quicker than the subquery and ...Answered | 4 Replies | 6835 Views | Created by Charles__Toray - Thursday, November 1, 2012 11:03 AM | Last reply by Charles__Toray - Thursday, November 1, 2012 1:55 PM -
0 Votes
Dlookup in Query
just wanted to remove the idea that it was required to remove the literal form reference from the criteria string of DLookup(). Either usage (inside the string or the ...Answered | 22 Replies | 7019 Views | Created by ryguy72 - Wednesday, January 25, 2012 4:01 AM | Last reply by ryguy72 - Friday, January 27, 2012 5:40 PM -
0 Votes
DLookUp Referencing a Query To Get a Total Amount Owed
updatable, however, so you would not be able to edit data in the form. For this you must call the Dlookup function, either in a computed column in the query, or in a ...Answered | 12 Replies | 1599 Views | Created by rdw1260 - Monday, February 2, 2015 4:05 PM | Last reply by rdw1260 - Thursday, March 5, 2015 6:20 PM -
1 Votes
Usning a Query as the domain of DLookUp
Hi Charles__Toray, sure, you can. The query must be without parameters. Parameters can be specified in the dlookup. HTH PaoloAnswered | 2 Replies | 1224 Views | Created by Charles__Toray - Thursday, August 16, 2012 9:02 AM | Last reply by Charles__Toray - Thursday, August 16, 2012 9:43 AM -
2 Votes
DLookup not returning result when source is a query
; What I need to also understand is why it works if I supply the criteria within the query but not if I try pass the criteria via a method such as ...Answered | 12 Replies | 3631 Views | Created by Hugh Self Taught - Friday, July 22, 2011 8:27 PM | Last reply by Hugh Self Taught - Thursday, July 28, 2011 9:36 PM -
0 Votes
Expression for subtracting debit and adding credit from a balance in another record
description, you could use DLookup() expressions to obtain values from a field in the previous or next record of a form, a report, or a query. In a ...Answered | 2 Replies | 323 Views | Created by M mate - Tuesday, July 26, 2016 1:33 PM | Last reply by David_JunFeng - Wednesday, July 27, 2016 6:20 AM -
0 Votes
lookup value in query
I have two table one is named Staff and other named Items. I created query named queryStaff which link both of them using relationship. I intended to DLookUp specific field in ...Answered | 1 Replies | 752 Views | Created by srjmuhd - Friday, June 12, 2015 1:41 PM | Last reply by Mike Laughlin - Monday, June 15, 2015 2:41 PM -
0 Votes
Extract Data from query with condition.
query:- When i want to put another condition it seems to working =DLookUp("[TotalLeaveTaken]","qryTotalLeaveTaken","[EmployeeID]= " ...Answered | 2 Replies | 2732 Views | Created by Danny Gan - Wednesday, July 13, 2011 8:33 AM | Last reply by Danny Gan - Wednesday, July 13, 2011 9:37 AM -
0 Votes
LINQ equivalent to DLookup in Access
retrieve a value from a table that is not part of the query used with the client screen? Essentially perform the same thing as am MS Access DLookup? Thanks in ...Answered | 1 Replies | 1691 Views | Created by engelhk - Thursday, December 26, 2013 2:33 PM | Last reply by engelhk - Thursday, December 26, 2013 3:38 PM -
0 Votes
trying to use Dlookup to get last record value
i am trying to assign the value from a combo box in a form as a variable using dlookup..... it works fine for the first record but am unable to get it to look at the last. i have tried to ...Answered | 2 Replies | 3327 Views | Created by Greg Levet - Thursday, November 19, 2009 12:13 AM | Last reply by Greg Levet - Sunday, November 22, 2009 10:02 PM -
0 Votes
Dlookup function not working
If the value order comes from a control on a form, try: item_no=DLookup("item_no", "dbo_sfordfil_sql Query", "ord_no= ...Unanswered | 10 Replies | 2874 Views | Created by ronald c - Wednesday, February 29, 2012 10:09 PM | Last reply by Vanderghast - Thursday, March 1, 2012 9:57 PM -
0 Votes
DLookup with VB.NET?
DLookup is specific to Microsoft Access and VBA and there currently is no language-integrated query functionality equivalent in .NET. You wouldAnswered | 3 Replies | 8298 Views | Created by rcameron - Friday, March 2, 2007 10:49 PM | Last reply by Cammyr - Sunday, March 4, 2007 8:02 PM -
0 Votes
DLookup not working -- have spent hours trying to figure this out - HELP!
The double-quotes are wrong and probably a missing equality comparison operator in the 3rd argument. It should be something like: =DLookUp("Answered | 3 Replies | 450 Views | Created by Stev Scott42 - Wednesday, September 3, 2014 11:27 PM | Last reply by Van Dinh - Thursday, September 4, 2014 10:55 AM - Items 1 to 20 of 320896 Next ›
No announcements
