automatic data set creation (1 Viewer)

georg7 · Oct 8, 2019

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 · Oct 8, 2019

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 · Oct 8, 2019

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

arnelgp · Oct 8, 2019

sample of what your intent.

theDBguy · Oct 8, 2019

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

Pat Hartman · Oct 8, 2019

Creating empty records ahead of time isn't likely to be the correct solution. What happens if the frequency of a test changes? Do you delete the unused test records and add new ones or do you just leave the now invalid data hanging out there?

Do the students update this database themselves? If not, how do the tests get logged?

What process in the app looks for missed values?

There are methods to do all of this without pre-inserting records that may never be used.

georg7 · Oct 9, 2019

Thank you all guys!

automatic data set creation (1 Viewer)

georg7

Registered User.

Attachments

Ranman256

Well-known member

isladogs

MVP / VIP

arnelgp

..forever waiting... waiting for jellybean!

Attachments

theDBguy

I’m here to help

Pat Hartman

Super Moderator

georg7

Registered User.

Similar threads

Users who are viewing this thread