Not your question?
Ask your question
View similar questions
Add your answer here.Check out some similar questions!
Grouping by Month in Crosstab Query
[ 3 Answers ]
Hello - here's my problem. I'm trying to put together a crosstab query that groups admit dates to the hospital by month for a particular nursing home. Here's how I have set it up so far: I have Admit date set as the column heading for the crosstab query. I have nursing home facility set...
Query regarding converting column to row in MS Access
[ 3 Answers ]
Hello, I have table in MS Access as bellow Name Date Time In_Out X 25/1/07 09:00 AM IN X 25/1/07 12:00 PM Out X 25/1/07 01:00 PM IN X 25/1/07 07:00 PM Out Y 25/1/07 12:00 PM IN Y 25/1/07 06:00 PM Out
Crosstab Query in MS Access
[ 1 Answers ]
How can I change the my query to crosstab query.. please see the picture.. http://www.l22l.com/l22l-up-1/8a7081adec.jpg I write this code... how can I change to a crosstab query SELECT SeaTable.location, Count(SeaTable.location) AS CountOflocation FROM SSFMainTable INNER JOIN SeaTable... View more questions Search
|