Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Is there any was to make Sun, Mon, Tue, etc. all capitals?
Change: =Format(datefield,"ddd") To: =StrConv(Format(datefield,"ddd"),vbUpperCase) EJV- EJVTECH
- Post #5
- Forum: Microsoft: Access Reports
-
Date Sort in Union Query
Have you tried setting the format of the field to "dd/mm/yyyy"? Then you can eliminate the format in your query and add ORDER BY [InvDate]- EJVTECH
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
Get MonthNumber from abbreviated month name
Easiest way I can think of would be to have a monthID field in myTable that is 1 through 12 (January thru December). Then your sql would be: SELECT Left$(MonthName([monthID]),3) AS abbMonth FROM myTable ORDER BY myTable.monthID;- EJVTECH
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
Access2000 - Need calendar help
Remou: Posting to Outlook directly to at least get me a quick way to print these calendars would be great but raises another question... ...Would I be able to manipulate that data (drag and drop a job to another complete by data) then import it back to Access? Do you have a link that will...- EJVTECH
- Post #4
- Forum: Microsoft: Access Forms
-
Access2000 - Need calendar help
Hi, I am new to this site but have been programming Access for about 7 years and got a question regarding calendars. I have multiple schedules (vacations, shipment dates, etc.) that I would like to display in a Calendar form to be printed. I have found a couple ways to do this but not...- EJVTECH
- Thread
- Replies: 5
- Forum: Microsoft: Access Forms
