表格和日期问题 [英] Form and dates problem

问题描述

我们有一个Access病态跟踪器。表格FrmDetails& sick显示了一个包含疾病缺席日期的子表格。

日期没有按时间顺序显示。我无法理解为什么。

任何帮助都会受到极大的重视。

Lindie

附加文件

（39.4 KB，33次观看次数）

嘿Lindie，


由于您通过将表单基于表而不是查询来使自己的事情变得非常困难，因此您可以将自己限制为可以排序的内容并限制返回的记录。这就是有时候你希望将表单基于我已经完成的查询或SELECT语句的原因。

我会再次附加你的数据库，并查看记录源的子表单，你会看到我做了什么。进入查询设计师模式，你可以看到它的样子吗？


希望有所帮助，


Joe P.

附加文件

< table cellpadding =0cellspacing =3border =0> sickness-www nov08.zip （46.6 KB，30 views）

We have an Access sickness tracker. The form FrmDetails&sick shows a subform with the dates of the sickness absences.
The dates are not showing in chronological order. I just cannot work out why.
Any help would be greatly valued.
Lindie

Attached Files

sickness-www nov08.zip (34.3 KB, 27 views)

解决方案

As Dorothy Parker said about the city of Seattle, "There''s no there there!"

The zip file you posted is empty! Try again!

Welcome to Bytes!

Linq ;0)>

OOps- Hope it works this time.
thanks
L

Attached Files

sickness.zip (39.4 KB, 33 views)

Hey Lindie,

Since you''re making things really difficult for yourself by basing your forms on a table instead of a query, you limit yourself to what you can sort and limit the records returned. This is the reason sometimes you want to base your form on a query or a SELECT Statement like I''ve done.

I''ll attach your database again, and look in the subform for the recordsource, and you''ll see what I did. Just go into the query designer mode, and you can see what it looks like?

Hope that helps,

Joe P.

Attached Files

sickness-www nov08.zip (46.6 KB, 30 views)

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