Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. pdupreez

    How can I relate a table with a itself but with an offset

    Yes Sir
  2. pdupreez

    How can I relate a table with a itself but with an offset

    With the help of a colleague I found the solution: SELECT NoNameTable.ProductionCODE, NoNameTable.Year, NoNameTable.Month, Val(Nz( SELECT Top 1 ClosingStock FROM NoNameTable N WHERE DateSerial(N.Year,N.Month,1)<DateSerial(NoNameTable.Year,NoNameTable.Month,1) AND...
  3. pdupreez

    How can I relate a table with a itself but with an offset

    I have progressed a little, in that if I include the other fields in my sort code, I get an answer, not the right answer always, but something at least. The code now looks as follow: SELECT NoNameTable.ProductionCODE, NoNameTable.Year, NoNameTable.Month, Val(Nz((SELECT Top 1 ClosingStock FROM...
  4. pdupreez

    How can I relate a table with a itself but with an offset

    Having worked through some Google results for the error code given, I understand now that we are talking about subqueries, and that the error is caused by the subquery returning multiple records even though Top 1 is included. The table contains data for many product types, in different budget...
  5. pdupreez

    How can I relate a table with a itself but with an offset

    Thank you very much Duane, for a noob like me that is an awesome looking query, and exactly the direction I am looking to go. I will look into the detail of what it does to ensure I understand how it works. I get no major errors when executing that query, but end up with no data (#name? in all...
  6. pdupreez

    How can I relate a table with a itself but with an offset

    I do not know if my question is clear enough, so please bear with me: I have a table with the following fields of information: Year[tab]Month[tab]ClosingStock 2009[tab]1[tab][tab][tab]1000 2009[tab]2[tab][tab][tab]1500 I want to calculate what was produced, and that is done by subtracting the...
  7. pdupreez

    Perl - Google Reader

    Thanks for the input. I have only started using Perl and Ruby in the last few days, and I am learning a lot. You are right, I can run Perl outside of Cygwin, which is nice to know. Time to go fix the path!
  8. pdupreez

    Perl - Google Reader

    Just shopping around. But no, seriously there is no need to convert, I just know this is a Perl forum, if people want to have it in Perl. It works great in Ruby, which in the Windows environment seems to have less overheads (no Cygwin)and integrates better into Scite in any case.
  9. pdupreez

    Lotus Notes - Detach and Save Mail Attachments

    ...=~s/Tr\://gi; while($Cleaned_Subject =~ s/[^A-z0-9\$%'`\-\@{}~!#()&_^ ]/\-/g) { ; } $Cleaned_Subject =~ s/^\s*//; $Cleaned_Subject =~ s/\s*$//; $Cleaned_Subject =~ s/\\//; $Cleaned_Subject =~ s/\s+/\-/g; my $subdir = $Cleaned_Subject; $subdir =~...
  10. pdupreez

    Perl - Google Reader

    Thanks Kevin for responding. That did not give me what I was looking for but further searching on Google did the trick. I had to mash a number of different scripts together, but can now efficiently process hundreds of Google Starred links and dump the selected links to a text file for further...
  11. pdupreez

    Any easy way to export many attachments/emails?

    ...=~s/Tr\://gi; while($Cleaned_Subject =~ s/[^A-z0-9\$%'`\-\@{}~!#()&_^ ]/\-/g) { ; } $Cleaned_Subject =~ s/^\s*//; $Cleaned_Subject =~ s/\s*$//; $Cleaned_Subject =~ s/\\//; $Cleaned_Subject =~ s/\s+/\-/g; my $subdir = $Cleaned_Subject; $subdir =~...
  12. pdupreez

    Perl - Google Reader

    I use Google Reader (RSS aggregator?) a lot to capture interesting links and store them as "starred" for later processing. What I am looking for is a way to get all the links in the starred items, create a new html page (if necessary), spider through all the links within that new page and...
  13. pdupreez

    Move System partition after OS install on new disk

    This is interesting, but there are times when having your XP on the "wrong drive", i.e. not Drive C could cause problems. Some software does not use the correct method to address the system disk path, and have it hardcoded. It will therefore look for c:\program files\etc when the actual install...
  14. pdupreez

    Any easy way to export many attachments/emails?

    ...= $doc->{Subject}->[0]; while($Cleaned_Subject =~ s/[^A-z0-9\$%'`\-\@{}~!#()&_^ ]/\-/g) { ; } $Cleaned_Subject =~ s/^\s*//; $Cleaned_Subject =~ s/\s*$//; $Cleaned_Subject =~ s/\\//; $Cleaned_Subject =~ s/\s+/\-/g; my $subdir = $Cleaned_Subject; $subdir =~...
  15. pdupreez

    Lotus Notes - Detach and Save Mail Attachments

    ...= $doc->{Subject}->[0]; while($Cleaned_Subject =~ s/[^A-z0-9\$%'`\-\@{}~!#()&_^ ]/\-/g) { ; } $Cleaned_Subject =~ s/^\s*//; $Cleaned_Subject =~ s/\s*$//; $Cleaned_Subject =~ s/\\//; $Cleaned_Subject =~ s/\s+/\-/g; my $subdir = $Cleaned_Subject; $subdir =~...
  16. pdupreez

    ABB Freelance

    Thanks for responding. The Freelance systems we have were originally manufactured by Hartmann&Braun who was later taken over by ABB. The system operates at DCS level on 5Mb/s Ethernet on a protocol I believe called ControlNet. I have limited information beyound that at present, but does know...
  17. pdupreez

    ABB Freelance

    Does anyone have any ideas on how we can integrate data from a Freelance PLC (1996 vintage) to inSQL?
  18. pdupreez

    User File Directory Settings

    I always partition my HD into c: and D: and place all my user documents in the D: drive. However Windows insists on c:\Documents and Settings\... for all users. This includes the My faxes, documents, pictures etc. How do I ensure that it never looks in the c: drive for any documents but only on...
  19. pdupreez

    How to create form (datasheet view) populated with set of data

    I have group of employees for which I want to add daily working hours, leave sick leave etc. I want to select the start of week using a combo box (done already). This should then populate a subform in datasheet view, filled with all active employee's name, number and the relevant fields such as...
  20. pdupreez

    Sending tables from 2 computers to get ONE excel sheet OR 1 Acc' table

    Hi CUOK There is maybe two ways of doing this: One : If you cannot connect via network, you can, if both are connected to a modem on different telephone lines, set up a dial up network connection between the two computers. You can then on connection transfer the data from one machine to the...

Part and Inventory Search

Back
Top