a query on fields that are in another table that is linked to the main

  • Thread starter Thread starter Liat
  • Start date Start date
L

Liat

Hello,

I have 2 tables, one main that is related to the other one
using the ID field. playerID in the main table (suitTable)
equals to the ID of the playerTable.

I give the user the option to choose categories on which
the report is opened. For example, all the suits in a
range of dates. I use the script for that - create a
criteria like "insuranceYear >= fromDate and insuranceYear
<= toDate . The fromDate and toDate exist on the form that
opens the report.

I need to refer to the fields of the playerTable and I
don't know how. If for example, I need all the players
that are bigger then 20. How do I get to that field with
the right ID?


Thank you very much,
Liat
 
hi,
WHERE (((insuranceYear) >= [Forms]![yourform]![fromDate]
and (insuranceYear)<= [Forms]![yourform]![toDate]) AND
(Player > 20))
untested. hope i got all the brackets right.
 
Thanks a lot,
Liat

[email protected] said:
hi,
WHERE (((insuranceYear) >= [Forms]![yourform]![fromDate]
and (insuranceYear)<= [Forms]![yourform]![toDate]) AND
(Player > 20))
untested. hope i got all the brackets right.
-----Original Message-----
Hello,

I have 2 tables, one main that is related to the other one
using the ID field. playerID in the main table (suitTable)
equals to the ID of the playerTable.

I give the user the option to choose categories on which
the report is opened. For example, all the suits in a
range of dates. I use the script for that - create a
criteria like "insuranceYear >= fromDate and insuranceYear
<= toDate . The fromDate and toDate exist on the form that
opens the report.

I need to refer to the fields of the playerTable and I
don't know how. If for example, I need all the players
that are bigger then 20. How do I get to that field with
the right ID?


Thank you very much,
Liat


.
Click to expand...
Click to expand...
 
Back
Top