A
Anderflash
Well, let me explain this complicated title:
I have a table with the sports (only swimming - freestyle, butterfly, relay,
etc...), competitors and their times. The times have minutes, seconds and
hundredth of second (like mm:ss.0 in Excel). Because this hundredth, the time
field is text (Access doesn't have this part in a date field). Thus, in a
query to ranking the competitors, the rank field will be a subquery [(select
count(*) from table where time < T.time)+1] that does the ranking. Because
this, I need to put an alias (in this case, the alias is 'T') on the table.
It works fine.
Imagine that I want a query to count the number of gold, silver and bronze
places for each country:
Country | Gold | Silver | Bronze |
---------------------------------------
Australia | 2 | 3 | 5 |
Canada | 1 | 4 | 7 |
....
I think the cross-tab query would be the best choice, using the rank as a
column heading, country as row heading and count(time) as value, but when I
try to execute the query, I receive the message: "The Microsoft Jet database
engine does not recognize 'T.time' as a valid field name or expression."
Why does this happen?
I have a table with the sports (only swimming - freestyle, butterfly, relay,
etc...), competitors and their times. The times have minutes, seconds and
hundredth of second (like mm:ss.0 in Excel). Because this hundredth, the time
field is text (Access doesn't have this part in a date field). Thus, in a
query to ranking the competitors, the rank field will be a subquery [(select
count(*) from table where time < T.time)+1] that does the ranking. Because
this, I need to put an alias (in this case, the alias is 'T') on the table.
It works fine.
Imagine that I want a query to count the number of gold, silver and bronze
places for each country:
Country | Gold | Silver | Bronze |
---------------------------------------
Australia | 2 | 3 | 5 |
Canada | 1 | 4 | 7 |
....
I think the cross-tab query would be the best choice, using the rank as a
column heading, country as row heading and count(time) as value, but when I
try to execute the query, I receive the message: "The Microsoft Jet database
engine does not recognize 'T.time' as a valid field name or expression."
Why does this happen?