Recent content by Jackrees

No I'm trinig to write a calculated field in the data table of Access 2010. I have trimmed it to the time only using left() but there is too much data to load into powerpivot....... Any help much appreciated.

Hi Caz I have been running the pivots from the data table and putting the date only column as a calculated field in the table. Should I create a query that pullas through all the fields I want trhough and then pivot this? PS Im using access 2010 having not used access before so slightly...

Thanks Caz Is that as a claculated field/column in Access? DateValue doesn't seem to work there. Thanks again

Hi all I hope someobne can help as I am relatively new to access so please excuse if this is a dumb question. I have a larget transaction data set in access with Datetime column/filed. I have been running pivot queries to excel to do analysis of the data but the datetime field is returning...

I have table of transaction data, I want to count the number of successful customer transactions but the table includes cancelled transactions with anegative value. I was therefore looking to create a new calculated field for customer count which report either "1" or"-1" depending on if the...