Help with MS Access Query

  Patroclus 09:36 15 Jun 2003
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 2003

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.

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone