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
