access vs filemaker

[OnziTam]

hi,
i justs start experimenting with database applications and i think filemaker is a dam good one. i find it very easy to collaborate my MS Excel knowledge with in it.
my qustion is can I use formulas such as this below in access to automatically calculate a fields based on another fields.

If(shift start time>shift end time;(Int(2400/100)+((2400-Int(2400/100)*100)/60))-(Int(shift start time/100)+((shift start time-Int(shift start time/100)*100)/60));If(shift start time<shift end time;(Int(shift end time/100)+((shift end time-Int(shift end time/100)*100)/60))-(Int(shift start time/100)+((shift start time-Int(shift start time/100)*100)/60)); and so on

 

[neileg]

Yes you can.

 

[The_Doc_Man]

Just remember that a formula is not a TABLE thing, it is a QUERY thing.

The good news is that almost anywhere you could have used a table, you can use a query. The exceptions are when you have formulas in many fields of a query, that query might not be updateable and therefore a form based on that query would be read-only.

Tables store data. Not formulas. Queries present data AND formula results.

 

[GaryPanic]

on the back of this which would be the better option Access or Filemaker - I know thi sia a access forum and so the views may be basis.