Unit 2 - D functions Flashcards
What are the six D (prefix functions)
DLookUp DAvg DCount DMax DMin DSum
What does DLookUp do?
DLookUp finds what you are looking for within the domain and returns the value of the field or if it does not exist, Null.
What does DAvg do?
Returns the average of a numeric field,
What does DCount do?
Returns the number of records or data from a table that matches the given criteria.
What does DMax do?
DMax returns the largest number in the domain based on the criteria.
What does DMin do?
DMin returns the smallest number in the domain based on the criteria.
What does DSum do?
DSum calculates the sum of a set of values in a domain.
What are the arguments for the D prefix functions?
(Expression, Domain, [Criteria])
What is the expression argument in regards to the DLookUp function?
The name of the field that that is going to be looked at.
What is the domain argument in regards to the DLookUp function?
The table or query that holds the data.
What is the criteria argument in regards to the DLookUp function?
Any restrictions that will be added to the search for the data.
How do I add a criteria based on a value in a text box?
In the criteria argument close it after the = sign and use “&” to call the text box and follow it by .[Value] to call its value.
What needs to be done to a Date value to ensure access knows its a date?
Surround it with “#”.
When using a D function and you have a string as a the criteria what do you need to do to the string.
Surround it in single quotes.
When you need multiple criteria what do you add on to the end of the criterion?
AND
