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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Change case of specific strings (columns)
Hi. I have a file where the first name and last name are in columns 2 and 3. Currently, they are both in all caps. I want to change it so just the first letter of the first name and the first letter of the last name are in caps. I have some code below but I need it modified to only include... -
Using date variables in sql statements
I am an SQL novice. I am going to be putting some of my access queries in macros so I need to automate some of the dates I have in my SQL statements so no user intervention is required. I have researched but have not found what I need yet. Here is one of my SQL statements. I just need to have...- gmgenova
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
Run query and sort
I have a crosstab query that has an aggregate field in it that I can not automatically sort when the query runs in Access. I am making a VBA macro and am trying to run the query in there and also sort that particular field. I am not very experienced with VBA so I am getting errors. I am just not...- gmgenova
- Thread
- Replies: 8
- Forum: VBA Visual Basic for Applications (Microsoft)
