How to sort reports by date in Access. Access Archon #163 Introduction If you have a report with a date field, you may need to sort the report by date, and Access has a built-in feature that lets you do date sorting very easily, without preparing a query in advance, or writing code. This article […]
How to generate random numbers. Q: Bob wants to know if there is some way to generate random numbers within a certain range (he needs to fill a field in a table with sample values). A: Yes, there is an Rnd function you can use for this purpose. It returns a Single value, so you […]
How to make one cell in a datasheet subform a different color than the others using conditional formatting. Q: Rosie W. writes to ask if there is any way to make one cell in a datasheet subform a different color than the others. This control is locked, and she wants it to be a different […]
How to sort Reports by date in Access. Access Archon #163 You might need to group records by date using another interval that is not available in the Group On list. If the interval is regular, you can create a query field, such as the Decade field in qryMembers: Decade: Left(Format([BirthDate],”yyyy”),3) & “0” The […]
How to merge data from a recordset based on a query to Word documents. Access Archon #168 Introduction An AW reader wrote to me asking if the document properties merge code in my Code Sample #24could be modified to merge data to Word from a query, instead of selections in a listbox. While the […]
