call log

[jarheadjim]

I am setting up a database to track a call log (I am going to be a recruiter for the Marine Corps soon). I have a query built to show me anyone I haven't called back in 6 days. The problem is I need a way to mark a call as updated if I have called more recently. In other words only query the most recent call for each caller. Any suggestions?

 

[Jerry Stoner]

Hey Jim

In the properties for your query select top values and put in 1. This will return the most recent call.Leave the criteria - I assume its something like >Date()-6 - alone.
Congrats on the new assignment.

 

[jarheadjim]

It only shows me the first entry now, am I adjusting the correct property? I opened the query in design view, and in the top portion where you place the tables you want queried I am right clicking and setting the top value to 1. I'm trying to get it to query me the most recent call for every person i have entered.

 

[Jerry Stoner]

Sorry, misunderstood. What I gave you will always return only 1 record. Are you set up with a table for contacts and a seperate table for calls? tblContact and tblContactCall with a one to many relationsdhip? If so use a form for contacts and a subform for calls and use the top values query as the rs for the subform. You should then see 1 record for each contact. Build a report based on those queries and you should be good to go.

Edit

Rereading your post it looks like you have 1 table with Contact and Call info. If so you need to split into two tables.Then the solution in this post will work.
HTH