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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.