Sorting and creating functions

[BUS 101]

I have recently purchased Access 2007 because Excel is limited to 1 or 2 million cells.



I am working with massive amounts of info.
In Excel, I can sort the table by customer ID and then add columns that will contain IF() functions to flag certain rows as needed for analysis.

Can I create IF() functions in Access?
If so, is the process to create a funcion different in Access than in Excel?

[RuralGuy]

In a word...YES. Have a go with the Query Builder to get a feel for what you can do. Access is a lot different than Excel.