Recent content by Roaming_Tigerr

Access 2007 Hello everyone - hope someone can help. I am fairly new to Access and am having a problem retaining filter settings. Scenario: I have a table with 800 records viewed by Form. Several of these records are filtered by one basic criteria. The filter works manually without problem but...

Thank you all for your contribution/s - I think I've got the gist of it so will spend the weekend Querying til my heart's content. you have turned me from :banghead: to :D in less than a day - quite an achievement. Thanks again Mike

Many thanks to VBA & Bryan. The field 'Age' in the form is a calculated field with the following in the Control Source of the Property Sheet: =DateDiff("yyyy",[Date of Birth],Now())+Int(Format(Now(),"mmdd")<Format([Date of Birth],"mmdd")) From that it calculates the difference between the...

Hello peeps, hope someone can help? Access 2007 I have a field 'Age' that automatically derives the age from another field 'Date of Birth.' However when I create/run a query where I want to show the age relevant to each record the age field is blank? I suspect it may be something to do with...