Recent content by R00K

Here is the last query which should give me a total. Sorry it took so long. SELECT tblNetNetBalance.CDate...

I am game for anything...will a union qery prevent the multiplication or compounding issue I am having? The query I have worked well until account types began to change and became more complicated. I then needed more queries to get the right data to show up in the final query which really...

Can you give me an example? Should I give up the query I have posted at the top in favor of a union query? I will try it. Cheers, David

qry2 SELECT Runningtotal.CDate, Sum(((Runningtotal!RunningSum*qryChangepercent2!GainPercent)-[BrokerbyAccount])) AS Gainbyaccount, Runningtotal!RunningSum*qryChangepercent2!IntPercent AS IntbyAccount, Runningtotal!RunningSum*qryChangepercent2!DivPercent AS DivbyAccount...

Sorry that was qry3. This is qry1. SELECT Runningtotal.CDate, Sum(((Runningtotal!RunningSum*qryChangepercent2!GainPercent)-[BrokerbyAccount])) AS Gainbyaccount, Runningtotal!RunningSum*qryChangepercent2!IntPercent AS IntbyAccount, Runningtotal!RunningSum*qryChangepercent2!DivPercent AS...

qry1 SELECT Runningtotal.CDate, Sum(((Runningtotal!RunningSum*qryChangepercent2!GainPercent)-[BrokerbyAccount])) AS Gainbyaccount, Runningtotal!RunningSum*qryChangepercent2!IntPercent AS IntbyAccount, Runningtotal!RunningSum*qryChangepercent2!DivPercent AS DivbyAccount...

I'm sorry. That is the initial data. The first query would show the data in the same format but only 40% of the totals for each column, plus a grand total for that day for the groupid1 only. So the second line would dissappear and the toals would be at 40% Date | blackbeans | favabeans |...

I used left joins on date. By the way, this is for a financial database and has been simplified and modified to preserve privacy. Data look like this: Date | blackbeans | favabeans | navybeans | groupid 010104 25 10 34 1 010104 10...

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 have been looking into this all morning and have this lead. The duplicate DC (server 2) which is the server that the second DFS root target is located on and which is cause the error above is unable to access the doamin security policy or the domain security settings. The second server does...

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

Here is the answer to my own question from Microsoft: • Simplified access to files and folders. DFS provides an intuitive way for users to access multiple file servers throughout your organization. File and folder replicas can even be made available across multiple sites to provide inexpensive...

Here's the answer to my own question from Microsoft: • Simplified access to files and folders. DFS provides an intuitive way for users to access multiple file servers throughout your organization. File and folder replicas can even be made available across multiple sites to provide inexpensive...

Thanks Faithless. Will DFS provide file security (ie. redundancy) or merely access to files on either server without the file being located on both servers? I would like to have to dynamic or sync'd copies of files/folders - one on each server. David

Try these links. For clients: http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/windowsserver2003/proddocs/entserver/sag_WINS_add_KBArticles.asp For Servers...