108 reputation
6
bio website
location New York, NY
age 31
visits member for 1 year, 6 months
seen Jun 25 at 16:47

Jun
30
awarded  Tumbleweed
Jun
23
asked Converting MS Access queries with parameters to an ADP (client for SQL Server)
Jun
23
revised Handling expiration in a course registration or ticketing system
Updated to better reflect what I actually ended up using in my application
Jul
7
revised Handling expiration in a course registration or ticketing system
edited body
Apr
4
awarded  Student
Apr
4
awarded  Custodian
Apr
4
reviewed Approve suggested edit on Handling expiration in a course registration or ticketing system
Apr
4
revised Handling expiration in a course registration or ticketing system
deleted 3 characters in body
Apr
4
comment Handling expiration in a course registration or ticketing system
See below for my answer on how I decided to design this.
Apr
3
awarded  Scholar
Apr
3
comment Handling expiration in a course registration or ticketing system
Thanks again, I appreciate it!
Apr
3
accepted Handling expiration in a course registration or ticketing system
Apr
3
comment Handling expiration in a course registration or ticketing system
Could you take a quick look at the example queries I just added to my answer? It seems like a lot of conditions just to determine who's registered but I guess since I created view_valid_registrations as a view it should be easy enough to work with. I'm going to accept your answer of course, you've been very helpful - I'm just using my answer as a space to verify that I'm understanding this correctly.
Apr
3
revised Handling expiration in a course registration or ticketing system
added 647 characters in body
Apr
3
revised Handling expiration in a course registration or ticketing system
added 647 characters in body
Apr
3
revised Handling expiration in a course registration or ticketing system
deleted 6 characters in body
Apr
3
awarded  Editor
Apr
3
revised Handling expiration in a course registration or ticketing system
added 153 characters in body
Apr
3
comment Handling expiration in a course registration or ticketing system
@JoelBrown See my answer below...I think it satisfies your two main guidelines, no?
Apr
3
answered Handling expiration in a course registration or ticketing system