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!
Search results for query: *
- Users: LarryViles
- Order by date
-
Select Where variable error
In Access 2003 I have the following statement as part of a report. I wish to change the literal '8' to a more user friendly variable (like ThisMonth). Every attempt to do so results in an error message. rst.Open "SELECT [Birthday Query Sub].[1stResident], DatePart('d',[1stBirthday]) AS...- LarryViles
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Use of a variable in a Select Where statement
In Access 2003 I have the following statement as part of a report. I wish to change the literal '8' to a more user friendly variable (like ThisMonth). Every attempt to do so results in an error message. rst.Open "SELECT [Birthday Query Sub].[1stResident], DatePart('d',[1stBirthday]) AS...- LarryViles
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
