Select the rows with the same ID's in the current week

[Sakis_Koukouvis]

Hi,
I have a table JOBS. It has kind of jobs.
Employees use this table to create rows in another table PROGRAM

The table JOB:
ID
POSITION OF EMPLOYEE (like gardener, officer etc.)
FREQUENCY (it has the enum list DAILY, WEEKLY, TWICE A WEEK, MONTHLY)

The table PROGRAM:
ID
DATE
JOB (connecting with the ID's of table JOB)
POSITION OF EMPLOYEE (copy from the table JOB)
FREQUENCY (copy from the table JOB)
TIME
PLACE

I want to select only the rows from the table JOB that have two rows (at least) with the frequency twice a week, in the current week in the table PROGRAM
I have a formula:
SELECT(PROGRAM[JOB], AND([JOB]=[JOB].[ID], [FREQUENCY]="TWICE A WEEK", WEEKNUM(TODAY())=WEEKNUM([DATE])))
But with this formula I have all the rows with frequency "twice a week" in current week but I can't see the rows that are double in the same week
How I could filter the rows having the jobs that thew have done twice a week in the current week?
Thank you
Sakis