Query

[renenger]

I have a Delivery Database. We input the job information and track it as it moves through the plant to customer delivery. Each job has a specific job code.

However, sometimes we deliver products on a specific job over several deliveries. These deliveries are differentiated by a RUN letter. For example you could have KBHD B, KBHD c, etc....

I want to create a report that will show all our new jobs. New jobs would be job codes that are not already in the database.

If I run the report for January, I want to see all the new job codes that were not already in the database in December.

Any ideas how to do this????

 

[Fuga]

Where do you keep records of the jobs that are not yet processed?

Fuga.

 

[renenger]

New Input Query

Basically, all our job information is kept in tblDeliveryInfo.
The user goes in and inputs new jobs as they come in. However, not all new jobs are new jobs, they are just another delivery to an old contract.

When we get a contract we assign that subdivision a job code. We may run deliveries to that job code several times over the course of months. These are distinguished by RUN letters. KBIM run A, KBIM run B, etc....

So the user may input KBIM run AAA and it's not a new job. However, we may acquire a new contract for a new subdivision. For example, let's say we just got a contract for Summergate. The job code for that is CGSG and that was a new job that we got in January.

I want to be able to run a query that is going to compare job codes and only show the ones that are new during the time period specified. That do not have any instances in the database.

Does this make sense??