how to create a ledger to add points instead of money

M

Margie

I am trying to create a table to keep track of points earned by date and then
add them to a form. Like creating a ledger but instead of money keet track of
the points. I have the tables and form for the database but I can't figure
out how to create the table and link it to the form for these points. Can
anybody help me?
 
B

Brendan Reynolds

I'm not quite sure what the question is here, because you say you 'have the
tables' and then you say that you 'can't figure out how to create the
table'. This seems to be a contradiction? If you can't figure out how to
create the table, then in what sense do you 'have the tables'?

To link (or 'bind', to use the customary terminology) a table to a form, set
the RecordSource property of the form to the name of the table, or to the
name of a query based on the table, or a SQL statement that selects from the
table. Then set the ControlSource property of each control (textbox,
combobox, etc) on the form to the name of the relevant column in the table,
query or SQL statement. You'll find the RowSource property on the 'Data' tab
in the Properties window in form design view when the form itself is
selected (choose 'Select Form' from the Edit menu) and the ControlSource
property also on the 'Data' tab when you select an individual control (just
click on the control).

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
M

Margie

Hello Joseph, let me try to expalin it again. I am puting together a database
for my work. We need to keep track of of a new program for juveniles place in
the program by court. The database will help us keep track of, who is the
juvenile, where he/she lives, which court put him/her in the program, who is
his/her Probation Officer among many other things. Every weekend the
juvenile will earn max of 14 points, 7 for saturday and 7 for sunday. I have
done everything but I am having problems figuring out how to keep track of
those points earn by date which can be from 4 weekends up to 20. In sum
accumulating the points by date and showing them on the form. do this help?
 
Top