Search results

Is it possible to convert fields listed down to show across. IDNo Code Position AAA B01 1 AAA C01 2 AAA D01 3 AAA E01 4 I want to show it as IDNo Code Code Code Code AAA B01 C01 D01 E01 Is this...

Works great Thanks for your help

That works a treat. Thanks for your help

Help! I want to add a statement to my access query which lists one field if another field matches the criteria STATUS PROCCODE Complete ABCD Incomplete DEFG Complete JHLM Incomplete BDEF I only want to show the Proccode if the Status field is Complete, if its...

I have a field which shows numbers 1-8 or is null. I want to group this to show if its 1,3,5,7 then it shows as "BOOK" else if its 2,4,6,8 then its "CHAIR" and if its null then show it as null Can anyone help - I am using Access 2003