My organization has requested the use of a given schedule template to be used for all projects. As a result, this template will be used for multiple sub projects that will be contained in master project.
I’m trying to develop a group filter to apply to the master project which will identify...
I’m trying to convert signed a text field from a mainframe file to currency depending upon the sign. The sign will either be a “+” for positive amounts or “-“ for negative amounts within a calculated query. For example, I have a test field called TAX which contains 50.00.
Record 1:
Tax...
I'm trying to convert an address field that contains stores the Street Number, Directional (If Applicable) Indicator, Street Name, and Unit Number (If Applicable), but I do not know of a where I could possibly parse through the Address field in MS access to convert the string into separate...
In support of a data conversion effort, I'm trying to create a calculated field within a query to create a unique id from an access table for every record within the database. I was hoping to do this without having to create a sub-routine.
When the database was initially created, the index...
In support of a data conversion effort, I'm trying to create a calculated field within a query to create a unique id from an access table for every record within the database. I was hoping to do this without having to create a sub-routine.
When the database was initially created, the index...
I'm pretty inexperienced with MS Excel and I need some assistance. I'm trying to calculate the average age of an issue based a particular range of dates and then for each particular issue, convert the average age of the issue to to actual days. Is there a simplistic approach that I can take...
Thanks so much for the information. I have one additional question. The only other problem I'm experiencing is that the text files that I'm importing don't use a continous and repitive naming convention. For example, let's say I have four different files that I'd like to import:
ABC.txt...
I'm a very inexperienced user when attempting to create macros within MS Access. Would anyone be able to point me to site which provides detailed instructions on how to create a macro?
Specifically, I'm trying to create a Macro in access that does the following:
1. Imports a text file into a...
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.