30 Day Expiration Query

[dynamix]

Hey guys, before the creation of my beautiful Gym registration database, I just need help with a coule things..

The low-down: To summarize.. I'm developing a Gym registration system for a school project (a big mark earning one). There are four tables and three forms.

How it works: In my frmSubscriptions form, users enter a subscription 'Start_Date' and then an 'Exp_Date' is calculated for exactly one year after whatever the 'Start_Date' is set to. Following ?

So basically, I have lot's of members and I want to be able to write an SQL statement that will scour the database and find ALL accounts that are expiring in one months time.

Is this possible? If you want screenshots or anything, please let me know.

Thanks ever so much for even bothering to read through this . Much appreciated.

 

[KenHigg]

Yes, what you are wanting to do is fairly simple. But, if you really want to have your db critiqued, post the table structure.

kh

 

[dynamix]

What do you mean by the structure? The relationships?

 

[KenHigg]

Yeah. Just list out the tables and their fld names, indicating what the primary and foreign keys are...

Ken

 

[dynamix]

Okay .

Tables:

tblMembers
tblSubscriptions
tblPlans
tblPayments

Forms:

frmMembers
frmSubscriptions
frmPayments

My relationships are as follows (my teacher said, conceptually, something is wrong with my relationships in relation to what I am trying to achieve through my database but I can't figure out what.. So maybe if you can spot something, please point it out ).

 

[dynamix]

Sorry for the double post/bump But I’m just wondering if anyone more knowledgeable than I has the answer??