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. drussum

    disk mirroring in NT 4.0

    I added a new drive to my one drive in an nt 4 server. So now I have two drives on a single ide cable master and slave. I can see both drives in disk administrator and have set the partitions to be the same and hold the control key down to select the partitions then select mirror and the option...
  2. drussum

    How do you get two routers on a network at the same time?

    Thanks for the help. I will look into the repeater as well.
  3. drussum

    How do you get two routers on a network at the same time?

    I have a LAN, ATTBI cable modem in one office with a router that is dhcp on the lan and wan side. I then am trying to set up another network in another adjacent building. I have a linksys cable dsl router and a hub in that building. I am not sure which port to use, uplink,wan. I am connected and...
  4. drussum

    What would the best way be to upgrade Windows 98 to windows 2000?

    I have the Windows 2000 Profesional CD that is the full version not the upgrade edition. Will it give me an option to upgrade or replace the current 98 OS?
  5. drussum

    What would the best way be to upgrade Windows 98 to windows 2000?

    I have to upgrade several computers that are currently running windows 98 to windows 2000 pro. They dont want to loose their data and have some programs that are dos based. I have to be very careful not to loose any data so a long fix would be acceptable. Thanks.
  6. drussum

    NZ functions

    Scratch the last qestion, Is there a way to have the "-" minus sign show up with in the ()parenthesis?
  7. drussum

    NZ functions

    Thanks, I am not getting the error anymore. What would the syntax look like if I were using 4 fields to add instead of the two?
  8. drussum

    NZ functions

    it says "invalid Syntax". There could be negative numbers. in the variance field. How do I get the - sign to show up? (Negative sign)in the colmn with the dollar sign -$100.00
  9. drussum

    NZ functions

    Thanks for the suggestion, however the database is an oracle and I dont have the ability to do that. I have to make do with access.
  10. drussum

    NZ functions

    I have two fields that I am subtracting to equal another field. sometimes one of the two fields will not have any dollar value. What is the syntax for that? both fields are formated for $$ example: [actual$]-[budget$]= [variance$] I am currently using: Variance: NZ([actual]-[Budget])and I am...
  11. drussum

    How do I get all the records?

    How do I get all the records from two qry's not just those that are equal or those that match in one and then leave those that dont match in another? I am trying to get all the records and will filter them later. Thanks.
  12. drussum

    What is the sql script to have dates sum as quarterly?

    tlbroadbent I sent you an email with a better explanation and a sample qry that I have been using.
  13. drussum

    What is the sql script to have dates sum as quarterly?

    it starts with an oracle table that stores accounting information with [cost center] [Year] and then the months [January] [feb] [Mar] and so on. The cost center is either a "1" or a "2". so the current qry shows like this: all the records sorted by "1" and then...
  14. drussum

    What is the sql script to have dates sum as quarterly?

    the union qry I have is returning both "1" and "2" records in the [cost center] field. what I need is the "1"s in one field and the "2"s in another field. I am sorry if this is not a clear explanation. I will try again if this doesnt work. Thanks again for...
  15. drussum

    What is the sql script to have dates sum as quarterly?

    what is the select statement to specify which field and the specific value in that field? for example: I have a field called [CostCenter]and it has either one of two values it is always either a "1" or a "2" never both and never empty. I am trying to use the union qry above...

Part and Inventory Search

Back
Top