Jump to content

Beginner: how to do simple query?


ari

This topic is 6458 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 6458 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.