Solved

select "all" in a query

Posted on 2004-08-01
1
270 Views
Last Modified: 2010-04-17
i am would like to run a query that would select  "all" outstanding  reports from various divisions where i would still have the option of selecting the reports by division below is the code
SELECT DISTINCT DailyReport.divisioin
FROM DailyReport
WHERE (((DailyReport. divisioin)=[Forms]![Search Form]![comboboxsubdivision]));
 thank you
0
Comment
Question by:wwstudioinc
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 3

Accepted Solution

by:
ehartfield2002 earned 125 total points
ID: 11689389
If I understand you correctly,  using one query you'd like to be able to select all reports or optionally only those reports from a selected division.  Here's the code:

SELECT DISTINCT DailyReport.divisioin
FROM DailyReport
WHERE (((DailyReport. divisioin) Like [Forms]![Search Form]![comboboxsubdivision] & *));

If comboboxsubdivision = "" then, the query selects all records.  Otherwise, it only selects one division's records.
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

Displaying an arrayList in a listView using the default adapter is rarely the best solution. To get full control of your display data, and to be able to refresh it after editing, requires the use of a custom adapter.
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
Introduction to Processes

615 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