Trying to create calculation based on a grouping of categories

C

ctfrigg

Hi!

I need to create a calculation based on a grouping of categories (I think).
I have transactional data that lists a category, dollar amount, & month. I
need to find a total count for each transaction in each category and then
find the % of certain categories over the total.

I have numerous categories similar to below.

(I call these "regular" categories)
Air - Domestic Ticket Issued
Air - International Ticket Issued
Axcess After Hours Service-New

these are part of the categories but these are the ones I need to find the %
of total (I call these "Exchange" categories)
Air - Domestic Ticket Exchange
Air - International Ticket Exchange
Interactive Transaction Exchange LT
Interactive Transaction Exchange MI
VIP Service - Domestic Exchanges
VIP Service - International Exchanges

If I were to look at this in an excel pivottable, I created a group for the
"regular" categories, created a group for the "exchanges", got a total for
each group, a total for all and divided the #Exchanges/Total#.

In the end, I am looking for the query to produce the following based on the
above.

Jan Feb Mar Apr May etc
34% 39% 32% 36% 32%

What is the best way to do this?

I don't have much experience creating complex queries. I greatly appreciate
any suggestions you can give me. Thank you!
 
K

KARL DEWEY

I created a table -
CategoryList --
Type Category
Exchange Air - Domestic Ticket Exchange
Exchange Air - International Ticket Exchange
Exchange Interactive Transaction Exchange LT
Exchange Interactive Transaction Exchange MI
Exchange VIP Service - Domestic Exchanges
Exchange VIP Service - International Exchanges
Regular Air - Domestic Ticket Issued
Regular Air - International Ticket Issued
Regular Axcess After Hours Service-New

Query-
ctfrigg_Totals --
SELECT CategoryList.Type, Sum(ctfrigg.[Dollar amount]) AS [Total Of Dollar
amount]
FROM CategoryList INNER JOIN ctfrigg ON CategoryList.Category =
ctfrigg.Category
GROUP BY CategoryList.Type;

Crosstab -
TRANSFORM Sum([Dollar amount]/[Total Of Dollar amount]) AS Expr1
SELECT CategoryList.Type, First(ctfrigg_Totals.[Total Of Dollar amount]) AS
Total
FROM ctfrigg_Totals INNER JOIN (CategoryList INNER JOIN ctfrigg ON
CategoryList.Category = ctfrigg.Category) ON ctfrigg_Totals.Type =
CategoryList.Type
GROUP BY CategoryList.Type
PIVOT Format([TransDate],"mmm") In
("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");
 
C

ctfrigg

Thanks Karl. I created a category list table but I am alittle unsure about
the rest. This is a bit advanced for me and I am not that familiar with SQL
yet. Would you be able to "dumb" this down a bit?

- Are there 2 queries that you are suggesting?
- Can I change this to a Count just by substituting "Count" for "Sum"
- In the TRANSFORM in Crosstab - Expr 1 - do I substitute a name here or am
I really typing Expr 1?
- In the SELECT under the Crosstab - am I really using "First" or do I need
to put something else here?
- where am I telling the query to give me the total count of Exchanges/total
count of all?
- If I wanted to group by quarter-year instead of month, what would I use?

Thanks a lot. I really appreciate your help.
 
C

ctfrigg

I created an additional table for category list however, I am a little
confused at the rest. I am not that familiar with SQL yet and this is still a
little advanced for me. Would you be able to dumb this down a bit?

- Are you suggesting I do 2 seperate queries?
- If I wanted the Count, would I just substitute Count for Sum?
- In the Crosstab query TRANSFORM - Expr 1 - Is this going to be my column
heading?
- In the Crosstab query SELECT - First(... - am I really typing "First" here
or do I need to put something else?
- Where am I telling the query to calculate the total # of Exchanges (by
count)/Total # of all (by count)?
- If I wanted to group this by Quarter-Year, how would I do that?

Here's what I have so far.

TRANSFORM Count(ItineraryChanges_Detail.FeeAmount) AS CountOfFeeAmount
SELECT TravelExchanges_FeeCategories.FeeType
FROM ItineraryChanges_Detail INNER JOIN TravelExchanges_FeeCategories ON
ItineraryChanges_Detail.[Feesub-Category] =
TravelExchanges_FeeCategories.FeeCategory
GROUP BY TravelExchanges_FeeCategories.FeeType
PIVOT ItineraryChanges_Detail.Period;

Thanks a lot for your help. I really appreciate it.

KARL DEWEY said:
I created a table -
CategoryList --
Type Category
Exchange Air - Domestic Ticket Exchange
Exchange Air - International Ticket Exchange
Exchange Interactive Transaction Exchange LT
Exchange Interactive Transaction Exchange MI
Exchange VIP Service - Domestic Exchanges
Exchange VIP Service - International Exchanges
Regular Air - Domestic Ticket Issued
Regular Air - International Ticket Issued
Regular Axcess After Hours Service-New

Query-
ctfrigg_Totals --
SELECT CategoryList.Type, Sum(ctfrigg.[Dollar amount]) AS [Total Of Dollar
amount]
FROM CategoryList INNER JOIN ctfrigg ON CategoryList.Category =
ctfrigg.Category
GROUP BY CategoryList.Type;

Crosstab -
TRANSFORM Sum([Dollar amount]/[Total Of Dollar amount]) AS Expr1
SELECT CategoryList.Type, First(ctfrigg_Totals.[Total Of Dollar amount]) AS
Total
FROM ctfrigg_Totals INNER JOIN (CategoryList INNER JOIN ctfrigg ON
CategoryList.Category = ctfrigg.Category) ON ctfrigg_Totals.Type =
CategoryList.Type
GROUP BY CategoryList.Type
PIVOT Format([TransDate],"mmm") In
("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");


ctfrigg said:
Hi!

I need to create a calculation based on a grouping of categories (I think).
I have transactional data that lists a category, dollar amount, & month. I
need to find a total count for each transaction in each category and then
find the % of certain categories over the total.

I have numerous categories similar to below.

(I call these "regular" categories)
Air - Domestic Ticket Issued
Air - International Ticket Issued
Axcess After Hours Service-New

these are part of the categories but these are the ones I need to find the %
of total (I call these "Exchange" categories)
Air - Domestic Ticket Exchange
Air - International Ticket Exchange
Interactive Transaction Exchange LT
Interactive Transaction Exchange MI
VIP Service - Domestic Exchanges
VIP Service - International Exchanges

If I were to look at this in an excel pivottable, I created a group for the
"regular" categories, created a group for the "exchanges", got a total for
each group, a total for all and divided the #Exchanges/Total#.

In the end, I am looking for the query to produce the following based on the
above.

Jan Feb Mar Apr May etc
34% 39% 32% 36% 32%

What is the best way to do this?

I don't have much experience creating complex queries. I greatly appreciate
any suggestions you can give me. Thank you!
Click to expand...
Click to expand...
 
K

KARL DEWEY

I got off on the wrong track because you said one of your fields was
dollars. (it would have been easier if you had given me your real field name
in the begining)

Yes you need two queries - first totals by fee type.

Itinerary_Type_Count --
SELECT TravelExchanges_FeeCategories.FeeType,
Count(TravelExchanges_FeeCategories.FeeType) AS CountOfFeeType
FROM ItineraryChanges_Detail INNER JOIN TravelExchanges_FeeCategories ON
ItineraryChanges_Detail.[Feesub-Category] =
TravelExchanges_FeeCategories.FeeCategory
GROUP BY TravelExchanges_FeeCategories.FeeType;

TRANSFORM
(Count([TravelExchanges_FeeCategories].[FeeType])/[Itinerary_Type_Count].[CountOfFeeType]) AS CountOfFeeAmount
SELECT TravelExchanges_FeeCategories.FeeType,
Itinerary_Type_Count.CountOfFeeType
FROM (ItineraryChanges_Detail INNER JOIN TravelExchanges_FeeCategories ON
ItineraryChanges_Detail.[Feesub-Category] =
TravelExchanges_FeeCategories.FeeCategory) INNER JOIN Itinerary_Type_Count ON
TravelExchanges_FeeCategories.FeeType = Itinerary_Type_Count.FeeType
GROUP BY TravelExchanges_FeeCategories.FeeType,
Itinerary_Type_Count.CountOfFeeType
PIVOT Format([Period],"mmm") In
("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");

Use this for quarter --
PIVOT Format([Period],"q") & " QTR";


ctfrigg said:
I created an additional table for category list however, I am a little
confused at the rest. I am not that familiar with SQL yet and this is still a
little advanced for me. Would you be able to dumb this down a bit?

- Are you suggesting I do 2 seperate queries?
- If I wanted the Count, would I just substitute Count for Sum?
- In the Crosstab query TRANSFORM - Expr 1 - Is this going to be my column
heading?
- In the Crosstab query SELECT - First(... - am I really typing "First" here
or do I need to put something else?
- Where am I telling the query to calculate the total # of Exchanges (by
count)/Total # of all (by count)?
- If I wanted to group this by Quarter-Year, how would I do that?

Here's what I have so far.

TRANSFORM Count(ItineraryChanges_Detail.FeeAmount) AS CountOfFeeAmount
SELECT TravelExchanges_FeeCategories.FeeType
FROM ItineraryChanges_Detail INNER JOIN TravelExchanges_FeeCategories ON
ItineraryChanges_Detail.[Feesub-Category] =
TravelExchanges_FeeCategories.FeeCategory
GROUP BY TravelExchanges_FeeCategories.FeeType
PIVOT ItineraryChanges_Detail.Period;

Thanks a lot for your help. I really appreciate it.

KARL DEWEY said:
I created a table -
CategoryList --
Type Category
Exchange Air - Domestic Ticket Exchange
Exchange Air - International Ticket Exchange
Exchange Interactive Transaction Exchange LT
Exchange Interactive Transaction Exchange MI
Exchange VIP Service - Domestic Exchanges
Exchange VIP Service - International Exchanges
Regular Air - Domestic Ticket Issued
Regular Air - International Ticket Issued
Regular Axcess After Hours Service-New

Query-
ctfrigg_Totals --
SELECT CategoryList.Type, Sum(ctfrigg.[Dollar amount]) AS [Total Of Dollar
amount]
FROM CategoryList INNER JOIN ctfrigg ON CategoryList.Category =
ctfrigg.Category
GROUP BY CategoryList.Type;

Crosstab -
TRANSFORM Sum([Dollar amount]/[Total Of Dollar amount]) AS Expr1
SELECT CategoryList.Type, First(ctfrigg_Totals.[Total Of Dollar amount]) AS
Total
FROM ctfrigg_Totals INNER JOIN (CategoryList INNER JOIN ctfrigg ON
CategoryList.Category = ctfrigg.Category) ON ctfrigg_Totals.Type =
CategoryList.Type
GROUP BY CategoryList.Type
PIVOT Format([TransDate],"mmm") In
("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");


ctfrigg said:
Hi!

I need to create a calculation based on a grouping of categories (I think).
I have transactional data that lists a category, dollar amount, & month. I
need to find a total count for each transaction in each category and then
find the % of certain categories over the total.

I have numerous categories similar to below.

(I call these "regular" categories)
Air - Domestic Ticket Issued
Air - International Ticket Issued
Axcess After Hours Service-New

these are part of the categories but these are the ones I need to find the %
of total (I call these "Exchange" categories)
Air - Domestic Ticket Exchange
Air - International Ticket Exchange
Interactive Transaction Exchange LT
Interactive Transaction Exchange MI
VIP Service - Domestic Exchanges
VIP Service - International Exchanges

If I were to look at this in an excel pivottable, I created a group for the
"regular" categories, created a group for the "exchanges", got a total for
each group, a total for all and divided the #Exchanges/Total#.

In the end, I am looking for the query to produce the following based on the
above.

Jan Feb Mar Apr May etc
34% 39% 32% 36% 32%

What is the best way to do this?

I don't have much experience creating complex queries. I greatly appreciate
any suggestions you can give me. Thank you!
Click to expand...
Click to expand...
Click to expand...
 
C

ctfrigg

The first query worked but I am getting an error on the second one.
"Microsoft Jet Databse engine can't find input table or query
'Itinerary_Type_Count. Make sure it exists and is spelled correctly. What am
I doing wrong?

TRANSFORM
(Count([TravelExchanges_FeeCategories].[FeeType])/[Itinerary_Type_Count].[CountOfFeeType]) AS CountOfFeeAmount
SELECT TravelExchanges_FeeCategories.FeeType,
Itinerary_Type_Count.CountOfFeeType
FROM (ItineraryChanges_Detail INNER JOIN TravelExchanges_FeeCategories ON
ItineraryChanges_Detail.[Feesub-Category] =
TravelExchanges_FeeCategories.FeeCategory) INNER JOIN Itinerary_Type_Count ON
TravelExchanges_FeeCategories.FeeType = Itinerary_Type_Count.FeeType
GROUP BY TravelExchanges_FeeCategories.FeeType,
Itinerary_Type_Count.CountOfFeeType
PIVOT Format([Period],"q") & " QTR";

KARL DEWEY said:
I got off on the wrong track because you said one of your fields was
dollars. (it would have been easier if you had given me your real field name
in the begining)

Yes you need two queries - first totals by fee type.

Itinerary_Type_Count --
SELECT TravelExchanges_FeeCategories.FeeType,
Count(TravelExchanges_FeeCategories.FeeType) AS CountOfFeeType
FROM ItineraryChanges_Detail INNER JOIN TravelExchanges_FeeCategories ON
ItineraryChanges_Detail.[Feesub-Category] =
TravelExchanges_FeeCategories.FeeCategory
GROUP BY TravelExchanges_FeeCategories.FeeType;

TRANSFORM
(Count([TravelExchanges_FeeCategories].[FeeType])/[Itinerary_Type_Count].[CountOfFeeType]) AS CountOfFeeAmount
SELECT TravelExchanges_FeeCategories.FeeType,
Itinerary_Type_Count.CountOfFeeType
FROM (ItineraryChanges_Detail INNER JOIN TravelExchanges_FeeCategories ON
ItineraryChanges_Detail.[Feesub-Category] =
TravelExchanges_FeeCategories.FeeCategory) INNER JOIN Itinerary_Type_Count ON
TravelExchanges_FeeCategories.FeeType = Itinerary_Type_Count.FeeType
GROUP BY TravelExchanges_FeeCategories.FeeType,
Itinerary_Type_Count.CountOfFeeType
PIVOT Format([Period],"mmm") In
("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");

Use this for quarter --
PIVOT Format([Period],"q") & " QTR";


ctfrigg said:
I created an additional table for category list however, I am a little
confused at the rest. I am not that familiar with SQL yet and this is still a
little advanced for me. Would you be able to dumb this down a bit?

- Are you suggesting I do 2 seperate queries?
- If I wanted the Count, would I just substitute Count for Sum?
- In the Crosstab query TRANSFORM - Expr 1 - Is this going to be my column
heading?
- In the Crosstab query SELECT - First(... - am I really typing "First" here
or do I need to put something else?
- Where am I telling the query to calculate the total # of Exchanges (by
count)/Total # of all (by count)?
- If I wanted to group this by Quarter-Year, how would I do that?

Here's what I have so far.

TRANSFORM Count(ItineraryChanges_Detail.FeeAmount) AS CountOfFeeAmount
SELECT TravelExchanges_FeeCategories.FeeType
FROM ItineraryChanges_Detail INNER JOIN TravelExchanges_FeeCategories ON
ItineraryChanges_Detail.[Feesub-Category] =
TravelExchanges_FeeCategories.FeeCategory
GROUP BY TravelExchanges_FeeCategories.FeeType
PIVOT ItineraryChanges_Detail.Period;

Thanks a lot for your help. I really appreciate it.

KARL DEWEY said:
I created a table -
CategoryList --
Type Category
Exchange Air - Domestic Ticket Exchange
Exchange Air - International Ticket Exchange
Exchange Interactive Transaction Exchange LT
Exchange Interactive Transaction Exchange MI
Exchange VIP Service - Domestic Exchanges
Exchange VIP Service - International Exchanges
Regular Air - Domestic Ticket Issued
Regular Air - International Ticket Issued
Regular Axcess After Hours Service-New

Query-
ctfrigg_Totals --
SELECT CategoryList.Type, Sum(ctfrigg.[Dollar amount]) AS [Total Of Dollar
amount]
FROM CategoryList INNER JOIN ctfrigg ON CategoryList.Category =
ctfrigg.Category
GROUP BY CategoryList.Type;

Crosstab -
TRANSFORM Sum([Dollar amount]/[Total Of Dollar amount]) AS Expr1
SELECT CategoryList.Type, First(ctfrigg_Totals.[Total Of Dollar amount]) AS
Total
FROM ctfrigg_Totals INNER JOIN (CategoryList INNER JOIN ctfrigg ON
CategoryList.Category = ctfrigg.Category) ON ctfrigg_Totals.Type =
CategoryList.Type
GROUP BY CategoryList.Type
PIVOT Format([TransDate],"mmm") In
("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");


:

Hi!

I need to create a calculation based on a grouping of categories (I think).
I have transactional data that lists a category, dollar amount, & month. I
need to find a total count for each transaction in each category and then
find the % of certain categories over the total.

I have numerous categories similar to below.

(I call these "regular" categories)
Air - Domestic Ticket Issued
Air - International Ticket Issued
Axcess After Hours Service-New

these are part of the categories but these are the ones I need to find the %
of total (I call these "Exchange" categories)
Air - Domestic Ticket Exchange
Air - International Ticket Exchange
Interactive Transaction Exchange LT
Interactive Transaction Exchange MI
VIP Service - Domestic Exchanges
VIP Service - International Exchanges

If I were to look at this in an excel pivottable, I created a group for the
"regular" categories, created a group for the "exchanges", got a total for
each group, a total for all and divided the #Exchanges/Total#.

In the end, I am looking for the query to produce the following based on the
above.

Jan Feb Mar Apr May etc
34% 39% 32% 36% 32%

What is the best way to do this?

I don't have much experience creating complex queries. I greatly appreciate
any suggestions you can give me. Thank you!
Click to expand...
Click to expand...
Click to expand...
 
K

KARL DEWEY

Did you name the first query 'Itinerary_Type_Count?

ctfrigg said:
The first query worked but I am getting an error on the second one.
"Microsoft Jet Databse engine can't find input table or query
'Itinerary_Type_Count. Make sure it exists and is spelled correctly. What am
I doing wrong?

TRANSFORM
(Count([TravelExchanges_FeeCategories].[FeeType])/[Itinerary_Type_Count].[CountOfFeeType]) AS CountOfFeeAmount
SELECT TravelExchanges_FeeCategories.FeeType,
Itinerary_Type_Count.CountOfFeeType
FROM (ItineraryChanges_Detail INNER JOIN TravelExchanges_FeeCategories ON
ItineraryChanges_Detail.[Feesub-Category] =
TravelExchanges_FeeCategories.FeeCategory) INNER JOIN Itinerary_Type_Count ON
TravelExchanges_FeeCategories.FeeType = Itinerary_Type_Count.FeeType
GROUP BY TravelExchanges_FeeCategories.FeeType,
Itinerary_Type_Count.CountOfFeeType
PIVOT Format([Period],"q") & " QTR";

KARL DEWEY said:
I got off on the wrong track because you said one of your fields was
dollars. (it would have been easier if you had given me your real field name
in the begining)

Yes you need two queries - first totals by fee type.

Itinerary_Type_Count --
SELECT TravelExchanges_FeeCategories.FeeType,
Count(TravelExchanges_FeeCategories.FeeType) AS CountOfFeeType
FROM ItineraryChanges_Detail INNER JOIN TravelExchanges_FeeCategories ON
ItineraryChanges_Detail.[Feesub-Category] =
TravelExchanges_FeeCategories.FeeCategory
GROUP BY TravelExchanges_FeeCategories.FeeType;

TRANSFORM
(Count([TravelExchanges_FeeCategories].[FeeType])/[Itinerary_Type_Count].[CountOfFeeType]) AS CountOfFeeAmount
SELECT TravelExchanges_FeeCategories.FeeType,
Itinerary_Type_Count.CountOfFeeType
FROM (ItineraryChanges_Detail INNER JOIN TravelExchanges_FeeCategories ON
ItineraryChanges_Detail.[Feesub-Category] =
TravelExchanges_FeeCategories.FeeCategory) INNER JOIN Itinerary_Type_Count ON
TravelExchanges_FeeCategories.FeeType = Itinerary_Type_Count.FeeType
GROUP BY TravelExchanges_FeeCategories.FeeType,
Itinerary_Type_Count.CountOfFeeType
PIVOT Format([Period],"mmm") In
("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");

Use this for quarter --
PIVOT Format([Period],"q") & " QTR";


ctfrigg said:
I created an additional table for category list however, I am a little
confused at the rest. I am not that familiar with SQL yet and this is still a
little advanced for me. Would you be able to dumb this down a bit?

- Are you suggesting I do 2 seperate queries?
- If I wanted the Count, would I just substitute Count for Sum?
- In the Crosstab query TRANSFORM - Expr 1 - Is this going to be my column
heading?
- In the Crosstab query SELECT - First(... - am I really typing "First" here
or do I need to put something else?
- Where am I telling the query to calculate the total # of Exchanges (by
count)/Total # of all (by count)?
- If I wanted to group this by Quarter-Year, how would I do that?

Here's what I have so far.

TRANSFORM Count(ItineraryChanges_Detail.FeeAmount) AS CountOfFeeAmount
SELECT TravelExchanges_FeeCategories.FeeType
FROM ItineraryChanges_Detail INNER JOIN TravelExchanges_FeeCategories ON
ItineraryChanges_Detail.[Feesub-Category] =
TravelExchanges_FeeCategories.FeeCategory
GROUP BY TravelExchanges_FeeCategories.FeeType
PIVOT ItineraryChanges_Detail.Period;

Thanks a lot for your help. I really appreciate it.

:

I created a table -
CategoryList --
Type Category
Exchange Air - Domestic Ticket Exchange
Exchange Air - International Ticket Exchange
Exchange Interactive Transaction Exchange LT
Exchange Interactive Transaction Exchange MI
Exchange VIP Service - Domestic Exchanges
Exchange VIP Service - International Exchanges
Regular Air - Domestic Ticket Issued
Regular Air - International Ticket Issued
Regular Axcess After Hours Service-New

Query-
ctfrigg_Totals --
SELECT CategoryList.Type, Sum(ctfrigg.[Dollar amount]) AS [Total Of Dollar
amount]
FROM CategoryList INNER JOIN ctfrigg ON CategoryList.Category =
ctfrigg.Category
GROUP BY CategoryList.Type;

Crosstab -
TRANSFORM Sum([Dollar amount]/[Total Of Dollar amount]) AS Expr1
SELECT CategoryList.Type, First(ctfrigg_Totals.[Total Of Dollar amount]) AS
Total
FROM ctfrigg_Totals INNER JOIN (CategoryList INNER JOIN ctfrigg ON
CategoryList.Category = ctfrigg.Category) ON ctfrigg_Totals.Type =
CategoryList.Type
GROUP BY CategoryList.Type
PIVOT Format([TransDate],"mmm") In
("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");


:

Hi!

I need to create a calculation based on a grouping of categories (I think).
I have transactional data that lists a category, dollar amount, & month. I
need to find a total count for each transaction in each category and then
find the % of certain categories over the total.

I have numerous categories similar to below.

(I call these "regular" categories)
Air - Domestic Ticket Issued
Air - International Ticket Issued
Axcess After Hours Service-New

these are part of the categories but these are the ones I need to find the %
of total (I call these "Exchange" categories)
Air - Domestic Ticket Exchange
Air - International Ticket Exchange
Interactive Transaction Exchange LT
Interactive Transaction Exchange MI
VIP Service - Domestic Exchanges
VIP Service - International Exchanges

If I were to look at this in an excel pivottable, I created a group for the
"regular" categories, created a group for the "exchanges", got a total for
each group, a total for all and divided the #Exchanges/Total#.

In the end, I am looking for the query to produce the following based on the
above.

Jan Feb Mar Apr May etc
34% 39% 32% 36% 32%

What is the best way to do this?

I don't have much experience creating complex queries. I greatly appreciate
any suggestions you can give me. Thank you!
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Automation of scanned file storage based on content 0
I need ONLY subtotals copied to a second sheet 4
% of Pivot Question 4
Calculation to Obtain Compliance % Using Count of Partial Field V 1
Calculation to Obtain Compliance % Using Count of Partial Field Version: 2003 ( 0
Grouping of Categories 1
Calculation based on year of entry 1

Top