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

    Multiple Criteria

    It's just a standard Find Duplicates query at this point, which does pull in the data wanted, but then some, as invoices can have several entries of pending, and none with paid. So I just want to see those that have multiple entries, and where at least one of them are paid for the status SELECT...
  2. bdjb

    Multiple Criteria

    Hello, I have an Access find duplicates query, that part works fine. It pulls in invoices that can be entered multiple times... once with Processing, Payment Processing or Paid as a status. How can I set the query to only pull in Duplicates for the Invoice field, and those that also have paid or...
  3. bdjb

    User Level Security

    Hello, The security method can be used with newer versions as long as you don't upgrade the old DB. Yes, we use the shortcut method to reference the workgroup. We have added the user to the Admins group, but it doesn't seem to do anything.
  4. bdjb

    User Level Security

    We hacve an access DB that was created in '97, but are currently using 2010. The user level security wizard was used to lock down the DB, but the person who did it is on extended medical leave. We used the User and Group permissions wizrd to add a new user, and is seems to complete, but that...
  5. bdjb

    Cross Tab ignores Selection Criteria

    Thanks LB, I have a listing of Clients for the rows, then count of files by Office and state Chicago Cinci IL IN OH Client1 15 3 5 Client2 7 1 4 Client3 12 12 5 Client4 8 3 22 The group...
  6. bdjb

    Cross Tab ignores Selection Criteria

    OK. so group selection formulas are ignored by the crosstab?
  7. bdjb

    Cross Tab ignores Selection Criteria

    Thanks for the reply, I'm not suppressing anything in the details, only using the select statements. If I select only OH files in my selection statement, I get just OH, but in the cross tab, I'll get all states if that makes sense?
  8. bdjb

    Cross Tab ignores Selection Criteria

    How can I create a cross tab in Crystal 11 that won't ignore the overall Selection Criteria? When run, the detail data is correct, but the Cross Tab pulls in everything thanks in advance
  9. bdjb

    Excel 2007 - Cleaning Bloated Workbook

    Sorry, On .Rows(sRow & ":" & sMaxRows).Delete
  10. bdjb

    Excel 2007 - Cleaning Bloated Workbook

    Hi Skip, I get an error "Run-Time error '13" Type Mismatch" on your code. I'm running Office 2003. Any ideas? Thanks Bob
  11. bdjb

    Pull data by Date

    Thank you, that gave me the answer I needed. When run anytime during the current month, it will give the next full month plus 14 days {TODOAPPT.StartDtAct} In dateadd("M",1, minimum(MonthToDate)) to dateadd("M",2, minimum(MonthToDate)) + 14
  12. bdjb

    Pull data by Date

    I am pulling data based upon a date field, now they would like the next full month, plus 14 days (so basically a month and a half). Any pointers on how to do that based upon a date field? Thanks in advance!
  13. bdjb

    Crosstab question

    Hello, The {@investor type} formula just identifies a particular field from the DB. We're pulling data based upon a particular investor (FHLMC). Fileds in the main report are the CLient, Office Name, and file numbers that the crosstab should be counting. The crosstab is located in the group footer
  14. bdjb

    Crosstab question

    Hi LB, Yes, you are right, I do have a group selection formuls. I didn't realize the crosstab processed earlier. Row = Client Name Column = Office.FirstName Summary = Count of Entities.EntityID Group Selction = Maximum ({@Investor_Type}, {Entities.EntityID}) in ["FHLMC"] Thank you very much
  15. bdjb

    Crosstab question

    I have a report, the records shown in the detail section are being limited by the selection formulas, but the crosstab seems to pull in all data, there are records in the crosstab that aren't in the details area. Any ideas of why this might be?
  16. bdjb

    Report run time

    Thank you, I will try your suggestion, and check out the perfomance info
  17. bdjb

    Report run time

    Is there a way to put a formula on the report that will give how long the report took to finish? I'm trying a few methods to speed up my reports, but need a method to verify the changes. Thanks in advance
  18. bdjb

    Show message

    Is there a way in SQL to show the end user a message as parts of the SQL script complete? I'm using WinSQL if it helps.... Thanks in advance
  19. bdjb

    Unable to manually link tables

    Hello, I'm using CR XI SP2, as I tried to create a new report today, I am unable to manually link keys in tables. It will do the auto link, but I need to drag and drop links. It worked yesterday... I've uninstalled and re-installed, still same issue. Thanks in advance Bob
  20. bdjb

    Office 2003 always asks to save

    Hello, We're using Office 2003, excel, word etc always ask me if I want to save the current copy when I close, even if I have not made any changes. This even happens on a document that I have previously opened and saved. Any way to turn that off? Thanks in advance

Part and Inventory Search

Back
Top