Search results

How do you do the equivalent of an Excel If formula in Access? In excel I have a formula in a cell (and filled down the whole column) which reads =IF(D2="","Yes","No") How do I create a field in a table/query in an Access table to perform the same function?

Hey, I've used Access a bit before but not that much. I do loads and loads of analysis in Excel. But the data sets I use now are getting a bit unwieldy so I'm using Access more often now. And I'll be popping in and out of here for tit bits of advice on how to replicate some things I know how to...

Hi, I want to create a table in Access using a 3 column flat file. And turn into into a Table like a Pivot Table in Excel. Although it will look like an Excel pivot table, it will not do any calculation. What would normally be 'Values' in a pivot table simply needs to return content - more...