OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Count of values [SOLVED]

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
donaciano2000
General User
General User


Joined: 22 Oct 2007
Posts: 14

PostPosted: Mon Oct 22, 2007 1:23 pm    Post subject: Count of values [SOLVED] Reply with quote

Sorry for such a simple question, I've tried reading in the forum for hours but I just can't find quite what I'm looking for nor figure out how to adjust something to get what I want.

Basically I have a list of addresses and I need to make a list of the # in each zip code. I guess this is a report then.

So I'll end up with sort of :

Zip Count
98765 10
98764 21

etc...
Thanks for any help. Smile


Last edited by donaciano2000 on Mon Oct 22, 2007 2:54 pm; edited 1 time in total
Back to top
View user's profile Send private message
Sliderule
Super User
Super User


Joined: 29 May 2004
Posts: 2499
Location: 3rd Rock From The Sun

PostPosted: Mon Oct 22, 2007 2:27 pm    Post subject: Reply with quote

donaciano2000:

I am assuming based on your question, that you are using HSQL as the embedded database ( you are asking this question in the Base forum, not in Calc ) . . . and . . . you have a 'table' that includes ZIP code information.

Therefore, you can create a Query to accomplish what you want. The steps I would follow to create this Query would be:
  1. Open your database in OpenOffice
  2. On the left, under Database, click on Queries
  3. Under Tasks, click on Create Query in Design View...
  4. An Add Table or Query box will appear, click on your Table name, press the Add button
  5. In the row labeled Field, click on your field name . . . ZIP
  6. In the row labeled Function, click on Group
  7. In the next column in the row labeled Field, click on your field name . . . ZIP
  8. In the row labeled Alias, give the column a name of your choice, for example: Count by Zip
  9. In the row labeled Function, click on Count
  10. Run your query by pressing on the Run Query Icon, OR, from the Menu: Edit - Run Query, OR, press F5
  11. Save the Query, if you desire by pressing the Save Icon, OR, from the Menu: File - Save, OR, press Ctrl+S

Now, that you have this Query -- you can bring this data, into Calc and print it, OR, create a report with the database Report Writer.

I hope this helps, please be sure to let me / us know.

Sliderule

Thanks to add [Solved] in your first post title (edit button) if your issue has been fixed / resolved.
Back to top
View user's profile Send private message
donaciano2000
General User
General User


Joined: 22 Oct 2007
Posts: 14

PostPosted: Mon Oct 22, 2007 2:54 pm    Post subject: Yup! Reply with quote

That did it, worked perfectly! Thank you very much for your help. Smile
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group