At your level, think of Excel as the tables in Access. You can query those
tables and make reports off of those tables. You can not write a formula
within the tables themselves, but can write a formula as a control object on
a form or report. These are considered SQL formulas, but don't let that
scare you.
So, the closest thing that SQL has to Excel's =days360 is
datediff('d',[Start Date],[End Date]). Build a query that contains your
table. Drag the asterisk into the columns on the bottom. In an empty column
in the top row, type MyFieldName: datediff('d',[Start Date],[End Date]) -
where Start Date is the name of the field (table column) that has your start
date, and End Date is the name of the field that has your end date. It will
calculate the calendar day difference between the two fields for every row of
the result. To run the query: click the exclamation mark.
