Recent content by leewisener

I use VNC currently to see what the kids are up to, but it runs very slow. Will have a look at pcanywhere. Thanks Lee

Not sure if this will make sense but here goes. I have a network throughout my home, pc's access the internet and printers via a netgear router, it works great, I have just upgraded one of the kids pc's and now I have a Pentium 3.2Ghhz, 512mb ram, etc.. spare, that I would like to be able to...

I solved it eventually and got exactly what I require by doing this. I changed things about a bit that actually will help with other things in the future. SELECT [Start Date].Collector, [Start Date].Start, Current.Current, [Start]-[Current] AS Movement, [Movement]/[Start]*100 AS [% Collected]...

Geeting an error at the bold point below SELECT data.[Date], data.[Current Collector], Sum(data.[Arrears Amount]) AS [SumOfArrears Amount], b.[Paid This Month] As [SumOfPaid] FROM data INNER JOIN (SELECT [Current Collector], Sum([Paid This Month]) FROM data WHERE [Date] = #8/4/2006#) As...

Yes, thats right but I cant figure it out in the query, I can get various results where I create the query but none that give the right figures.

It would be: SELECT data.[Date], data.[Current Collector], Sum(data.[Paid This Month]) AS [SumOfPaid This Month] FROM data WHERE Data.[Date] = date() GROUP BY data.Date, data.[Current Collector]; Easy enough as two queries, but getting the info from 1 query is the challenge. Just looking...

for example: Date Collector SumOfArrears SumOfPaid 03/08/06 Agent1 579603.74 28755.85 03/08/06 Agent2 669152.28 26773.84 03/08/06 Agent3 823692.36 45458.18 03/08/06 Agent4 569671.02 10905.02 03/08/06 Agent5 326419.56 45422.96 03/08/06 Agent6 639465.39 21336.66 That is the output to get...

Yes. Every day a a download comes to me in the form of an excel spreadsheet which I upload. Many rows will be identical, the only difference being the date in the first column. If someone pays then obviously the date paid, arrears amount and possibly the Months in arrears will change.

This generates the main part, names, amount due at the beginning of the month and amount paid so far, really I want the amount paid so far to be using the figures from 04/08/06 SELECT data.Date, data.[Current Collector], Sum(data.[Arrears Amount]) AS [SumOfArrears Amount], Sum(data.[Paid This...

I have all my data in 1 table, it contains account that are in arrears with their payments. Every day about 6,000 records are updated into the table so we can compare movemements from day to day. What I want to do is produce a query that takes the position of all cases allocated to each...

Ok, thanks

Hi, I have a database that I want to export from, now everything is setup absolutely fine but when people are using the database one particular field has a dropdown menu and 6 options to select from. When I export that data I want to excel, it would very useful to us once you open excel to...

Great, thanks. The nav form had Moda set to yes.

I have created a database with several forms and so far so good, When the database opens it shows a navigation menu which allow other forms to open. When forms open they simply open on top of the navigation form for viewing. However the new form I have created although works fine will only...

I want to create a form with an initial data source provided then for example list how many accounts were outstanding today, yesterday and so on.... Each day's data is in a seperate table, I thought about simply adding the data from each day to 1 table but then thought,no leave it as multiple...