Please Help!

[cobra234111]

I have a bunch of baseball stats in a database. I want to use 2-3
different tables in a report and create forumlas with that data. Is
that possilble to do.
BTW-Do I need to make ID numbers or can I keep the players name

 

[John W. Vinson]

I have a bunch of baseball stats in a database. I want to use 2-3
different tables in a report and create forumlas with that data. Is
that possilble to do.

Yes. You need to create a Query joining the tables. You can type an expression
in a vacant Field cell in the query grid and have it appear on the report, or
you can set the Control Source property of a textbox on the report to an
expression (preceded by an = sign). You can also put criteria on the query to
print the report for a desired subset of the data - use parameter queries such
as

[Enter start date:]

or, even better, create a little unbound form with textboxes or combo boxes
for the criteria, and use

[Forms]![NameOfForm]![NameOfControl]

in the criteria.

BTW-Do I need to make ID numbers or can I keep the players name

If the player-name field is in the query (as it should be), you can certainly
print it on the report.

If you're having difficulties please post some information about the structure
of your tables.

John W. Vinson [MVP]

 

[cobra234111]

I have a bunch of baseball stats in a database. I want to use 2-3
different tables in a report and create forumlas with that data. Is
that possilble to do.

Yes. You need to create a Query joining the tables. You can type an expression
in a vacant Field cell in the query grid and have it appear on the report, or
you can set the Control Source property of a textbox on the report to an
expression (preceded by an = sign). You can also put criteria on the query to
print the report for a desired subset of the data - use parameter queries such
as

[Enter start date:]

or, even better, create a little unbound form with textboxes or combo boxes
for the criteria, and use

[Forms]![NameOfForm]![NameOfControl]

in the criteria.

BTW-Do I need to make ID numbers or can I keep the players name

If the player-name field is in the query (as it should be), you can certainly
print it on the report.

If you're having difficulties please post some information about the structure
of your tables.

John W. Vinson [MVP]

John
Thanks for the respond but I do have some more questions on Querys
What info do you need?

 

[John W. Vinson]

John
Thanks for the respond but I do have some more questions on Querys
What info do you need?

The names of your Tables; their relevant fields' names and datatypes; their
Primary Keys (and if they don't have primary keys you've got some more work to
do); relationships; and a brief description of what you want the query to
accomplish.

John W. Vinson [MVP]