Help with MS Access Query

  Patroclus 09:36 15 Jun 03
Locked

I am trying to build a report in Microsoft Access for a small database that catalogues my DVD collection. I have a combo-box in the table for the region number, and I want to build a report that allows me to select the region number of DVD to view in the report. I believe I should be building a query to run the report from, but I'm not sure how to build the query so that when I run the report I am asked which region number to view.

Sorry if this is a simple question, but I am trying to teach myself to use Access, a slow and painful process. I'd be grateful for any help ypu can give.

  Diemmess 11:51 15 Jun 03

You have my sympathy.

Access can be self taught, many in cluding me have done it...... Its learning curve is like the north face of the Eiger.

I needed answers to your sort of problem when I wanted to select particular categories for a report, or all the items from one category (like you)

It took ages and great temper control working up a long series of macros which are attached to the "Onopen" part of your report.

A later upgrade from Access v 2 scuppered a lot of this because of vast changes in the app.

Now it all depends more and more on V.B. which I dislike having to learn from scratch.

The Manuals cover everything but are not - no way - intuitive. Help is comprehensive but waffles off into nerdland

Your best bet is to searh for something similar in the sample database Northwind Traders and see how it is done there.

Meanwhile a very inelegant, but very simple way would be to have as many reports as you have region numbers, each using the data from a slightly different query

For instance, put all the fields you want into a query and in the condition box below your region field write =1 ......This will select only those items which are in region one.

This thread is now locked and can not be replied to.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

1995-2015: How technology has changed the world in 20 years

The Pantone Colour of the Year 2017 is Green

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…