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 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.
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.
I Have one qry sorting records by the number "1".
I have a second qry sorting records by "2".
I have a third qry that is a "Left Join" (all records from qry 1 and those matching in qry2)
I have a forth qry that is a "right Join" (all records from qry 2...
I have a field I am trying to get qtrly summary. The field is[back order} which is the result of an expresion of [ordered quantity]-[Delivered Quantity]. I am trying to take the result and sum it quarterly. The date field I am using to do this is: [Plan Del Date] this field is storing the dates...
If I have a date that is stored in short date format, 02/10/02 for a field called [Plan Del Date] and I have another field that is called [Back Order]. How do I get a return that has quarterly summaries along the top, like Qtr1, Qtr2, Qtr3, Qtr4, and then below would show the number of items on...
Following is a question I posted earlier. If there is anyone who can help I would really appreciate it.
I am creating a crosstab qry that uses the following fields: [ItemNumber] [ItemDesc] for row headers. Then Column Header: [Plan Del Date] and sum by [Back Order]. The [Item number] is...
Ok, here we go, I have one field minus one field equals another, More specific: [Ordered Quan]-[Delevered Quan]= [Back Order]. The problem I am running into is that when I have two minuses for example, "[Ordered quan]" is minus one and "[Delevered Quan]" is minus one, then...
I Have am writing a program that is designed to give me the number of units on back log. The problem i am having is that I am pulling the information from an oracle database using access 97. The [plan del date] is storing the date in a short date format " 02/12/02" I am using the...
I have a qry that is summing months to come up with a quarterly summary example: 1st Quarter Total Actual: Sum([qryRectActBud1].[T$AMNT$1]+[qryRectActBud1].[T$AMNT$2]+[qryRectActBud1].[T$AMNT$3])
This qry was working last year when we had a full year of data. Now that this is Feb I am getting...
I have a table that is storing dates in short date format. I need to write a qry that will display the results (Number of units in back log) By month. so the column headings will read Jan through Dec. Any help Ideas or resources would really be appreciated. I am an entry level programmer (Just...
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.