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...
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...
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?
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.
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
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...
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.
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.