Solved

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

Posted on 2009-07-10
4
250 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
ID: 24829268
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
ID: 24829308
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
ID: 24829320
Yes.
0
 

Author Closing Comment

by:SuperSnooper
ID: 31602361
IT Works!
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Insert parts by customer 12 43
sql help 2 46
Have a conversion issue with varchar to int in a SQL: Query. 1 40
awk and Pythagoras? 5 20
Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
Viewers will learn the different options available in the Backstage view in Excel 2013.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

820 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