Ok ive come on here before with a project im doing for college.
You guys gave me great advice:)

Im stuck again....

Heres the lowdown:

Its a database for an estate agents, ive done the tables to the best of my ability but im coming across difficulty with some things.

One is that each member of staff in the estate agents has to have something showing how many properties he/she is actually dealing with.

Ive put this in the staff table and called the field property dealing count.

Is there a way that this field can update itself when he is given more properties?

I.E if says hes got 5 properties on his books and he is given one more...when i enter his staff id with the property i want it to go to 6???

I know you will find tons of other errors in this. I am very grateful for any help:)

BTW the data entered in properties is made up.

PROPERTIES (http://www.geocities.com/martynflynn/PROPERTIES.zip)

You should not be storing the count of properties, you should be deriving it at runtime by counting the number of proerties assigned to the agent. You can use DCount() on your form to do this or you can add a footer to the properties list subform and add the count field there.

Thanks for the help mate.

Can i trouble you all for another problem.

One of the questions that i must answer for college is this:

Create a query and suitable report containing details of visits for each property for any given week giving details of customers’ comments. Save the Query as Visits2003 and the Report as Report 03.

Im hoping ive put the correct fields in the query...but is there like a calendar option that i can put in. As it says "for any given week". If so how do i do it? If there is a way please tell me in laymans terms as im a noob:S

college_project (http://www.geocities.com/martynflynn/PROPERTIES.zip)

Dam ive just realised ive put this question in the wrong thread.

Plz forgive:)