FamiliaFrazelle wrote:
Alex Thurgood wrote:
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]
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!
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.odb
There 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]
