Access Help

[Spinal]

Howdy!

I need some help, I have an Access Database (2007) which resembles a couple of large spreadsheets.

What I want to do is create a form split into two. At the top there are a few drop down menus (i.e. Country, Region, Product). At the bottom is a list of the entries from a table.

Clicking on say Italy and Product1 will filter the results in the table below to restrict it to match those two values.

I know how to do this using queries... but no clue how to make the nice GUI side of things! I've looked for a tutorial, but can't find anything useful... any advice?

Thanks!
M.

 

[crammy69]

I havnet used 2007 yet, still on 2003 at work (due to Bloomberg not being compatiable yet) but have you tried using an Option box (drop down boox) on a Tab sheet? Make your query, then use a macro attached to a button to run the query and display the result?

 

[Spinal]

I'm starting to give up

The other thing I wanted to do, which I used to know how to do... but now am totally lost with is deduplication!

i.e. I have a table:

From:
CompanyA Attribute1 AttributeA 10
CompanyA Attribute2 AttributeA 10
CompanyA Attribute3 AttributeA 20
CompanyB Attribute1 AttributeB 5
CompanyB Attribute2 AttributeB 10

To:
CompanyA AttributeA 40
CompanyB AttributeA 15


If I remember well I need to use the like and sum options... but I can't think anymore, too much to do at the same time! I'm going to bed now, will fiddle more tomororw.. . maybe pick up an access book on my way into london...

M.

 

[Spinal]

Sussed!

SELECT

.[columA], SUM(

.[columS]) as "SubTotal"
FROM

GROUP BY [columA];

then adding extra fields allows me to get any data I want! It's coming back now

M.

 

[crammy69]

Well done!, havent done much access work myself the last 18 months since our H.O brought in a VBA guru who does it all now.

Cheers