Return Styles: Pseud0ch, Terminal, Valhalla, NES, Geocities, Blue Moon. Entire thread

Need assistance w/ SQL query

Name: Anonymous 2006-05-31 8:55

Using Jet-SQL (I know, flame away, as long as someone tries to help), have a table of people. One field contains their birthdate, and given user input of a pair of dates (one "low", one "high")I need to use this field to figure out who will be turning exactly X yrs old at a time between the user's given high and low dates. Any help appreciated. And while I do intend to eventually switch database solutions, until I have the spare hardware and time to implement, that is not something I can do immediately.

Name: Anonymous 2006-05-31 11:43

Try converting [enter end date] and [enter start date] to dates using the CDate() function

Newer Posts
Don't change these.
Name: Email:
Entire Thread Thread List