I have a table with a field DealDateContract. There are two additional fields in the table that need to be updated with information based on the date in this field, but I can't get the below to work. Am not sure if there is a QUATER function in ACCESS 2010.
Public Sub YearQuarterSort()
'UPdates quarter and quarter sort columns in tblReportSource table
Dim rst As DAO.Recordset
Set rst = CurrentDb.OpenRecordset("tblReportSource")
Do While Not rst.EOF
Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works
The attack works by targeti…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database.
Split up all multi-value fields into single values:
Split up fields that belong to other things into separate tables:
Make sure that all record…