Display of information

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi
I've set up a database with sales figures. I have a table (called Data)
which has Date, Group, Sales, Budget, YTD and this holds the raw data which
I need to display.
I have created three queries using this info which is based on the date
entered in a form. One query has 12 records (one for each Group) and each
record has Sales, GP and Budget figures. The second query has another 12
records, the same as the first query, but for the same month last year. The
third query has up to 144 records (depending on the month) as this selects
the YTD figures.
I now need to display this information. I thought about using a form - but I
don't know how to draw the information from three different queries. I then
set up a table, so I could push the info into that - with a single append
query and a load of update queries, but I don't know how to set up the
update queries to use the other three queries I've already written.
I'm sure there must be an easy/easier way to do this. Am I coming at it from
the wrong direction? Any help/advice/experience would be very much
appreciated.
Cheers.
--
Andy.



.

Relevant Pages

  • Re: Display of information
    ... and headings (Sales, GP, YTD) across the top. ... The first query selects the 14 records that are for the Month, ... I now have 3 queries that I want to bring together to display the form. ... > a primary key as a unique record identifier. ...
    (microsoft.public.access.gettingstarted)
  • Re: Was: what does "serialization" mean?
    ... the sales and inventory database has ... I should have said "ad-hoc" queries in the above ... > WHATEVER would probably be a separate query to summarize total sales. ... forces at work in any database. ...
    (comp.programming)
  • Re: Need help with a SQL Query
    ... or we need to retrieve all the columns from the table that satisfies the ... How many tables that will be involved in the query ... from sales a, sales b ... In that case the queries can be rewritten as: ...
    (microsoft.public.sqlserver.programming)
  • Re: Display of information
    ... I have a table which has Date, Group, Sales, Budget, YTD and this holds the raw data which I need to display. ... The second query has another 12 records, the same as the first query, but for the same month last year. ... I thought about using a form - but I don't know how to draw the information from three different queries. ...
    (microsoft.public.access.gettingstarted)
  • Re: cannot open any more databases...
    ... Could you post the SQL of a typical one of the queries, ... The major export query is a bear... ... I have YTD and monthly versions of 6 different metric categories for our ... A sample of the SQL in one ...
    (microsoft.public.access.queries)