访问考勤表帮助;需要每天更新表格，无需复制表格两次 [英] Access Attendance table help; Need to update table daily w/o copying table twice

问题描述

请帮助，


我有一个数据库，我每天都在跟踪出勤率，但是当人们进入时，我可能需要在当天多次更新表格出勤后的服务已被捕获。我当前的设置不起作用。我在下面详述了它。请帮助我理解如何在不重新附加整个表格的情况下更新表格。

Please help,

I have a database whereby i am tracking attendance on a daily basis, however i may need to update the table more than once in the day as people enter the service later after attendance have already been captured. my current setup does not work. i have detailed it below. Please help me to understand how I can update the table without re-appending the entire table again.

展开 | 选择 < span class =codeDivider> | Wrap | 行号

推荐答案

brikusi，


感谢您的澄清。


首先，在tblPERSON中，不需要TempAttendance字段。由于这是仅指示某人是否参加特定会话的值，因此这并不适用于所有人。所以，它不应该在这个表中。


其次，在tblPERSON中，字段评论mya对我来说有点混乱。当我想到TblPERSON中的字段评论时，我将其视为关于该人的评论，仅适用于该人 - 但总是适用于该人。但是，您正在将该值复制到tblATTENDANCE。我将此视为两件事之一：1）您正在将关于此人的一般注释（始终适用于他们）复制到此表，然后是冗余数据 - 因此您不应传输此数据，因为它已经存在;或者2）您正在添加关于该人在特定日期的特定出席情况的评论。在这种情况下，您不会使用tblPERSON.Comments，而只是使用tblATTENDANCE的Comments字段，在出席时添加注释。


因此，这两个问题必须先解决你继续。


关于跟踪出勤率，而不是以你建立的方式使用追加查询，我会使用带有文本框的表格来选择出勤日期和两个子表格。第一个子表格列出了可以参加的人;第二个子表单列出了那些被标记为参加特定日期的人。在文本框中选择日期时，会发生两件事。您将创建一个SQL字符串，用于第一个子表单的记录源。它将是一个使用所选日期的查询，根据该出勤日期加入tblPERSON和tblATTENDANCE，它只会显示那些没有参加该日期的人。它还将根据出勤日期过滤第二个子表单。


当然，这既不是更具描述性，也不包括完成此任务的代码。我们会慢慢采取这些步骤，因为在我们为您的需求创造一些东西之前，我宁愿您理解我所推荐的内容。


随着我们前进，随时提供更多详细信息。


希望这个hepps！

brikusi,

Thanks for the clarification on this.

First, in tblPERSON, there is no need to have a TempAttendance field. Since this is a value that only indicates whether a person attended a particular session, this does not apply to every person at all times. So, it should not be in this table.

Second, also in tblPERSON, the field Comments mya be a bit confusing to me. When I think of the field Comments being in tblPERSON, I view it as comments about that person, that apply to that person alone--but that always apply to that person. However, you are copying that value to tblATTENDANCE. I see this as one of two things: 1) you are copying the general comments about the person (that applies to them at all times) to this table, which then is redundant data--so you shouldn''t transfer this data, because it already exists; or 2) you are adding comments about the person concerning their particular attendance on a particular day. In this case, you would not use tblPERSON.Comments, but would simply use the Comments field of tblATTENDANCE, adding the comment when taking attendance.

So, these two issues must be resolved before you continue.

Concerning tracking attendance, rather than using an append query in the manner you have it built, I would use a Form with a text box to select the attendance date and two subforms. The first sub-form lists people who can attend; the second sub-form lists those who are marked as attending for a particular day. When you select a date in the text box, two things happen. You create a SQL string that you will use for your record source for the first sub-form. It will be a query that uses the selected date, JOINing tblPERSON with tblATTENDANCE based upon that attendance date, and it will only show people who have not attended on that date. It will also filter the second sub-form based upon the attendance date.

Of course this is neither more descriptive, nor does it include code to accomplish this. We''ll take these steps slowly, because I would rather you understood what I am recommending before we create something incrrectly for your needs.

Standing by to provide more details as we move along.

Hope this hepps!

感谢您的评论，是的，tblPerson中的评论仅涉及当天的临时记录。 />

所以基于你的回复，我应该从tblPerson中删除评论和TempAttendance，只使用tblAttendance中的字段。


我不想要由于我不知道谁会迟到或根本不参加，所以将人们分开。该数据库适用于教堂。所以人们来来往往服务。因此，我需要能够在一天中定期更新表格。

Thanks for the comments, yes the comments in tblPerson relate only to the tempattendance record for that day.

So based on your reply i should remove Comments and TempAttendance from the tblPerson and only use the fields in tblAttendance.

I don''t want to separate the people as I am not aware of who will attend late or not at all. This database is for a church. so people come and go throughout the service. Therefore I need to be able to update the table periodically throughout the day.

brikusi：

因此，基于您的回复，我应该从tblPerson中删除Comments和TempAttendance，并且只使用tblAttendance中的字段。

brikusi:
So based on your reply i should remove Comments and TempAttendance from the tblPerson and only use the fields in tblAttendance.

评论可以转移到tblATTENDANCE。 TempAttendance是不必要的。

Comments can move to tblATTENDANCE. TempAttendance is unnecessary.

brikusi：

我不想分开人们，因为我不知道谁会迟到或根本不参加。该数据库适用于教堂。所以人们来来往往服务。因此，我需要能够在一天中定期更新表格。

brikusi:
I don''t want to separate the people as I am not aware of who will attend late or not at all. This database is for a church. so people come and go throughout the service. Therefore I need to be able to update the table periodically throughout the day.

我想我们在同一页上 - 我想你只是不确定它是如何工作的。


你不会分离人。但是，想象一下：你打开你的表格。它默认为今天的日期（因为这很可能是您将参加的日期） - 但如果您愿意，可以选择另一个日期。


当表格时是打开的，因为它默认为今天，表单的顶部有一个子表单。它列出了当天未被列为出席教会的所有人（当您在任何一天第一次打开表格时，每个人都将被列为不参加）。每个名称旁边都有一个小按钮Attend。


表单底部是一份列表，其中列出了当前列为参加所选日期的每个人服务。再次，当您第一次打开它时，将没有列出任何人。它将列出此人和评论。


当您点击参加时按钮，该人将被添加到底部列表并从顶部列表中删除。只要点击名称，它们就会被添加。


这听起来像你愿意尝试的解决方案吗？

I think we are on the same page--I think you are just unsure of how this will work.

You will not be "separating people". However, envision this: You open your form. It defaults to today''s date (because that is most likely the date that you will be taking attendance)--but you can select another date if you wish.

When the form is opened, because it has defaulted to today, the top of the form has a subform. It lists all people who are not currently listed as attending church that day (when you open the form for the first time on any given day, everyone will be listed as not attending). Next to each name, there is a small button "Attend".

At the bottom of the form is a list of everyone who is currently listed as attending the selected day''s service. Again, when you first open it, there will be no one listed. It will list the person and comments.

When you click the "Attend" button, the person will be added to the bottom list and removed from the top list. As quickly as you can click through the names, they will be added.

Does this sound like a solution that you are willing to try?

这篇关于访问考勤表帮助;需要每天更新表格，无需复制表格两次的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！