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 TouchToneTommy 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: kat50
  • Order by date
  1. kat50

    How to import a txt file based on position

    How can I import a flat text file into a sql table SQL based on position? As an example Field Name Start Width Positions Column 1 1 6 1-6 Column 2 7 9 7-15 Column 3 16 9 16-24 Column 4 25 9 25-33 Ignore Column 5 33 4932 33-5286
  2. kat50

    How to total a Calculated Member

    Thank you so much, but I am afraid I do know know how to enter this formula. Do I do this within my Cross tab as a calculated member?
  3. kat50

    SQL Expression

    I believe that you can remove the line AND g.action_dt between '01-Jan-2009' AND '31-AUG-2009' from your SQL. Then create a parameter field for the start date and the end date. Then go to the seleciton expert choose records and new, choose the date field, you will then choose formula down...
  4. kat50

    How to total a Calculated Member

    I have created a calculated member based on my grand total (left) that I named Second Fee where I say if (GridValueAt (CurrentRowIndex,CurrentColumnIndex -1 ,CurrentSummaryIndex) >1 ) then 10 else 6 How can I get a total of this column("Second Fee")? When I right click on the summary it is...
  5. kat50

    TransferSpreadsheet Import access2002

    Thanks for the information. I ended up adding the excel commands under references http://support.microsoft.com/kb/198571 and using get file similar to: http://www.ozgrid.com/VBA/ExcelsDialogBoxes.htm Take care
  6. kat50

    TransferSpreadsheet Import access2002

    Can someone help me create the VB to import a spreadsheet the catch is I want to be able to choose the file and not have it defined. I only know how to use the macro feature to set up the transfer spreadsheet but that requires a sepcific file name be impoorted each time. Thanks a million!

Part and Inventory Search

Back
Top