Drew Jensen wrote:
Thanks, Drew! i had looked at that old post and still couldn't make heads or tails of it. i can now input macros now... sort of, into the macro library, so if you think that that would do it, it would be great! if we could get it up.FamiliaFrazelle wrote:Alex Thurgood wrote:Drew's answer was good. i was able to "add" a field (column) and edit the first column of the same name and it has worked so far. Now if i just find the correct formula to stick in there which will display the patient's age in years and months, we'll be home free!FamiliaFrazelle a écrit :Hi,Huuu... that's a good one... "then use the column from the original for your calculated field..." i'll try that & see what happens. Thanks again and have a great afternoon! :)I seem to recall that there is a bug entry open for not being able to update queries graphically based on joined tables through the query display.Alex --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]Have a great evening! :) Thanks Drew! and all the others who helped as well!The questions are getting easier Familia...old post on oooforum on that. You can get the example database that went with it at http://www.paintedfrogceramics.com/OpenOffice/MedRecords.odbThere is a single query in the file that displays a patient's ages from days through years. ( pediatrics through geriatrics if you like )There is a form in that file also to show how to do the calculation in Basic instead of SQL, but the basic macro isn't in the forum, was listed in the forum post. If that interests you let me know - I think it might be worth putting this up, with a fresh post at the new forum.Drew --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Have a great evening! ;-)
smime.p7s
Description: S/MIME Cryptographic Signature
