newbie: Why do I get strange results?

  • Thread starter Thread starter joe serrano
  • Start date Start date
J

joe serrano

I have made a table wth students, courses and attendance.

Tbl_Students
-------------------------
StudentID, courseID, etc.

Tbl_Attend
-------------------------
AttendID, IDDay, IDDate, IDHour, IDSubject

Tbl_Day
-------------------------
IDDay, Day, etc

with three tables, one or Day, Hour and Subject.

However, when I make a form to control attendance, it adds 1 before all the
results I enter. For example in Day I ave 1 - 5 for Monday to Friday, Hour
1 - 9 for 1st to 9th and numerous subjects 1 to 20 for each subject.

When Ienter the day hour and subject in the form, I get 1 before the
number, for example too; I enter 1, 2, 1 as day 1, hour 1 and subject 1. In
the table I get 11, 12, 11

Any ideas?

Thanks in advance

joe
 
Joe,
Check the format of the table fields, or the form or query
fields. It looks like you have a format specified
somewhere that says "10", which indicates that you want
a "1" in front, and the "0" indicates any other digit, but
is required. Thus, it formats it as a two-digit number,
the first of which is "1."
By the way, don't you have the StudentID field in the
Attendance table? Or is that AttendID the same? Need to
have a related field.
Bernie
 
Back
Top