New Query

[Beeyen]

Good Day

Now that I have built a database, I am trying to build a query from the
table in the database that will return the information from the following
fields: Production Assigned, Datatrak Number, Work Type, Work Category,
Review Score, Effective Date, Complexity Points, the number of Datatrak
Numbers completed in 3 and 7 days (between the Date Received field and the QA
completed field).

Additionally, I would like to have a drop-down in the form where I can
select the Name of the User which equals Production Assigned, show timeframes
to get updates from such as current, 7 days, 14 days and 30 day periods


Can someone assist me in getting started with this query?

 

[John W. Vinson]

Good Day

Now that I have built a database, I am trying to build a query from the
table in the database that will return the information from the following
fields: Production Assigned, Datatrak Number, Work Type, Work Category,
Review Score, Effective Date, Complexity Points, the number of Datatrak
Numbers completed in 3 and 7 days (between the Date Received field and the QA
completed field).

Since you chose not to post anything about the structure or relationship of
your tables, it's not going to be easy to give a good answer. YOU can see your
database... we cannot.

Nor is it clear what you mean by "completed in 3 and 7 days".

Additionally, I would like to have a drop-down in the form where I can
select the Name of the User which equals Production Assigned, show timeframes
to get updates from such as current, 7 days, 14 days and 30 day periods

"timeframes to get updates"...????

Can someone assist me in getting started with this query?

Not without a better understanding of your structure, or better intuition than
I currently posess, no.

 

[KARL DEWEY]

Post sample data.