Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Dlookup statement  - how to return multiple values

Posted on 2006-04-23
Medium Priority
Last Modified: 2008-02-01

Is there anything available simmillar to a dlookup function that will return all the values not just one ?
Question by:andyw27
  • 2
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 16519979
not really.
what are you trying to do, so we might be able to suggest an alternative

Author Comment

ID: 16520010

I have a dcount statement which retruns how many rows meets the criteria, so at the moment that says '5' on my report.

Underneath it I would like to expand upon it so you have the values of each rows lists for example:


The dlookup allowed me to use pretty much the same syntax and the same criteria except it returned the first record, i.e. row2.

LVL 143

Accepted Solution

Guy Hengel [angelIII / a3] earned 1000 total points
ID: 16520029
>Underneath it I would like to expand upon it so you have the values of each rows lists for example:
this looks like you need a subform?!
LVL 54

Assisted Solution

nico5038 earned 1000 total points
ID: 16520054
You would need a query with the "WHERE" part of the Dcount() function to get the rows that are counted.
Best to show the results in a datasheet subform.


Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

578 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