Search results for query: *

I am using SQL Server 2005 Express. My computer system date is in the UK format (dd/mm/yy). Have been strugling to insert and retrieve dates in the UK format. For example with the following example if I enter a date, I can only seem to retrieve it in the US format. CREATE TABLE X ( theDate...

Thanks everyone for your very valuable support

pwise, have tried your suggestion but get the following error message "No value given for one or more required parameters

I have a Subscription form in a Gym membership database. When the member renews their subscription, the user uses a drop down list box to select the member name and enter their on the subscription form. Then, I would like to count first the number of times the member’s id appears in the...

Want to include a constraint in a CREATE TABLE statement for a table in a Hospital database, with these tables: Team(TeamCode, TelNo, HeadNo) Doctor (StaffNo, dName,Specialism,TeamCode) Patient(PatientId, pName,ConsultantNo, WardNo, AdmissionDate, DischargeDate) Prescription(StaffNo...

Thanks a lot, but is there a way of doing this without using the Top function? I am actually using something called an SQL Anywhere database, and it does not seem to recognise The Top function.

I've got two tables, with these sample data, I'm working with.I wish to find the courses with the with the top three numbers of enrollments: Any help with this problem appreciated. Students: Student_id Student_name Course_code s01 Bell C103 s02 Robinson C102 s03 Edmonds C107 s04...

I've got two tables, with these sample data, I'm working with.I wish to find the courses with the with the top three numbers of enrollments. Any help with this problem appreciated. Students: Student_id Student_name Course_code s01 Bell C103 s02 Robinson C102 s03 Edmonds C107 s04...

Finally been able to sort it out - and it works! Thanks to all who replied. The code is as below: Sub UpdateStock() Dim intCounter As Integer Dim intTop As Integer Dim db As Database Dim rstPurchases As Recordset Dim rstStock As Recordset strSQL1 = "SELECT...

Yes, thanks. The rstPurchases bit was a typing gaffe, but the problem's that it updates only the first record in the recordset and ignores the rest - say if I have 4 items in the issues subform. The code should realy be as follows: Sub UpdateStock() Dim db As Database Dim rstIssues As Recordset...

Help would be greatly appreciated from anyone who can me solve this problem. I have an Issues form and an Issues details subform in a Stock Control application. On the Issues subform the user can enter several items to issued. I would like to update the Stock table with the quantity issued of...

Brilliant! Both replies. Thanks a million -you've solved a couple of sleepless nights

Appreciate any help in how to calculate the count of yes reponses along each column in an Acces query. I have a Responses table were each respondent answers ticks yes/no to each of five questions. I have used something like SELECT Count([Q1]) AS Ques1, Count([Q2]) AS Ques2 FROM Questions WHERE...