Hello,
Please help me to solve this.
I have a query which calculates sum of pages.
Total Pages: Sum([TASK ID 37])
I have a option button in my FORM wich has two conditions
a) > 11 pages - option button 1
b) <=11 pages - option button 2
in my query i want to display condition 1 if option 1 is selected and vice versa.
below is the query...
smrkeyan316
Last Activity: Oct 19 '08, 04:39 PM
Joined: Sep 7 '08
Location:
-
Query Cond - Numberic Vs. Text
-
smrkeyan316 replied to How do i transfer different rows into (a) columns heads and (b) rows using SQL?in AccessThanks for the reply.
Now, i have designed the query as expected and i want this to publish in report for printing and some additional calculation.
How can i do that.
Regars,
Karthikeyan S... -
--------------------------------------
Hello,
Thanks for giving me the first step to solve the problem.
And there are few more issues in the database. I will try if not i will get back to you with more questions.
Thanks for your support.
Karthik...Leave a comment:
-
How do i transfer rows into columns?
How do i transfer rows into columns using query?
Please help me to solve this situation
I have a table that stores records like
Table “x”
I want to display the above Table in the following format using query.Code:ID WeekEnd % 1 10/12/07 70 1 10/13/07 80 1 10/14/07 40 1 10/15/07 45 2 10/12/07 20 2 10/13/07 30 2 10/15/07 30
...Code:ID 10/12/07
-
smrkeyan316 started a topic How do i transfer different rows into (a) columns heads and (b) rows using SQL?in AccessHow do i transfer different rows into (a) columns heads and (b) rows using SQL?
How do i transfer rows into columns using SQL?
Please help me to solve this situation using MS ACCESS Query
I have a table that stores records like
Table “x”
ID WeekEnd %
1 10/12/07 70
1 10/13/07 80
1 10/14/07 40
1 10/15/07 45
2 10/12/07 20
2 10/13/07 30
2 10/15/07 30
I want to display the above Table in the following format...
No activity results to display
Leave a comment: