Appending data and Cross Table queries Question

[Faisal...]

Listers

I have 2 tables:

Table 1:
Date Category Number

 

[Faisal...]

Just posting again because of formatting:

Listers

I have 2 tables:

Table 1:
Date Category Number

 

[Duane Hookom]

Change the join to Table 2 so that all records are returned from Table 2 in
the join properties.

 

[Faisal...]

Hello Duane

Thanks for your response and your suggestion did work outputting as
follows:

Category / 2005/12 2006/1 2006/2 2006/3 .....

---------------------------------------------------------------------------­---------------------

Cat1 10 5
1
Cat2 0
Cat3 15 0
1
Cat4 0
Cat5 8 5


What should I do to return the data for a particular month (obtain
through a parameter such that the user selects the data).

Example the user enters 2006/3 to obtain:
Category 2006/3
---------------------------------------------------------------------------­---------------------

Cat1 1
Cat2 0
Cat3 1
Cat4 0
Cat5 5

Again, your response will be much appreciated.

Regards,
Rahman Mooraby

 

[Duane Hookom]

I would create a new query that joins your crosstab with the category table.
Use the appropriate join in the new query.

--
Duane Hookom
MS Access MVP

Hello Duane

Thanks for your response and your suggestion did work outputting as
follows:

Category / 2005/12 2006/1 2006/2 2006/3 .....

---------------------------------------------------------------------------­---------------------

Cat1 10 5
1
Cat2 0
Cat3 15 0
1
Cat4 0
Cat5 8 5


What should I do to return the data for a particular month (obtain
through a parameter such that the user selects the data).

Example the user enters 2006/3 to obtain:
Category 2006/3
---------------------------------------------------------------------------­---------------------

Cat1 1
Cat2 0
Cat3 1
Cat4 0
Cat5 5

Again, your response will be much appreciated.

Regards,
Rahman Mooraby