Calculated fields and query

S

Sokan33

My problem is simple espcially to you gurus and my expalination is probably
more complicated than the solution.

I have a two tables: Table1(Membership) and Table2(Annoitment)

Table2
FIELD FIELD TYPE
DateAnnoited Date/Time
TimeLastAnnoited Number
DueForAnnoitment Yes/No

QUERY1 (Select Query) is a combination of Table1 and Table2. The query also
has
DateAnnoited
TimeLastAnnoited
DueForAnnoitment

Form1(Mebership) also has above fields
DateAnnoited:
TimeLastAnnoited: [the control source is:
=DateDiff("yyyy",[DateAnnoited],Now())+Int(Format(Now(),"mmdd")<Format([DateAnnoited],"mmdd"))]. This field returns x
DueForAnnoitment: Yes/No

Objective:
1. If x => 2 I want DueForAnnoitmentField mark YES
2. I want to write x and the YES back to the table so I can run query
against those fields.

Your input will be highly appreciated!

With high regards,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Union Query by choice.. 11
Delete duplicates QUERY 0
fields in a select query 1
display criteria as a field in returned data 3
SQL- How to delete records based on QUERY ? 5
Query on two tables with matching null fields 4
Calculating age problem 8
AfterUpdate cbo box from query based on other field 1

Top