I've tried to incorporate your syntax but Access doesn't like the colon ':'
This is what I tried to run.
SELECT MasterData.[User in validity]: If([User in validity]="Yes","1","2") , MasterData.[User in validity], MasterData.*
FROM MasterData;
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...