I have used Access a little but am on a Mac now. I imported my data from excel, saved thfile and want to perform some simple consolidation of data (i.e. i have line item by day but i want to sum it by month and add a column for the # of occurrences).

I tried to do the query but it said i need to select the ODBC database. I don't get it.

Also, if this is not simple to do than please let me know so i can find someone to do it for me.

thanks

ari

You try to work a filemaker base as a sql-source, which is not the straight forward approach, since it isn't turned on as default ODBC/JDBC sharing.

What you need is calc'fields result as breaker values, in an internal summary report, with a defined summary field.

--sd