Query criterium does not work

64 64KB

Hi,

I have a form on which i have a combobox called "cmb_prodjr"

The combobox looks up the values in a table called "tbl_trajecten" in the field called [prodjr]
In the field [prodjr] a year is stored or nothing (so it lists 2012, 2013, 214, 2015 or it is empty)

I have a Query called "Q_trajecten" based on the table "tbl_trajecten"
In the Query i have the field called [prodjr]

In the criterium of the field [prodjr] i have

Expand|Select|Wrap|Line Numbers

Like [Forms]![frm_trajecten]![cmb_prodjr]

When i run the query it only shows the records if the field [prodjr] is filled with a date.

When i leave the [cmb_prodj] empty it will not list any records.

When i leave the combobox [cmb_prodj] empty, i would like to have the query list all records (so not only the ones that have the field [prodjr] empty but all records.

Can you please help me ?
thanks,
Pierre

Apr 16 '13 #1

Subscribe Post Reply

922

Seth Schrock

2,965

Expert 2GB

I actually just wrote an article about that. Getting the results for all values in a combo box. If you have any trouble, just post back here and we can help you out.

Apr 16 '13 #2

by: hemal | last post by:

I came across a very strange situation at work. There is an order of magnitude difference in execution time for the following two queries (10 v/s ~130 msec): select count(*) from table_name...

Oracle Database

Any Ideas why the 2nd and 3rd Query do not work?

by: Nick Truscott | last post by:

<? // scoreinput.php - input a match score when match selected from list ?> <html> <head> <basefont face="Verdana"> </head> <body>

MySQL Database

HELP PLEASE: SQL Query Analyzer does not start

by: kackson | last post by:

Hi. I've been using SQL server 2000's query analyzer and the enterprise manager without problems for quite some time (2 months). And all of a sudden one week ago, when I started the query analyzer...

Microsoft SQL Server

Need help with query that does both timediff & sum

by: Dan | last post by:

Hello, Am trying to construct a query that'll both compute elapsed time based on certain criteria and sum this up for a subset of records. Sample Data that I'm working with: Row Ev_Time ...

Microsoft SQL Server

SQL Delete query won't work from query window but does from code...

by: Matthew Wells | last post by:

I want to delete records from the "one" table of a one to may relationship. There are no actual Access relationships set up. The "one" table has a single field PK and the "many" table has a two...

Microsoft Access / VBA

Update query doesn't work

by: Nicolae Fieraru | last post by:

Hi All, I was trying to update a field in a table, based on the results from a query. The table to be updated is tblCustomers and the query is qrySelect. This query has two parameters, provided...

Microsoft Access / VBA

Simple Access 2000 Query won't work in XP

by: j.mandala | last post by:

I created a simple link between two tables in a query. TableA has Social Security numbers stored as Long Integer Data. (I imported this table). The Join is between these two fields Table ...

Microsoft Access / VBA

NEED URGENT HELP: Sum Value in Query Doesn't Work

by: JHNielson | last post by:

I AM AT THE WIRE AND DESPERATELY NEED SOME HELP! I have a query that checks that when the user submits data to me, it checks that their total is correct. The SQL looks like this: UPDATE...

Microsoft Access / VBA

Unmatched query wizard does not display field lists

by: Sharon V | last post by:

This is driving me crazy - my unmatched query wizard will not display field names for any tables I choose. All my other query wizards work properly. I am running Access 2003. I have tried using...

Microsoft Access / VBA

exe a query that does not inc the specified expresion as part of an aggregate functio

by: blackrobin | last post by:

I'm stress out here, I know its simple but I cant seem to get to work. I hope any body would help me. I have two query: QProgress_FM Fullname School_ID Visit Date Cluster Number School...

Microsoft Access / VBA

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Similar topics