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

  • Users: SeeBee
  • Content: Threads
  • Order by date
  1. SeeBee

    Help with formula needed -

    I have voucher numbers and dollar amounts that are duplicating - in some instances, not all. How do I write a formula that would say: look at the voucher number and the dollar amount, if they are repeated, then delete/omit from grand totals for each field (Voucher, Dollar Amount). Thanks in...
  2. SeeBee

    using wildcards

    I have a Definition field that I only want certain records for: WALKUP/12345/LORIANE X1234 The 12345 number will vary, but rest of information will be the same. Would I use a 'like'? Not sure how I would write it - {Job History.Ship Via} = "W" and {Job History.UserDef01} like...
  3. SeeBee

    wildcards

    I have a Description file that I only want certain records for: WALKUP/12345/LORIANE X1234 The 12345 number will vary, but rest of information will be the same. Would I use a 'like'? Not sure how I would write it - {Job History.Ship Via} = "W" and {Job History.UserDef01} like...
  4. SeeBee

    Help - Problem exporting all data to Excel

    When I run my report in Crystal everything is fine. I end up with 83,188 records and 1,342 pages of data. I name the file and save it in Crystal. I click on the Export button. Select Excel 5.0 and Application. Report runs, but when I go into the Excel Temp file to look at the data, all the...
  5. SeeBee

    @MailSend problem

    Below is the formula I am using. When I 'test', I (being both UserName and one of the 'cc') the message gets sent to both 'cc' people, but not the UserName. Can anyone tell me what the problem may be? Thanks in advance. @MailSend(SendTo;@UserName:"John Doe": "Jane Doe&quot...
  6. SeeBee

    Urgent - Need formula help

    This is going to be a bit lengthy, but here goes. I have a an excel spreadsht that I am re-creating in Domino. It has a single field above the 'table' that asks the customer how many items they will be requesting, and the customer then specifies a number (1 thru 10). The table has 6 columns and...
  7. SeeBee

    Formula help needed

    I have created a form that looks just like an Excel spreadsheet. The form has 5 rows and 6 columns. Our customer will complete 1 to 5 rows & and the first & sixth cell of each row, depending on their request. If the first cell (in each row) is complete, then the sixth cell (of that same row)...
  8. SeeBee

    link my database

    is it possible for me to link my db form fields (only a few) with someone else's db - same form fields. And when they create a form, my db form is automatically created and populated with their information, and then I get a notification telling me this form has been created? Thanks in advance...
  9. SeeBee

    help needed for formula

    I have job numbers, some involving different 'tasks'. I am wanting to pick out only those job numbers with just task '13' associated. Some could have other tasks than just 13 (i.e. 41,10,12,13)-but I don't want these job number's. Can someone help me with a formula for this? If I used the...
  10. SeeBee

    Formula question

    Can someone break down this formula and tell me exactly what it means? Thanks in advance. @DbLookup("" : "NoCache"; @Subset(@DbName;1):"Corpapps\\Procpro.nsf"; "Categories"; category; "category1value")
  11. SeeBee

    Subreport links

    Here's what I want to accomplish, monthly. For April (lets call it April-1)I want to run a report on jobs closed, and the equipment used, and the total quantity for each piece of equip. Next I want to run another report (we'll call this one April-1b) using jobs that are still 'open', using the...
  12. SeeBee

    incorrect data being returned

    Still have problems with a record from year 2001 being returned in my report. I'm using a PC-style database ('tents') but manually linking the JobNo with Job Number. When I looked at the Links Option dialog box the Equal Join was grayed,indicating a left join. But as suggested I went into the...
  13. SeeBee

    incorrect data being returned

    I'm using two database tables (Job Detail (History) and Job History. I did a manual link using JobNo and Job Number from each database. Below is the code I am using: {Job Detail (History).Operation} = 301.00 and {Job History.Close Date} in date(2002, 02, 01) to date(2002, 02, 28) and {Job...
  14. SeeBee

    Subtotaling a subreport

    The problem crops up when there are no records in the subreport that correlate to the main report for a given group. The Shared Variable seems to retain the previous groups value and adds that to the present group in the main report. How can I get the Shared Variable to set itself to '0 or null'...

Part and Inventory Search

Back
Top