Search results

This code is very clear and works! Modifications may be required, such as removing the "txt" before the Field Name, and if your form field is based on a query rather than a table. Thanks to ntp! cft

This works great! Thanks for your input and help!

Thank you! This is good information. I am trying to figure out how to use this to automate the between function to read Now() or "Today's Date" and calculate the Average for the past 180 days, or 90 days, etc... Is there any SQL or Expression building for this? I know just enough to know what...

I need information regarding how to calculate a moving average over the most recent 6 months-to-date. I searched the postings for "Moving" and "Rolling" averages, but came up empty. Any Ideas?

I have a query constructed as follows to total $Refunds and #Refunds by month. the Fields are: Date By Month: Format$([TblRefunds].[Date],"mmmm") Seq:Year([TblRefunds].[Date])*12+DatePart("m",[TblRefunds].[Date]-1 Group by Date By Month and Seq Also, I selected Aggregate Sum selected for...

I have a form with 2 subforms. One subform autopopulates with Employee data upon input of the Employee ID. Another (single field) shows which, of 12 entries into the employee file, is the current one. Upon opening the Main Form thru the switchboard, 2 Criteria boxes pop up sequentially. The...

I got it. The correct SQL should have been: SELECT Count(TblAudPerf.EmpID) +1 AS CountOfEmpID FROM TblAudPerf WHERE (((Month([Event Date]))=[Enter Month as Digit]) AND ((([EmpID]))= [Enter EmpID])) GROUP BY TblAudPerf.EmpID; This maps it to the correct location and accomplishes what I needed...

I think I am close, but cannot get this subform to bring up the information. I have a form It has locations to enter an EmpID and an Event Date. Located on the form I have a Subform called Record. This displays the number of entries for XYZ Employee for the month entered as MM/DD/YY in the...

I have to display current data to a department as calls are received continually to find out status of refunds. I have opted to display this in an Excel spreadsheet. Problem is the sheet only allows updates when the Access db is "Open". Can the spreadsheet be opened to allow "update-yes" with...

I have a form that is intended to allow the user to authorize payment. User receives numerous requests through a query reading an Is Null field. The button is to fill the Is Null field on the multiple records with the user's name. I have seen this in previous inquiries in the archives, but...

Jon - Thank you for getting me into the right arena. I am still having trouble getting the syntax correct. After about 50 attempts to reconfigure the structure of the statement, I am getting Error messages. Most recently 3075 regarding a missing operator in the WHERE statement. I am using the...

I am creating a Data Entry Form for Employee evaluations. On the form I have a calculated field called "Record". This field is to show the cumulative number of audits per employee within a given month. Each Supervisor has Employees whom they evaluate 12 times a month. The form confirms the...