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 Mike Lewis 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. JStrittmatter

    Neighborhood Hot Spot

    I have a neighbor with a unsecure wireless router. I can get on the net using his connection. What if any legal ramifications are there for doing this?
  2. JStrittmatter

    VPN access

    I have a PIX 515(192.168.0.0) to PIX 506(192.168.2.0) VPN Tunnel. I also have VPN softare clients(192.168.254.0) that access the PIX 515. I want those that use the software clients to acces the PIX 506(192.168.2.0) network. Can someone point me in the right direction on how to do this...
  3. JStrittmatter

    HP LJ2100 Printing outlined gray

    I have an HP LJ 2100 that prints everything outlined with a gray shading inside. Any thoughts on what this might be.
  4. JStrittmatter

    Record Sorting

    Rosemary You are wonderful. I did screw up the signs thanks a million for your help on this it works like a charm.
  5. JStrittmatter

    Record Sorting

    Now they have changed everything on me. They want to go by percentage of the number consumers. The break down is as follows: > 30 print them all between 30 and 100 print 25% < 100 print 10% Any help you can give me would be wonderful.
  6. JStrittmatter

    Record Sorting

    I am using CR 9 SQL Database We are sending out surveys for services the we provide. Some services have more consumers than others and we want to be able to pick out just a sampling of these people. We need mailing labels for the people we are sending these surveys to. I hope this is a...
  7. JStrittmatter

    Record Sorting

    I want to be able to select every record if the number of records is < 50 and then select every other record if the record number is < 100 so I can print mailing labels.
  8. JStrittmatter

    Different reports based on Selection from List

    Yes you are correct. I have 12 reports one for each month and they have completely different wording. I thought there might be some VB that could be written for a command button when you click on the button to do what I have in the original question. I know that I could do a huge if statement...
  9. JStrittmatter

    Different reports based on Selection from List

    I want to have a different report open based on the month selected from a combo box. I am not that great with VB. I envision something like this: if Combo 2 = "April" then open April_Report else if Combo 2 = "May" then open May Report else etc.... Anyones help would be greatly appreciated...
  10. JStrittmatter

    Combine Two Queries

    Thanks For your help I guess I was just unsure of myself it seems to be working wonderfully Thanks a million Jusitn
  11. JStrittmatter

    Combine Two Queries

    I have 2 queries one sums the total cost of services vended to a consumer by service the other sums the total receivibles for a consumer by service. I want to create one query that will show me for each consumer that will show me the sum of service and the sum of receivibles by service...
  12. JStrittmatter

    Previewing report help

    PGTEK Do you have any tips on how to speed up a report? thanks
  13. JStrittmatter

    Billing Database Help

    Thanks Leslie [2thumbsup] You pointed me in the right direction and I was able to tweak it from there.
  14. JStrittmatter

    Billing Database Help

    The missing keyword is Month
  15. JStrittmatter

    Billing Database Help

    I have a billing database. I have a consumer table consumer service table and a receivable table. There is a date field in both consumer service andreceivable tables both dates are formatted 3/15/2004. What I am trying to do is a query to give me a list of those consumer who do not have...
  16. JStrittmatter

    Color every other group of 3 lines in the detail section

    Mike, Thanks a lot It worked wonderfully!!![thumbsup2] Justin
  17. JStrittmatter

    Color every other group of 3 lines in the detail section

    I am using CR9 I want to be able to color every other group of 3 lines in the detail section. I know that there has to be a formula out there that can help me with this. Please see the example. line 1 line 2 line 3 line 4 line 5 line 6 line 7 line 8 line 9
  18. JStrittmatter

    unduplicated count

    I know SQL is a language. I am using Microsoft SQL Server 2000. If anyone could help with the SQL code that would be great. I appreciate everyones help.
  19. JStrittmatter

    unduplicated count

    I have a SQL database. There is a service delivery table which holds all data about which services were delivered to which consumers and the number of units to go along with it. It records service delivery on a monthly basis e.g. 07/2003 the month and year are seperate fields {Service_Month}...
  20. JStrittmatter

    unduplicated count

    I know I need to split the previous month services and the current month services and then compare them. and count those that do not match. i am not that great of a programer so any help would work greatly. I am fairly good with crystal just not the programming structure needed.

Part and Inventory Search

Back
Top