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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Keeping the Caption when using SQL
In a database I am creating, I constantly create tables using SQL (through VBA) that I subsequently want to use in reports. In some tables, I want the name of the field that prints on the report to be different than the field name so I have specified a caption for those fields. However, when I...- paty
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
-
How to create report with varying parameters
Hello, I have built a very complicated database for a client in which the user can, among other things, summarize over fields (I am using Visual Basic and SQL to summarize over the data by basically selecting all other parameters except for the one the user has selected to use as a...- paty
- Thread
- Replies: 4
- Forum: Microsoft: Access Reports
-
Using SELECT DISTINCT (when memo fields are involved)
I am developing a database and one of my queries uses the DISTINCT keyword. Some of the fields that I am selecting are memo fields. While trying to run the query, some of the users are getting "RUNTIME ERROR 3114", which indicates that you cannot select distinct values when memo...- paty
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
