Re: Occurances happening at the same time query

Top
james.szumigata@xxxxxxxxxxxxxx wrote:
Is this what you mean

TABLE A:

Worker Name:
Project: (All A's I separated them out)
Project Start Date
Project End Date


TABLE B:

Worker Name:
Project: (All B's I separated them out)
Project Start Date
Project End Date


KARL DEWEY wrote:
I can not tell you how to construct a query if I do not know how you collect
and store the data.

What is your table structure?

"james.szumigata@xxxxxxxxxxxxxx" wrote:

I just need to know the workers name:

for example:

Joe Smith would show up in the query as he is working on project B on a
day within the range he was working on project A
KARL DEWEY wrote:
How do you record the work?
One record per project with start and end dates?
Or one record per employee per project per day?


"james.szumigata@xxxxxxxxxxxxxx" wrote:

Hello,

I have a question that I was hoping that someone could help me with. I
need to know if two events are happening at the same time. For
example:

Joe Smith was working on project A from 1/1/2006 to 1/31/2006 and was
working on Project B in 1/5/2006. I need to know how to identify if
they are working onan two projects at the same time...I know its easy
with 1, but with 50,000 people i need to use a query.

Any help would be greatly appreciated.





.

Relevant Pages

  • Re: Summary and Detail Report
    ... I'm a bit concerned when you say that your query is one table. ... I also have a Worker table with WorkerID and eg WorkerSurname ... Base your main Report on a query based on your appointments table, ... This will give you your 1 page per appointment. ...
    (microsoft.public.access.reports)
  • Re: Occurances happening at the same time query
    ... FROM TableA as A INNER JOIN TableB as B ... Worker Name: ... KARL DEWEY wrote: ... with 1, but with 50,000 people i need to use a query. ...
    (microsoft.public.access.queries)
  • RE: Subform populated from combo boxes
    ... In your query that creates the ... put the combo box fields as criteria. ... This will populate the subform. ... When the user selects the worker and the competency ...
    (microsoft.public.access.forms)
  • Re: Drop down list for queries
    ... with a combo named cboWorker. ... Choose the worker in the combo. ... In the Criteria row of your query, under the correct field, enter: ... rather than allenbrowne at mvps dot org. ...
    (microsoft.public.access.queries)
  • Re: Occurances happening at the same time query
    ... Worker Name: ... KARL DEWEY wrote: ... they are working onan two projects at the same time...I know its easy ... with 1, but with 50,000 people i need to use a query. ...
    (microsoft.public.access.queries)