Search results for query: *

I have a query that sums 3 other similar queries that sum slightly different data. qry1 sums 40% of totalbeans of group 1 qry2 sums 60% of totalbeans of group 2 qry3 sums 100% of totalbeans of group3, group4 and group5 All are ordered by date and each query uses the same data but uses a...

I get this error while creating a second DFS root target: "Unable to update the password. The value provided as the current password is incorrect." The second target is on another server on the network. I am hoping to set up replication, but this error is stopping that cold. Any help on this...

I am lost on this. Any help greatly appreciated. I want to duplicate the fileshare on our primary server to our secondary server which will also have a file server roll. The point is to have redundancy in case of a failure. The servers will also be geographically far apart. Thanks, David

As soon as clients connect to the server via ip based vpn, they are cut off from outside internet access (ie. msn messenger, email, internet browsing). What do I have to do to fix this? The server is behind a router(ports configured for vpn), runs MS Server 2003...all clients have xp pro...

I have a primary server (File server, Remote Access/VPN Server, Domain Controller(active Directory), and DNS Server) and a second server that currently serves no purpose. I would like the second server to be a back up server in case something happens to the primamry server. Both machines have...

We have 2 servers with MS Server 2003 standard. One server is being shipped overseas. A second server will remain local. The first server (hq) is the main server (fileserver, domain controller, vpn, etc) and the second server (local) should be a local copy for redundancy. How do I set this...

We are using MS Server 2003 and have a domain that was working great(it may still be working). The boss is leaving the country for a few days and wants to connect remotely. I set up a vpn that allows ip-based remote access. That functions. In getting that up, somehow no one on the network...

I am interested in hearing your stories. I am killing myself building an app that tracks the fund and the value of each clients share in that fund, commission of sales people, fees, profits, you name it. It's been 1 step forward, 2 steps back. Cheers, David

I have a database that keeps track of several "bank" accounts and the total value of all deposits - withdrawals. All the accounts combined equal the pot. The post grows and shrinks according to how the post is invested (kinda like a fund). In turn the indivual accounts grow or...

Here is my issue: Date B1 B2 B3 What I Want 1/1/02 100 5 105 105 1/2/02 100 3 103 108 1/3/02 100 0 100 108 1/4/02 250 -10 240 348 B1 is a running total of A1-A2 B2 is another number B3 should be the previous day's balance plus...

I am getting this error: You tried to execute a query that does not include the specified expression "BalanceDate" as part of an aggregate function. (Error 3122) On this code: SELECT RunningBalance.BalanceDate, Sum(Nz(Transactions!Deposit,0)-Nz(Transactions!Withdrawal,0)) AS DepWith...

Hi all, I have a 3 tables that each contain a date field. Each table has only the dates it needs(ie. Table 1 has 4 dates because it contains 4 records). Other tables have more records and therefore more dates - almost daily. All tables are related by date. When I run my query, I get 155...

There doesn't seem to be section devoted to Data Access Pages. Does anyone use them? I am considering building a web app with d.a.p.s but there seems to be little out there as far as tutorials and faq. Any direction is appreciated. Thank you in advance.

Good morning, I have several queries that give various values. I wish to find the sum of all the queries ordered by date. Here is a sample: SELECT ControlDates.BalanceDate, Sum(Deposit-Withdrawal) As Balance FROM Transactions, ControlDates WHERE TransDate<=BalanceDate GROUP BY...

Thanks to tek-tips I can now do a running total in a query. Now I need a second running total that displays the previous day. Here is the code for the running total. SELECT ControlDates.BalanceDate, Sum(Deposit-Withdrawal) FROM Transactions, ControlDates WHERE TransDate<=BalanceDate GROUP...

I'm creating a complicated form that will function like a portal to all of our data. It will allow input and should update fields to give running totals, etc. What I need is to be pointed toward some tutorials and/books so that I can learn this stuff. Some of the background work is done...