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!

Register Log in
  • Congratulations derfloh 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: *

  1. discskyer

    Date Parameter

    Thanks again LB! Looks like I've got the report running properly now.
  2. discskyer

    Date Parameter

    Thank you again for your help LB. What I'm trying to accomplish is to let the user decide on either a single date or range of dates. Through the setup of the parameter, the user has the option to enter either a discrete value or a range value. Granted, the user could add both, but I don't...
  3. discskyer

    Date Parameter

    Thanks LB, will this also work for the range of dates option as well?
  4. discskyer

    Date Parameter

    Hello, I know how to display multiple records for string parameters using the join({?param}, ",") function, but how do you do this for dates? Thanks!
  5. discskyer

    Keeping leading 0s when combining fields

    Oops, forgot to mention that I'm using Excel 2000. Currently, I have broken up the cells by using the year(), day(), and month() functions and formatting the cells to show two numbers for day and month. Thanks!
  6. discskyer

    Keeping leading 0s when combining fields

    Hello, I am having a problem keeping the leading 0s in my fields when combining multiple fields. Basically, I am formatting the date to look like yyyyddmm, but it always cuts out leading 0s for the day and month. So instead of getting 20040305, I am getting 200435. Can anyone help with that...
  7. discskyer

    Autofill of duplicate values?

    Oh dear god, how did I miss that? Thank you so much!
  8. discskyer

    Autofill of duplicate values?

    Hello, I am trying to autofill an excel spreadsheet using the following format: 1 1 2 2 3 3 4 4 etc. Everytime I enter in those values and then try to drag down to run the autofill, it doesn't pull whole numbers. Eventually it starts to triple up on some numbers (ie. 4.987, 5.013, 5.432 all...
  9. discskyer

    Linking to GL

    I'm trying to add the AR and IC module to Pro Series 7.2 for a client of mine, and I keep getting an error that I've never seen before. When I click on the link to GL button and enter in their company number, the error "GL Chart of accounts has not been set up for this company." pops up, and I...
  10. discskyer

    Message Master Error

    I have a client that is using ACCPAC Pro Series 6.0 with Message Master installed as well. Last night they started receiving an error message saying "File access is denied" I asked him if they had recently changed anything within their IT infrastructure or if they had upgraded their Adobe...
  11. discskyer

    Creating a sum of a running total?

    Thanks for the help LB. I ended up working it a slightly different way. With those values, I ended up tweaking the formula used to derive the sum and used that in my calculations.
  12. discskyer

    Creating a sum of a running total?

    Is this possible or can I go about it some other way? Here is my situation... I have a running total of a field called @AmountApplied. That runnnigtotal is being subtracted from an invoice amount so that we can display an actual balance per transaction. At the end of that section, I need to...
  13. discskyer

    Creating multiple arrays?

    I figured that might be the case, and I apologize for being so vague about it. Basically, I have a report that contains information sorted by vendor regarding invoices and credits to those invoices. However, in the main report, the invoices and credits are both stored in the same field of the...
  14. discskyer

    Creating multiple arrays?

    I was trying to set up an array to capture 4 different values per entry (reference, invoice, applydate, and amount). I then needed to have these records printed up in the subreport sorted by the overall Invoice number. Does anyone have an idea as to how I might go about doing this? Thanks!

Part and Inventory Search

Back
Top