New Query

B

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?
 
J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top