C-TB1200-07 Free Dumps Study Materials
Question 15: Every day my employees run a query to check how many orders we have issued on that day and what
their value was. I have created a simple query using the Orders table (ORDR): Document Number,
Document Date, Document Total Where Document Date EQUAL 01/05/07 (for
example). How can I create a "general" query so I do not have to go into this query statement every day to
change the date in the "Where" condition area?
A. Define a variable in the "Where" condition area of the formula: Document Date EQUAL '[%0]' then save
the query. Each time you run it, the system will prompt you to enter the desired date.
B. Delete the condition from the query. Create a general query that will display all the orders created in the
system to date. When the report displays, use the Sort Table to display the desired data.
C. Define a variable in the "Where" condition area of the formula: Document Date NOT EQUAL
'[%0]' then save the query. Each time you run it, the system will prompt you to enter the
desired date.
D. Define a variable in the "Group By" condition area of the formula: Document Date EQUAL
'[%3]' then save the query.
Correct Answer: A