Search results

[Help] Access Pivot Table Hello, Now I am using ACCESS 2010 to analyse the database, but I've met a problem. In Access, does it exist something like "different from" in Excel to calculate the difference between this month and the last month, for example? Now I've got a Pivot...

Hello, In Access, does it exist something like "different from" in Excel to calculate the difference between this month and the last month, for example? Thank you in advance! Weiguo

Hello, In Access, does it exist something like "different from" in Excel to calculate the difference between this month and the last month, for example? Thank you in advance! Weiguo

Excuse-me, I made a mistake, it is a Pivot Table, not a Crosstab.

Thank you for your reply. But the value I got is grouped by date, thus if I use this as a sub-query, I could not get the value '200' for example. And if I want to calculate the difference between every two weeks, what should I do? The query will update every week. Thank you again.

Thank you for your reply. But the value I got is grouped by date, thus if I use this as a sub-query, I could not get the value '200' for example. And if I want to calculate the difference between every two weeks, what should I do? The query will update every week. Thank you again.

Hello, I met a problem in ACCESS 2010: I have a PivotTable and I want to insert a field to calculate (for example) the difference between 2 values ​​in this table: eg ___________ 2007___2008___ Difference Project 1_____200____218__________ 18 Project 2_____150____118_________ -32...

Hi all, I'm a new Access learner, and now I can realise some basical queries and selections, but I want to do more, like make a simple interface to set conditions and select the data. For example, on my interface, I can set the 'StartDay' and 'EndDay', then clic the button to select the data...