Solved

Use a Variable "Criteria " in an Access 2003 db Query

Posted on 2009-07-10
4
223 Views
Last Modified: 2012-05-07
I need to use DLookUp to determing the value for a Query " Ctiteria".  I don't have the slightest idea how to do this.
0
Comment
Question by:SuperSnooper
  • 2
  • 2
4 Comments
 
LVL 77

Expert Comment

by:peter57r
Comment Utility
You will have to be more specific about your requirements.
There is no problem in principle about using a dlookup in a criteria cell, although it is fairly unusual thing to do.

0
 

Author Comment

by:SuperSnooper
Comment Utility
Peter,

I have a query with a variable criteria as the liniter for the results.  I want to use the value from a DLookup field to as the value for the criteria.  Do just put the DLookUp statement in the "Criteria" fo the query fields?
0
 
LVL 77

Accepted Solution

by:
peter57r earned 125 total points
Comment Utility
Yes.
0
 

Author Closing Comment

by:SuperSnooper
Comment Utility
IT Works!
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now