Thanks. With a bit of tweaking, it works perfectly - the code is here:
SELECT MasterTable.OPERATIVE, MasterTable.DATE, MasterTable.OPERATION, MasterTable.SITE, MasterTable.PLOT, Sum(MasterTable.VALUE) AS Total
FROM MasterTable
GROUP BY MasterTable.OPERATIVE, MasterTable.DATE...
Hello,
I have a master table containing data - I need to process that data so that it does the following:
I need Access to find all rows where 'date', 'operation', 'site', 'plot' are the same, then add 'value' and 'hours' together and give me the information in a report.
Can anyone help me...
Because I am replacing the Wyse 60 terminals with Windows XP machines, and the only truly free WY60 emulator is a GNU prog which will compile under Cygwin.
Thanks,
Tom
Hello,
I am trying to use Cygwin to access a getty which is available via a RS232 / Serial / COM port from an old UNIX server.
I have not got the first idea on how to achieve this and would be happy as a pig in s@'t if any one of you fine fellows would be able to help me out with this.
Many...
Hi,
We have 2 lans set up at the office... one works with an old SCO (eugh) system:
client ip addresses: 6.0.0.11 and up
server ip address: 6.0.0.10
We also have a seperate windows network:
192.168.1.1 - internet gateway
192.168.1.2 and up are all client machines.
The subnets for both of...
The file that the cut command reads is recognised by "file" as a binary file. It contains characters which "break my pipe". The file contains characters (inc. control ones) which look messy and cannot be displayed with the path name.
The reason I'm doing this is to provide a...
Not entirely... the array that you are asking me to cut is a path to a file. If I echo the array content, it just cuts out the path, not the content of the file.
I also need to get issue 2 sorted, so please, if anyone can help I'd really appreciate that.
Cheers!
Tom J
Hi,
I have an unexpected bash scripting problem.
I'm writing a script in bash which finds files named SETUP.DTA. The prog. searches through a fs, and produces a list of their locations.
I assign an array variable to the first few letters in the file and then get the program to spit out the...
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.