Change Countofitems Name - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Change Countofitems Name

Stanley Mc Keown

15 months ago

I have a chart query derived from two other aggregate queries, an items overdue aggregate query and items done aggregate query, based on the same table.
  Consequently I have "CountOfItems" done and "CountOfItems" overdue / month both results of a count function in the queries.
   The problem is I have two fields named "CountOfItems" in the chart query which I know won't work.
   Can I change the name of one of them so I can have one as a percentage of the sum of both. Ie I need to have CountOfItems overdue ÷ ( CountOfItems done + CountOfItems overdue ).

  Or can I specify which query each "CountOfItems" came from in the calculated field in the chart query? What would the syntax be to achieve that?

	Kevin Robertson @Reply 15 months ago
You need to Alias the names to something unique and descriptive.

	Stanley Mc Keown OP @Reply 15 months ago
Thank you Kevin that's the answer I needed.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View