How many

[BeauKnowsDiddly]

Hello everyone, I'm brand new at accesss and am going to need lots of help! I'm in a class that assumes we were already taught Access. Little glich in the curriculum here but that's life.

Anyway here's the scenario, I created a service request table: Service Request Number, ACCT_ID, Date of Request, Item needing repair, description, cost, and prority. What they're asking me to do is to create a report that shows the service requests that are done most frequently.

I think I have to create some kind of query first, but I have no clue. I don't even know the language for this stuff. How do I count how many times pipes were repaired? I can look on the table and count in my head easily enough because there's only 15 records. But I'm thinking that's not quite what they have in mind. If there's a way to send you my data base I'd be happy to. Thanks

Beau

[RuralGuy]

Compact and Repair your db and then zip it up. You can then attach it to a post here. You just need to scroll down to manage attachments.

[BeauKnowsDiddly]

Hey RuralGuy,
Thank you for responding, Unfortunately I'm worse than a novice at this stuff :-(

How do I compact and repair the db?

[BeauKnowsDiddly]

Okay here you go,

Now how do I create a report that tells me how many pipes repaired, roofs, windows etc. thanks again!

Beau

[RuralGuy]

Run the query I created.