Recent content by iznubadd

i run the query: SELECT * (SELECT id FROM members m WHERE orgid = '1') m1 INNER JOIN members m2 ON m1.id = m2.id INNER JOIN organization o ON m2.orgid = o.orgid ORDER BY m2.id, m2.orgid; ---Here is the error message--- Error Code : 1064 You have an error in your SQL syntax; check the manual...

Please help. what i would like to make is a report regarding name of students who is a member of a centain organization and at the same time list the other organization where he/she affiliate here are my tables tbl.members : id givenname middleinitial familyname orgID remarks tbl.organization...

I would like to ask for help on how I can make this work, im not good at Crystal Report and our programmer is gone. I did modify our sql stored proc, included a new field and would like to display it in updated crystal rpt and every time I access the new rpt, through the software it gives me an...

access 2003 hi i have a form with 2 textbox; Price and number of payments. what i would like to have is when i click the calculate a Report will open and display the list of month till end of payment. sample: Price: 500 No. of Payment: 5 Report will look like this, assuming that current month...