Recent content by japeconsulting

Hi I have the following table entries Date Acc Ref Amount Type 01/02/2018 ABC001 123 100 PAY 05/01/2018 ABC001 123 200 INV 06/01/2018 ABC001 123 300 INV so - Select Date, Acc, Ref, Amount, Type from Transactions I need to write a sql server statement that results in these entries, so...

I need to amend the following query so that I get ALL records from the OACT table. Because I am grouping by fields from other tables as there are no records for some of the accounts in this OACT table it is not including all of the accounts. Could someone assist as to how I can modify this...

I need a sql command that can show the first delivery type for each customer and I have managed to achieve this with OVER PARTITION BY using ROW NUMBER 1 but I also need a distinct count for each order and apparently this is not possible with this clause. Can anyone come up with a a simple sql...

Hi I have a field in my database which contains the day number of the year which is calculated from january 1st, so for example January 10 would just contain 10 and december 31st would contain 365. I need to work out from that the day and the month. I can write a formula in crystal syntax to...

Hi I have a array string that contains a number of notes from a field in the database and I want to extract specific items from this string. For example the string contains: stringvar array test:=["/1ItemA","/2ItemB","/1ItemC"]; I want a new string field (not array) that contains all the...

Hi Ian and Madwac Thanks so much for your replies. Sometimes you have to go back to basics I was making it much too complex!

I have a report where I need to show all orders which do not contain a "red" product ordered. I cannot use the record selection to limit the report where product<>red because that will just show me the lines that are not red, eg. Order 1 contains 4 lines - red, blue, green and yellow Order 2...