Search results

I tried with a portion of my database using this query and adding the extra column Checksum: nz([IS Ref]+[Business stream]+[Project opportunity name]+[IWP PM]+[IWP New media analysis]+[IWP EPS Analysis/Design]): SELECT Table1.[IS ref], Table1.[Business stream], Table1.[Project opportunity...

Well i began to try your method for the first 4 feilds, but all this column seems to do is sum the values from these feilds and doesnt return any actual values

Thank you for your reply. Will this return all the fields with values? I already tried adding the criteria on each individual feild with >0, Is not Null etc... but it wouldnt return a signle record. Does this extra column just add a '0' to every row without a value? much like a default...

Hmm... Could anyone suggest an alternative? I have gathered a large data set, but not all of the data is required (only the feilds with at least one value and exclude the rest). Why cant Access let me write a query like Select * From Table1 Where all feilds >= 1 Returning all feilds...

Hi, I have a signle table with a large number of feilds (project ref, name dates etc... and a large number of skills). the skill feilds hold a number (number of days) assigned to each skill. If no values are entered no skill for that particular project is needed. Many of these feilds remain...

Can someone please help me... I am getting nowhere and have run out of ideas? Is what im asking actually possible? It seems to me that it is very simple (on paper) to simply exlude a feild with no values, I just need to know how to put it into practice and exlcude multiple feilds. Please help...

*Note, I need this for reporting, I can't include all the feilds (null) as 1. Access wont let me and 2. Readability. I just need a method to present all the data with values for each project excluding feilds with no vaules at all.

Hi, I have a signle table with a large number of feilds (project ref, name dates etc... and a large number of skills). the skill feilds hold a number (number of days) assigned to each skill. If no values are entered no skill for that particular project is needed. Many of these feilds remain...