Count of records

[Aston]

How can I make the count of the records of one table to be equal to the product of the count of records from other two tables.

[ConneXionLost]

Can't imagine any good reason for doing this, but:

Build a query that includes both of your "other" tables. Show fields from both tables in the query. Ensure there is NO join between the two tables. Run the query. Copy/Append the results to your "one" table.

Cheers,

[Aston]

thank u connexionlost. I solved my problem and I'm sorry for my bad english