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

    Excel - Border around page (not cells)

    Yea that was the only way I had figured it out also... Thank you!
  2. lenebene

    Excel - Border around page (not cells)

    I was wondering if there was a way to create a border around a page that does not involve using the cells... I hope this makes sense. Thanks!
  3. lenebene

    Excel - print workbook with page numbers on bottom

    I can't print out a workbook with all the page numbers... Can anyone tell me how to do this? Thanks!
  4. lenebene

    Leading zeros plus text

    Sorry. Yes it was excel! Thank you xlhelp. I was able to get yours to work... I must be brainless today because I couldn't get Skips to work.. :) Thanks again!
  5. lenebene

    Leading zeros plus text

    I am having a problem adding leading zeros to an account. Example: RTF-123 Should look like this - RTF-00123 RRR-12 Should look like this - RRR-00012 Any help would be greatly appreciated. Thanks!
  6. lenebene

    Subdatasheets

    I have 2 databases (roles & read only roles). The read only roles contains all the tables from roles (by linking) by in read only view. The problem we are having is one of the linked tables that has a subdatasheet (another table) in it won't appear in the read only roles with the...
  7. lenebene

    Subdatasheets & Linking of tables

    I have 2 databases (roles & read only roles). The read only roles contains all the tables from roles (by linking) by in read only view. The problem we are having is one of the linked tables that has a subdatasheet (another table) in it won't appear in the read only roles with the...
  8. lenebene

    Date & Leading Zeros

    oooo that will work. Thanks!
  9. lenebene

    Date & Leading Zeros

    This is a table thou... I don't want to create a query if I don't have to... is there another way to do this? Thanks! Charlene
  10. lenebene

    Date & Leading Zeros

    Hi! I have a table of 700,000 records. The date currently is formatted 5/25/1987. I need the date updated to look like this 05/25/1987. This needs to be done so that I can import it into Oracle. Thanks!
  11. lenebene

    Excel Count Question

    Nevermind the second answer worked!! Thank you!! Charlene
  12. lenebene

    Excel Count Question

    I pasted what you posted... you assumed everything right but I am only getting 1's??? Thanks! Charlene
  13. lenebene

    Excel Count Question

    I have a spreadsheet with the following: fa1234 6.2 fa1234 3.2 fa1234 2.5 fa1235 9.5 fa1236 1 fa1237 3 fa1237 6.3 I would like to count how many times an item appears in the first column... So it would look like this: fa1234 6.2 1 fa1234 3.2 2 fa1234 2.5 3 fa1235 9.5 1 fa1236 1 1 fa1237 3 1...
  14. lenebene

    Want to create Duplicate Query with memo field

    Hi! I am having a problem creating a Duplicate Query(one of the wizard queries) when I have a memo field. I have a memo field because when I imported the excel file into access the field was too big so access converted it to a memo field instead of a text file. If I convert the field to a...
  15. lenebene

    Creating a report that contains only the last 24 hrs

    I a trying to create a report from a table that only contains the last 24 hrs. The format of the date is "09/24/2002 9:01:50 AM". The table contains information from the past 5 months. Any ideas?

Part and Inventory Search

Back
Top