Query to table

  • Thread starter Thread starter Lachie
  • Start date Start date
L

Lachie

Hello,

I have constructed a query that calculates the members age
from their date of birth just fine and inserts this into a
column named members_age in the query. When I go back to
the main table and look at the members_age table the
calculated age is not there. Due to my limited knowledge
of ACCESS I am wondering if there is something simple I am
missing or just wishful thinking that this can me done. I
have also tried creating a relationship to the main table
from the query but bo success.

So I guess my question is how do I get the calculation
from my query to appear in my main table?

Any help would be greatly appreciated.

Regards

Lachie
 
You don't need to get the age to appear in the table. You can add all the
other fields from the table to the query, and then use the query anywhere
that you would use the table - eg as the record source for forms or reports.
You shouldn't be entering data directly into tables - always use forms for
this.
 
Thanks for your reply.

That sounds like a great idea.

I am usine this db online so am updating it online using
forms.

Thanks for your help

Lachie
 
Back
Top