Search results

  1. V

    Form Header

    I have a form with a query as rowsource.When I open the form in data sheet view form header is not showing(Though it is visible in form view).Is it possible to show the form header in datasheet view? Vengsiva
  2. V

    Filter not working in cross tab query?

    I have a table like this Cultureworkload Reasonfortesting IRLNumber Diagnostic sputum specimens processed Follow up specimens processed Reception Follow up 7/2013 0 1 02-Jan-13 Diagnosis 8/2013 1 0 02-Jan-13 Follow up 9/2013 1 0 02-Jan-13 Diagnosis 10/2013 1 0 02-feb-13 Follow up 11/2013 1 0...
  3. V

    field values,group,compare

    I have a table with the following fields LabID PatientNo Testdate Testresult On different dates the test may be repeated The test result may be either Sensitive,Resistant or null I have grouped all patients using find duplicates(PatientNo) I wanted to build a query or VBA to find out the...
  4. V

    Querying for lasttransaction date and bank balance

    I am having a table tblBanktransactions in which are recorded deposits and withdrwals from diffrerent accounts.I want them grouped Bankid wise and find the last transaction date for each bank account.I did this with the following two queries qryrunningsumdeposits 'Grouping Bankidwise SELECT...
  5. V

    Counting occurrence of a letter

    I have a table tbllab1 with the following fields Labid :autonumber Hospital Number :Text Testdate :date TestResult :Text I want to return the count of "R" in the string TestResult.I designed the following query SELECT tblLab1.LabId, tblLab1.[Hospital Number], tblLab1.Testdate...
Back
Top Bottom