Access Query Help

[[Neo770]]

Hi guys,

I cant get my head around a query. (Because im a DB noob)

In this example table from a MS template im working on:

Call ID	Contact ID	Call Date	Call Time	Subject	Notes
1	Danseglio,Mike	21/11/2005	1:35 PM	Buy flavored coffees.	Mike told me about their blends. Thinking about it. Should call back later.
2	Danseglio,Mike	19/12/1999	3:19 PM	Buy espresso beans.	Usual monthly order.
3	Danseglio,Mike	25/12/1999	2:25 PM	Buy flavored coffees.	Asked Mike about their Hazelnut flavoring.
4	Danseglio,Mike	13/01/1999	4:10 PM	Buy flavored coffees.	Placed a special order on the Hazelnut.
5	Danseglio,Mike	22/01/2000	1:13 PM	Buy espresso beans.	Changed the usual monthly order.
6	Counts,Robin	21/11/1999	12:05 PM	Suite of coffees.	Spoke to Robin about NWIND carrying a coffee collection designed by us.
7	Counts,Robin	13/12/1999	12:45 PM	Pricing for proposed suite.	Too high - should wait and see if Robin comes around.
8	Counts,Robin	10/01/2000	10:47 AM	Pricing for proposed suite.	She offered $100 less per order (12 packages / order) - OK.
9	Counts,Robin	29/01/2000	3:12 PM	Pricing for proposed suite.	Set up marketing plans w/ Robin.
10	Counts,Robin	1/02/2000	3:20 PM	Marketing.	Confirmation of shipment.
11	Counts,Robin	1/02/2000	6:49 PM	Delivery.	Got some really odd new blends.
12	Frum,John	1/12/1999	12:00 PM	Funky Coffees.	Even more new blends.
13	Frum,John	29/01/2000	2:30 PM	Funky Coffees.	Ordered a sample.
14	Frum,John	1/02/2000	3:15 PM	Funky Coffees.	Ordered 1000 lbs. - good stuff.
15	Philips,Carol	13/12/1999	9:00 AM	Usual order.	Shipment to Carol was late, oops.
16	Boseman,Randall	1/01/2000	1:00 PM	Shipment went to wrong address.	Carol's shipment went to Randall, oops.
17	Danseglio,Mike	18/05/2007	8:48 AM	sd	
18	Danseglio,Mike	18/05/2007	8:48 AM	asd	
19	Danseglio,Mike	18/05/2007	8:48 AM	as	
20	Danseglio,Mike	18/05/2007	9:11 AM	OMFG

I would like to display the people that say have no call information between eg 1/05/2007 and 31/05/2007

Any help would be great thanks.

[Rootstonian]

That's an ambigious request. What is "call information"?. Does that mean they have something (or nothing) in the "subject notes" field? Does it mean they've called before but not called between those dates?

[[Neo770]]

I was afraid I was asking the wrong question.

This is where I get confused. I want to be able to enter a date range and have it tell me who has no records at all between those dates.

[Rootstonian]

Still are!

For example, in English:

Please enter date for those who don't have records:
02/05/2007 02/06/2007

No records found for people who aren't in the database cuz they didn't do anything! LOL

[[Neo770]]

Yup you’re right. I’m asking for no data.

So is it possible to get that sort of data out of that table or do i need a totally different setup.

[[Neo770]]

Ok maybe I should just scrap this template and explain that I would like to do.

All I want is a simple DB that tracks an employee name and has a list of dates attached to each employee of when they have done this training. Then I need to be able to generate a report of employees who have not done the training in a specific date range (usually within the last month.)

[Rootstonian]

Set it up with columns of Employee_Name, Training_Complete, Date and anything else you need.

Then:

Select Employee_Name
from Your_Table_Name
where Training_Complete = 'N'
and Date between '01/05/2007' and '01/06/2007'

You'll have to update the DB for those who complete traning and set Training_Complete to a 'Y'. And you'll have to put dates in for all employees, training completed or not (consider it "scheduling" )

[[Neo770]]

Ok finally got the time to set this up.

I have the table setup exactly as you explained. I can run the query and get people who have not completed training.

Now I need some help with the last bit. How do you update the table for when someone completed training, everyone else has a no entry?

[[Neo770]]

Sorry still need help...
BUMP

[[Neo770]]

One more Bump to the Top.