使用日期范围生成报告 [英] Using Date Range to generate reports
问题描述
你好再次
我差不多完成了我的数据库。我决定使用日期或日期范围生成报告，我无法让它工作。首先我在查询中使用了参数，但它不是非常用户友好，所以我决定制作自己的日期条目表单。
主要问题是表格中的实际日期。当我尝试生成报告时，报告会显示所有记录，无论我输入的是哪个日期。我尝试了各种各样但我没有理清这一部分。有人知道如何解决这个问题吗？
hello again
i have almost finished with my database. i have decided to generate the reports by using a date or date range and i can''t get it to work. first i used parameters in a query but its not very user friendly so i decided to make my own date entry form.
the main problem is the actual date in the table. when i try to generate a report the report shows all the records, regardless of which date i input. I''ve tried all sorts but i''m failing to sort out this part. anyone have an idea of how this can be fixed?
推荐答案
如何提供所有相关信息的更多细节。
How about providing some more details with all relevant information.
正如该男子所说，您可以提供更详细的信息。访问是一门技术主题，一般描述很少有用。具体要求。
同时，请查看文字DateTimes及其分隔符（＃），以获取有关如何以文字形式指定日期的帮助。
As the man says, you could provide some more detailed information. Access is a technical subject and general descriptions rarely help much. Specifics are required.
In the mean-time, check out Literal DateTimes and Their Delimiters (#) for help on how you should specify dates in literal form.
抱歉。这里是信息。
我有一个名为tblMain的表和一个通过DAO连接到表的表单。表单用于添加记录，这些记录保存到tblMain。在每个月之后，用户需要从特定日期生成报告。问题是，当用户尝试添加记录时，日期显示当前日期，这很好，但如果他们第二天访问相同的记录，它将具有该日期日期，而不是添加记录的日期。从而扼杀了生成在特定日期添加的报告的整个目的。我有用户的日期范围输入的代码，我认为没关系，但我不能确定，直到我真正能够获得工作日期。
这里'的代码是日期范围输入
sorry about that. here''s the info.
i have a table called tblMain and a form that is connected to the table through DAO. the form is for adding records and these records are saved to tblMain. after each month the users need to generate a report but from a certain date. the problem is that when a user tries to add a record the date displays the current date, which is fine, but if they access the same record the next day, it will have that days date, instead of the date when the record was added. thus defeating the whole purpose of the of generating reports that were added on a specific date. i have code for the date range input for the users and i think its okay, but i can''t know for sure until i can actually get working dates.
here''s the code for the date range input
这篇关于使用日期范围生成报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
