How to use 'select' query in access?

[Guest]

Objective:

1. To be able to establish queries and select data from one data base and
take the information in the format required which will edit and update all
data bases as the query is done - hope this makes sense?

To date, all the required data is in table form reading vertically. My
requirement is to be able to set up a graph for example which will show total
sales for a certain shop:

For example, the shop is listed as DC103.
We have sold our product to this shop on 5 separate dates.

Sale 1 - 01/01/04 sold 2 items
Sale 2 - 04/03/04 sold 2 items
Sale 3 - 20/05/04 sold 4 items
Sale 4 - 01/07/04 sold 5 items
Sale 5 - 11/09/04 sold 2 items

Using a ‘select’ query in access ???? I want to list all outlets and see
their month to month sale’s values horizontally.
In other words: I want to see total sales for shop DC103 with a breakdown
of value of the sale and the date sold. This I would like to see in graph
form horizontally.

 

[John Vinson]

Objective:

1. To be able to establish queries and select data from one data base and
take the information in the format required which will edit and update all
data bases as the query is done - hope this makes sense?

Not really.

A "Database" in Access jargon is the .mdb file - a container for
multiple tables, forms, queries, reports and other objects. Data is
stored in a Table. And if you have the same data stored in multiple
tables, you should really reconsider! Storing the same data
redundantly in two different tables is NEVER a good idea.

If you're assuming that you must have formatted data in a table in
order to report it - reconsider this assumption. You can (and
routinely should!) base Reports and Forms on Queries; calculated
fields, totals, subtotals etc. should all be done either in Queries or
directly on a form or report.

To date, all the required data is in table form reading vertically. My
requirement is to be able to set up a graph for example which will show total
sales for a certain shop:

For example, the shop is listed as DC103.
We have sold our product to this shop on 5 separate dates.

Sale 1 - 01/01/04 sold 2 items
Sale 2 - 04/03/04 sold 2 items
Sale 3 - 20/05/04 sold 4 items
Sale 4 - 01/07/04 sold 5 items
Sale 5 - 11/09/04 sold 2 items

Using a ‘select’ query in access ???? I want to list all outlets and see
their month to month sale’s values horizontally.
In other words: I want to see total sales for shop DC103 with a breakdown
of value of the sale and the date sold. This I would like to see in graph
form horizontally.

A Totals query based on your sales table will do this for you. Create
a Query based on the table; click the Greek Sigma icon (looks like a
sideways M) to create a query with the sales per date. You can create
a Chart object based on this Query; it can be horizontal, vertical,
pie chart, whatever you wish.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps