avg numeric field for specific day in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

average pay [PAY] field for Mondays only. Date field is named [DAY]
 
Your previous message was answered at 10:30. Did that solution not answer
your question?
 
dpescejr said:
average pay [PAY] field for Mondays only. Date field is named [DAY]
Click to expand...


Avg(IIf(DatePart("d", [DAY])=1, [Pay], Null))

But you'll probably want to use that in some context. If
it's in a form/report text box, put an = sign infront of the
expression. In SQL you need to add AS AvgMonPay to name
the calculated value. In the QBE for a Totals type query,
the calculated field would just be:
IIf(DatePart("d", [DAY])=1, [Pay], Null)
with Avg in the total row.
 
You must log in or register to reply here.

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

Average numeric field (PAY) for specific day of week in Access que 3
Numeric Field Overflow when appending date - how to convert it to text 1
How to calculate days due? 3
Left Join Question 2
Avg # of days minus weekends 8
Calculate buisness days rather than calendar days 2
Average last 30 days for each day in the quarter 7
Convert Date from yyyymmdd format to numeric day of week (1=M, 2=T 4

Back
Top