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 Chris Miller 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: DDPMF
  • Order by date
  1. DDPMF

    MS Project - Create Unique Group By Filter

    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...
  2. DDPMF

    Converting Signed Text Data to Currency

    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...
  3. DDPMF

    Converting a Combined Address to Standard Address Delivery fields

    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...
  4. DDPMF

    Create Calculate Field to establish Alternate Unique Identifier

    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...
  5. DDPMF

    Create Calculate Field to establish Alternate Unique Identifier

    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...
  6. DDPMF

    MS Excel - Calculate Average for Dates

    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...
  7. DDPMF

    MS Access Macros

    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...
  8. DDPMF

    MS Access Macros

    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...

Part and Inventory Search

Back
Top