Hi..i am newbie and student in programming,so need help from expert.
Here is what i want to do.
1-I want to create Report System/Reporting System.
2-User must choose database and enter username and password.
3-Go to report form.
4-Click report type.
It has has 4 types of report.
Report A=Query 1
Report B=Query 2
Report C=Query 3
Report D=Query4
5-User...
akmaRudiliyn
Last Activity: Aug 22 '08, 07:12 AM
Joined: Jun 23 '08
Location:
-
Cutomize Report Presentation
-
Thank you for your help Stewart. -
Hai..anyone can help me..
I need to make report use database access.
I use sql query that given by friends here.
But i have face 2 problem.
a) How to filter data,to make data in database, either with gap (space) and without gap,as same data.
Eg:
1) Pulau Pinang same data as PulauPinang
2) Pulau Pinang same as P.Pinang
3) __(Gap) Pulau Pinang = Pulau Pinang
b) how...Leave a comment:
-
Ok, but actually i cannot modify the structure of my table.
How about if i have column name Race with various of values.
From the value i want to group by it into Foreign, Bumiputera and Non Bumiputera.
Eg:
Foreign
Korean
Japan
Bumiputera
Malay
Non Bumiputera
Chinese
IndianLeave a comment:
-
Sorry taking for a long time to reply.
I want to know, why my form can not run although there is no error or warning when i'm debugging.Leave a comment:
-
Below is my code to filter data. I want to arrange the data by state from north to south. First, Perlis, 2nd Perak and so on until Sabah. But the data is still sort by a-z(ascending) or z-a(descending) order. For example, Johor, Kedah,Kelantan. .Terengganu..I dont want this order.
Anyone can check my query below..
SELECT State,
Sum(IIf(Status= 'Ready',1,0)) AS Ready,
Sum(IIf(Status= 'Not Ready Aktif',1,0))...Leave a comment:
-
Thank you all for helping me.
1) I had sort my data in ascending order A-Z,but it is not sort properly. Why it is happen? How to solve it?
Eg:
C
B
A
A,B
A,B,
B
2) I also want to know the right way to filter use Visual Studio .net. Let say i want to filter the column <Blank> and Brunei for State row.
Eg:
State...Leave a comment:
-
Thank you again to Stewart Ross Inverness and nico5038 for help me.
Now my problem is solved. Thank you so much :).I want to ask another question.
Below is my query same as nico5038 give before. I just use it because look simple.
My query:
SELECT Language,
Sum(IIf(State=' UK',1,0)) AS State1,
Sum(IIf(State=' EGYPT',1,0)) AS State2,
Sum(IIf(State=' RUSIA',1,0)) AS State3,
...Leave a comment:
-
Thank you Stewart Ross Inverness and nico5038 for your help.
Yes, actually i want to have the same structure that had stated by nico5038,
but i dont know how to do.
Actually Status have 3 value.
1)Ready
2)Not Ready
3)Nothing
I already done the query but it is not work. It only show for Status Ready,
but Status Not Ready and Nothing are not showed. Maybe my query...Leave a comment:
-
Problem in running or open the query
Hi Everybody..
This is my firstime in creating report using microsoft access.
Actually i need to build a report based on a database call Table1.
I only use 2 column of databse to put in my report.
1) State
2) Status
For status, i need to separate it based on value of status;
Eg: 1)Ready
2) Not ready
I had create 2 query,one for ready and one for... -
Thank you CK for you answer.I had trying that way before and the error is solve. Anyway, i can not remove the constraint because it is compulsory to have in my system.
Lately, the error is disappear without drop the constraint or else. No error appear when i am debugging my form, but the form can not run. I also didnt put any break in my code. What happend here? I am confuse and weird. Anyone can explain me?
...Leave a comment:
-
Violation of PRIMARY KEY constraint..how to solve this error?
Hai everybody :). I have problem and need help.
ERROR:
ERROR [23000] [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK_Table1_01'. Cannot insert duplicate key in object 'dbo.table1'.
ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
MY QUESTION:
How to solve this error?
It is...
No activity results to display
Leave a comment: