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!
-
Padding a field
I update a table using an update query. Part of the updating includes converting a field format from numeric to text. All of this works fine. However, the text field needs to contain 5 characters. For example if the data is 205 it needs to read 00205 or if the data is 1 it needs to read 00001...- asexton
- Thread
- Replies: 4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Create dynamic reports
I would like to create several dynamic reports where the design may change depending on what fields are selected in a query. For example, sometimes fiscal year is chosen, but other times it may not be. The project manager doesn't want blank columns but just the fields he selects to be included...- asexton
- Thread
- Replies: 0
- Forum: Microsoft: Access Reports
