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 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: *

  1. monnet

    convert excel formula to excel pivot table formula

    good idea i think that will work.... Thnks
  2. monnet

    convert excel formula to excel pivot table formula

    Hi everyone, I have a excel spreadsheet that contains information on website "hits" (and other various statistics)I created a forumula that shows the hits per business day. Formula is as follows: 'Hits'/(networkdays(Today(),'Website Start date') How can a translate that formula into an...
  3. monnet

    Simon desktopview for SECC 4.2

    Hi all This question is directed to all Symposium Express 4.2 users. Our company purchased SECC 4.2 in the summer of 2006. Recently, it has come to my knowledge that during some point of SECC 4.2's shelf-life a Symon real time display application (a third party add on program similar to the...
  4. monnet

    SQL query problem

    Thanks for the Help guys, the DISTINCT command worked prefectly! BM
  5. monnet

    SQL query problem

    Ok so here is a very simplified version of the table I am using: SSN ADDRESS FundCompany 1. 777-77-7777 1 Smith St Company A 2. 777-77-7777 1 Smith St Company B 3. 777-77-7777 1 Smith St Company B 4. 888-88-8888 2 Water St Company A 5. 888-88-8888 2 Water St Company D I need a query...
  6. monnet

    Problems Creating a Custom Call by Call report in Crystal

    Hey everyone, I need help creating a custom call by call report in crystal. One thing that I can’t figure out is how to configure crystal or symposium to pull from a different view each day. For example today’s table/view that crystal would view would be called "ecallbycallstat20070522..."...
  7. monnet

    Creating outlook tasks within access

    Hello everyone, I’m looking to create a VB code within access to open a new task assignment within outlook. I want it to populate the task body text section with items from an access query (similar to a Mail merge in word). For each line of the query I would like a new task to be created...
  8. monnet

    Acces to Word Mail Merge Problem

    pseale, The using a table as my source for the query did not solve the problem, still see the enter parameter screen in access. While i am failry strong in SQL, I am not the best VB programmer, but I will try the VB approach... thank you very much for the help!
  9. monnet

    Acces to Word Mail Merge Problem

    Currently I have a database using MS access that populates multiple letters via the MS word mail merge tool from a query in access. Each day the query (date) needs to be by an end-user. So I created a form and linked it to the query ([Forms]![Date filter table]![Date]). However, when I do...

Part and Inventory Search

Back
Top