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 bkrike 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: *

  • Users: jisque
  • Content: Threads
  • Order by date
  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

    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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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