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

    Version tracking software for Indesign

    Hi - my company has been using Creative Suite for several years and last year purchased CS5 only to find out that Version Cue was no longer included or supported. We then tabled the upgrade for a while. We are now needing to upgrade and I am having a difficult time finding something to replace...
  2. ReineM

    Upgrading from CS to CS3

    I've recently upgraded from Creative Suite to CS3. The problem is that my Version Cue files from CS will not import into CS3. I can import the current version of my files, but not the version data from the last 4 years. Adobe support tells me it is not possible to import files from CS to CS3...
  3. ReineM

    Using a "range" with Vlookup

    Thanks Ken....do I need to use "<=" (less than or equal to) if I am not specifying the range?
  4. ReineM

    Using a &quot;range&quot; with Vlookup

    I need to return a bonus amount based on what a saleperson sold a product for. I can't get it to work with an IF statement...I think there are too many variables. I'm not sure how to make this work with VLOOKUP either because my list is a range: Sales Bonus $1.00-5.00 $0...
  5. ReineM

    Pivot Table % on subtotals

    Gavona - no, that doesn't work either, it still gives me a percent of grand total. SKip - I never did figure out what I was doing wrong, however, when I created a new pivot table after doing insert/name/define, it works perfectly! Thanks, everyone, for your help. If you run across a solution...
  6. ReineM

    Pivot Table % on subtotals

    Hi skip, Thanks for the refresh tip! I can see that that part is working. BUT...I cannot seem to make the OFFSET function work in either VBA or Insert-Name-Define. When I use the latter it seems to be working because when I click in the formula I can see that it is highlighting the correct...
  7. ReineM

    Pivot Table % on subtotals

    Hello...the following pivot table works great for one month but now I want to add data each month. I need to see all months on the same report for comparison. The problem is that when I have more than one month the % of total is based on grand total rather each months totals. Is there a way...
  8. ReineM

    Hi..I have created an &quot;Add new Reco

    Thanks...that helped me track down the problem. My form was set to a query. The join type was incorrect between the tables in my query...as soon as I changed that all records showed up in the form and the Add New Patient button works. I appreciate your help!
  9. ReineM

    Hi..I have created an &quot;Add new Reco

    Hi..I have created an &quot;Add new Record&quot; command button on a form and it doesn't work. It adds the records to the table, but they do not show up in the form view after I close and restart Access. They will not come up on a record search in the form either. I can, however, add a new...
  10. ReineM

    Counting items in a column

    Thank you so much Bob! I see now what I was doing wrong....this will help me with other things as well. I appreciate your time! Reine
  11. ReineM

    Counting items in a column

    Hi..I have a query that returns negative and positive numbers -11 through 11. I want to count the number of 1's, -1's, 2's, -2's, etc. in the column (including 0's). So if my column was: 0 -3 1 0 5 -3 0 The result I am looking for is the total for each: 0 (3) -3 (2) 1 (1) 5 (1) I...

Part and Inventory Search

Back
Top