查询问题 [英] Query Question

问题描述

我有一个带有下拉菜单的表单，用于查询姓名，月份和年份

以便在一个月内相应地捕获个人的活动和

给定年份。但是我想也能够查询所有个人的

给定的月份和年份或者个人的全年

示例。


我的问题是，有没有办法让空白（未填写）字段

a查询输入在空白时被忽略？我目前正在成功地完成我在上面描述的内容，但是它带给我3

查询（为了简单起见，我在同一张纸上）当

时，它会看起来更整洁，只有一个查询并留下任何下降

下来菜单项，我不想包括在查询，空白和

被忽略。有任何想法吗？ TIA

I have a form with drop down menus to query for name, month, and year
to capture activity accordingly by an individual for a given month and
given year. But I''d like to also be able to query ALL individiduals
for a given month and year OR an individual for the whole year for
example.

My question, is there any way to have blank (not filled in) fields of
a query input ignored when left blank? I''m currently doing very
successfully what I described in the para above but it''s taking me 3
queries (which I have on the same sheet for simplicity) to do it when
it would look a lot neater to have a single query and leave any drop
down menu items that I don''t want to include on the query, blank and
ignored. Any ideas? TIA

推荐答案

所以你的下拉菜单中有一个''all''选项？

这三个是什么现有的查询看起来像？

so do you have an ''all'' option in your drop down ?
what do the three existing queries look like ?

Hello Cover，

Hello Cover,

query =" select * from table where 1 = 1" ;;

if（

query = "select * from table where 1 = 1 ";
if(

这篇关于查询问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！