report chart question ...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear all, I am attempting to create a chart from the following query

SELECT Test.No, Codes.Narrative, Products.Product, Test.VMonth
FROM ((Test INNER JOIN Codes ON Test.No = Codes.No) INNER JOIN [Product No]
ON Codes.No = [Product No].No) INNER JOIN Products ON [Product No].ProductId
= Products.ProductId;

where test.VMonth is a numeric field for months of the year and has a look
to a table, Months. When I run the query, I am getting the months of the
year ... January, February ..., however when I preview the chart, I am
getting the numeric values. How can I replace the numeric values with the
months in the chart
Any suggestion would be greatly appreciated
 
It sounds like you used a lookup field which is not a good practice
http://www.mvps.org/access/lookupfields.htm. In addition, there shouldn't be
any need to use a lookup table since month names are easily displayed if you
have the number of the month.

SELECT Test.No, Codes.Narrative, Products.Product, MonthName(Test.VMonth) as
Mth
FROM ((Test INNER JOIN Codes ON Test.No = Codes.No) INNER JOIN [Product No]
ON Codes.No = [Product No].No) INNER JOIN Products ON [Product No].ProductId
= Products.ProductId;
 
Thank you Duane
--
thanks as always for the help


Duane Hookom said:
It sounds like you used a lookup field which is not a good practice
http://www.mvps.org/access/lookupfields.htm. In addition, there shouldn't be
any need to use a lookup table since month names are easily displayed if you
have the number of the month.

SELECT Test.No, Codes.Narrative, Products.Product, MonthName(Test.VMonth) as
Mth
FROM ((Test INNER JOIN Codes ON Test.No = Codes.No) INNER JOIN [Product No]
ON Codes.No = [Product No].No) INNER JOIN Products ON [Product No].ProductId
= Products.ProductId;

--
Duane Hookom
MS Access MVP

jer said:
Dear all, I am attempting to create a chart from the following query

SELECT Test.No, Codes.Narrative, Products.Product, Test.VMonth
FROM ((Test INNER JOIN Codes ON Test.No = Codes.No) INNER JOIN [Product
No]
ON Codes.No = [Product No].No) INNER JOIN Products ON [Product
No].ProductId
= Products.ProductId;

where test.VMonth is a numeric field for months of the year and has a look
to a table, Months. When I run the query, I am getting the months of the
year ... January, February ..., however when I preview the chart, I am
getting the numeric values. How can I replace the numeric values with the
months in the chart
Any suggestion would be greatly appreciated
Click to expand...
Click to expand...
 
Back
Top