Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jisque

    Help Please on how to insert/retrieve dates in UK format!!

    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...
  2. jisque

    Problem with returning the correct recordcount from a recordset

    Thanks everyone for your very valuable support
  3. jisque

    Problem with returning the correct recordcount from a recordset

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

    Problem with returning the correct recordcount from a recordset

    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...
  5. jisque

    How can Subquery return members of same team ?

    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...
  6. jisque

    How do I find the top 3 values?

    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.
  7. jisque

    How do I find the top 3 values?

    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...
  8. jisque

    How do I find the top 3 values?

    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...
  9. jisque

    Stock update cul-de-sac

    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...
  10. jisque

    Stock update cul-de-sac

    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...
  11. jisque

    Stock update cul-de-sac

    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...
  12. jisque

    Calculating totals for each column in Access query

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

    Calculating totals for each column in Access query

    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...

Part and Inventory Search

Back
Top