automatic data set creation

[georg7]

Hi there,
I've 3 tables (tbl_all, tbl_students, and tbl_tests)
I want a database to check if the students have done their Tests.
The amount in tbl_students shows how often the students have to do their Tests per year.
So my Goal is to create a form where I can select the Student and the test and it's automatic creates as many data sets as the amount is. Like amount(year) it'll create 1 data set. If it's quarter it'll create 4 data sets and if it's Monthly it'll create 12.
The Date should be year(01/01/2019), Quarter(01/01/2019,01/03/2019,01/06/2019,....) and Monthly (01/01/2019,01/02/2019,....).

Is this possible ?

best regards
Georg

 

[Ranman256]

Make an append query to add the recs to ALL.
In the query ,bring in Students,and Tests and their dates.
Do not join the tables.
Run append.

 

[isladogs]

Why do you have 5 records for student 1 in the same year when they should be quarterly?

 

[arnelgp]

sample of what your intent.

 

[theDBguy]

Hi. Just in case it might help, take a look at this blog article on Cartesian Product. Cheers!

 

[georg7]

Thank you all guys!