Topic profile page for Query.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: Query.
Topic "Query" was discussed 278,817 times on 7,689 sites in last 3 months
Started 17 hours, 21 minutes ago (2009-11-12 04:50:00)
by Chip
Hey everyone, I keep getting an error in this query that says Syntax Error in JOIN operation. Does anyone see what I dont see here? SELECT tblStudents.ID, [tblStudents]![Lastname] & ", " & [tblStudents]! [Firstname] AS Expr1, tblStudents.CourseNum, [qryAEDPR Latest].LastOfPRDate, [qryAEDPR Latest].LastOfOutcome, [qryBLSPR Latest...
Started 20 hours, 35 minutes ago (2009-11-12 01:36:00)
by therain
Hi , I have a Oracle DB server (16 GB RAM) . The time taken to execute a query is 1 sec . The results (3 Lac records) have to be exported to a CSV . To acheive this , in java , i have written the following, strSql = "select * from test_view"; PreparedStatement stmt =con.prepareStatement(strSql); ResultSet rs = stmt.executeQuery(); csv.writeAll(rs,true); csv...
Started 20 hours, 39 minutes ago (2009-11-12 01:32:00)
by Hugh self taught
Hi Everyone, I have a basic form for data entry /update of Competitors. I now want to set the default value of a cbo box "Age Group" when I have updated the value in the Date of Birth field. I already have the following query for another purpose elsewhere that I should be able to use but I can't get the correct syntax in my ...
Started 22 hours, 24 minutes ago (2009-11-11 23:47:00)
by Frank Situmorang
Hello, I appreciate your help, the following is my cross tab query used in the report, however some of the records do not show up, could you help me how can I solve it?. I tried to make the detail can grow, but the result is still the same. ( some records do not show up) This is my query: PARAMETERS [Forms]
