User Profile
GustavBrock
MVP
Joined Apr 26, 2017
User Widgets
Recent Discussions
Re: add year month and week using just date field
For year and month you can use the native functions Year and Month. For week you may get away with DatePart("ww", [Posting Date]). However, if you wish the ISO 8601 weeknumber, a custom function is needed like my function Week found in module DateCore in my repository at GitHub: VBA.Date. As noted, don't update a table; create and run a select query.Re: FindFirst not working
Maxine14062 You can filter the recordset directly: Dim rst As DAO.Recordset Dim SQL As String SQL = "Select * From SchedFieldTable Where [Width] + [Left] > 10.5 * 1440" Set rst = CurrentDb.OpenRecordset(SQL) If rst.RecordCount > 0 Then ' List the found FIDs. rst.MoveFirst While Not rst.EOF Debug.Print rst!FID.Value, rst!Width.Value, rst!Left.Value rst.MoveNext Wend End If rst.CloseRe: Minutes and Seconds Field
Jqws13_ That is correct. Even worse, on a new record, 00:00 will be displayed, but - even worse - if you enter, say, 48:37, Access will report "Invalid date", as the entry will be parsed as hh:nn. Your best option is probably to use two juxtaposed textboxes holding minutes and seconds respectively, and assemble these with TimeValue(0, n, s) to build the time in the BeforeUpdate event of the form, and use Minute([TimeField]) and Second([TimeField]) to display the time using the OnCurrent event of the form. Ultimately, create a form using Inputmask and custom code similar to what I did here: Entering 24-hour time with input mask and full validation in Microsoft AccessRe: How to get a Weighted Average instead of an average of averages.
slohombre : Like this: SELECT Week, Yield, Acres, [Yield]/[Acres] AS YieldPerAcre, (Select Sum(Acres) From Crop) AS TotalAcres, (Select Sum(Yield) From Crop) AS TotalWeight, [TotalWeight]/[TotalAcres] AS WeightedAverage FROM Crop; Output:
