DataBase - Alert on creation of new sales order

I am trying to setup a business alert in GP to notify certain users when a
new sales order is created. Can anyone advise me on what table/fields to to
select and what the formula should look like. Thanks.
LR

  Mohammad R. Daoud replied to LR

You might need to check CreatedDate Field of table Sales Transaction Work,
create something like the below formula:

SOP10100_T1.CREATDDT BETWEEN DATEADD(Day, -1, GetDate())  AND GetDate()

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Mob: +962 - 79 -999 65 85
mohdaoud@gmail.com
http://mohdaoud.blogspot.com/

total number of months of each pupil's Age with: DateDiff("m", [DoB], Date())+IIf(Day([DoB])> = Day(Date()), 1, 0) So in a query you can average that with: AvgAgeInMonths: AVG(DateDiff("m", [DoB], Date())-IIf(Day(DoB)> Day(Date()), 1, 0)) You can of course substitute a literal date for the Date() function it in the query by repeating the expression: AvgAge: AVG(DateDiff("m", [DoB], Date())-IIf(Day(DoB)> Day(Date()), 1, 0)) \ 12 & " yrs and " & AVG(DateDiff("m", [DoB], Date())-IIf(Day(DoB)> Day(Date()), 1, 0)) Mod 12 & " months" or you do the same in a footer of

these dates needs to become a column heading. Additionally, I only want to use the day from each of these dates so that the headings are as follows. 2 5 7 cfm?fid = 5466 You should be able to change the date interval from Month to Day. - - Duane Hookom Microsoft Access MVP Hi Duane, I actually tried that but I was not AS TheMonth, tblDates.dteProjDay FROM tblDates GROUP BY Year([dteProjDay]), Month([dteProjDay]), tblDates.dteProjDay PIVOT Day([dteProjDay]); This results in the following output: TheYear TheMonth dteProjDay 2 5 7 2010 4 2010 2010 4 4 / 30 / 2010 From this I have no way of displaying the day; ie. 2, 5, 7 in the Textboxes that make up my Report Column Headings. What Month([dteProjDay]) AS TheMonth, tblDates.dteProjDay GROUP BY Year([dteProjDay]), Month([dteProjDay]), tblDates.dteProjDay PIVOT Day([dteProjDay]); John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Year([dteProjDay]) AS TheYear, Month([dteProjDay]) AS TheMonth GROUP BY Year([dteProjDay]), Month([dteProjDay]) PIVOT Day([dteProjDay]); If not all days are displayed, you can add all days from 1 to AS TheYear, Month([dteProjDay]) AS TheMonth From ([tblDates]) GROUP BY Year([dteProjDay]), Month([dteProjDay]) PIVOT Day([dteProjDay]); This gives me the following output. TheYear TheMonth 2 5 7 9 12 14 dteProjDay]) AS TheMonth FROM tblDates GROUP BY Year([dteProjDay]), Month([dteProjDay]) PIVOT tblDates.EventLabel In ("Day 1", "Day 2", "Day 3", "Day 4", "Day 5", "Day 6", "Day 7", "Day 8

on 16 hours to caluclate process time of work. I need to include a 5 day work week. if a worker gets something on Friday at 4:00pm and does not saturday and sunday. I assume the '8 hours' means you have an 8 hour working day. The expression I gave you will compute the difference in hours form the time on Midnight to 06.00 AM. This takes no account of the length of the working day, however, so how are you allowing for this when calling the DateDiff function? One way start and end work date / time values, the start and end times of the working day and the days of the working week: Public Function MinutesWorked(StartTime As Date, _ EndTime minutes for all workdays lngMinutes = DateDiff("n", DayStarts, DayEnds) * intDayCount ' subtract unworked time on first day lngMinutes = lngMinutes - DateDiff("n", DayStarts, TimeValue(StartTime)) ' subtract unworked time on last day lngMinutes = lngMinutes - DateDiff("n", TimeValue(EndTime), DayEnds) MinutesWorked = lngMinutes End Function The working days are entered as values from 1 to 7 (Sunday to Saturday), so for a 5-day working week, Monday to Friday, you would call the function as below in the debug use the field names when calling the function in a query or report). A working day from 9:00 AM to 5: 00 PM is assumed in the examples. So for

daily call records. The table includes fields for: Department; Name; Date of Call; Time of Day; Call Direction; Number Dialed; Locale; Length of Call. I created a query that will show are over 3 minutes Average daily outgoing calls (when running report for more than one day) Average daily incoming calls (when running report for more than one day) SELECT DailyCalls.Department , DailyCalls.Name , Count([Name]) as TotalCalls , Abs(Sum(LengthOfCall > = #00:03:00 be done in a separate queries. First query to get a count of calls per day And then a second to use that to get the average of the count per day SELECT DailyCalls.Department , DailyCalls.Name , DailyCalls.Date , DailyCalls.CallDirection , Count([Name]) as TotalCalls FROM DailyCalls percentage of incoming calls over 3 mintues0 Now based on the number of calls per day per employee I need to calculate the average number of: In; Out, and 3+ calls it what you want. Average number of calls by type. Do you want = = average per day over a period of time by department = = average per day over a period of time by employee = = average for the entire period of time by

need a slicker way DataBase to do this: . . . ElseIf (Day(Date) > 12 And Month(Date) = 12 And Day(Date) < 18 And Month(Date) = 12) Then Week = "49" ElseIf (Day(Date) > 19 And Month(Date) = 12 And Day(Date) < 25 And Month(Date) = 12) Then Week = "50" ElseIf Day(Date) > 26 And Month(Date) = 12 Or Day(Date) < 1 And Month(Date) = 1) Then Week = "51" ElseIf (Day(Date) > 2 And Month(Date) = 1 And Day(Date) < 8 And Month(Date) = 1) Then Week = "52" ElseIf (Day(Date) > 9 And Month