I have a DB of Members (Parent Records). Each Member has several Children (Child Records). I have a button which runs a query and outputs the First Name, Last Name and Birth Date of each CHILD into an Excel Spreadsheet.
This worked fine until the guy who uses the Excel Spreadsheet said he needs the birth dates in YYYYMMDD format with NO Seperators.
I wrote my own function (I’ll send it to you if you give me your Email Address) and the function seems to work. Each child is on a seperate page and I can see the birth date and the “New Format” birth date. Switching pages changes the birth date and “New Format” birth date without a problem.
HOWEVER, when I output the data using the query, I get whatever birth date was on the page where I hit the Export button. And every child has the SAME BIRTHDATE.
I can send the query for you to examine.
Thanks for your help!
This is a real brain teaser!!!
Alan
Abramowitza@coned.com
