如何编写单个查询以选择从组合框文本中选择数据的数据 [英] how to write single query to select datas selecting it from combobox text

问题描述

你好，我要在水晶报表中显示数据字段值
我有一个组合框来选择月份，并且我想在水晶报表中显示月份的相应值.我有一个查询来只选择月份，因为它只有同一年，我该怎么做?请提供验证码

关于bishnu karki

hello frens, i want to show the datafield values in crystal report
i have a combobox to select the month and i want to show the corresponding values of the month in the crystal report i have a query to select only the month beccause its of the same year only the how can i do that? please reply with the code

with regards bishnu karki

推荐答案

您可以执行以下操作:-

You could do something like this:-

SELECT field1, field2 FROM myTable WHERE datefield BETWEEN @startDate AND @endDate;

其中startDate是该月的第一天，而endDate是该月的最后一天.

希望对您有帮助

where startDate would be the first of the month and endDate would be the last day of the month.

Hope this helps

这篇关于如何编写单个查询以选择从组合框文本中选择数据的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！