Search results

  1. 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...
  2. V

    HELP!! Need to have report sorted with Drop Down

    Order by for report I assume you have tried to set Orderby at design time of report.Instead it can be done prgrammatically from generic form.Try the following code in the after update event of the dropdown dim strSQL as string 'strSQL is the record source of your report strSQl="Select...
  3. V

    getting list box data from table in access 97

    Thanks a million! Thanks a milion for prompt reply Vengsiva
  4. V

    getting list box data from table in access 97

    How to count occurrence from parsed fields? I have a problem in dealing with comma separated fields When a field contains a number of values separated by comma how to use dcount functio.The simple Dcount("MyID","Mycommaseptbl","1 in mycommaseparatedfield") does not seem towork vengsiva
  5. V

    Help!!!! Problem with form in Access.

    Elhan.View the form with subform in design view.click the subform and go to properties.Please see attachment vengsiva
  6. V

    Help!!!! Problem with form in Access.

    Go to subform properties.Click tab data.Choose "linkchildfields".From the pulldown selct the relevant field.Please see attached db which I did for a similar project.This is only an extract of that project
  7. V

    Help!!!! Problem with form in Access.

    Data source of form and subform can be set to table rather than query.Then set the linkfields,childfields properties in the subform and ensure that the wizard generated find combo is in the header.I can send you an extract by email if you want(It is more than 100 kb Vengsiva
  8. V

    Counting occurrence of a letter

    Thanks.It works fine!
  9. 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...
  10. V

    selecting the lesser of two amounts

    I think the following query will solve the problem SELECT Table1.Amountpaid, Table1.Amountdue, IIf([Amountpaid]=[amountdue] Or [Amountpaid]<[amountdue],[amountpaid],[amountdue]) AS returnamount FROM Table1;
  11. V

    Dynamic queries - user controlled in a form?

    Pat Please visit.A number of forms are available here http://www.rogersaccesslibrary.com/ I found the following very usefuls http://www.rogersaccesslibrary.com/download2k.asp?SampleName='CreateMultiSelectQuery2k.mdb' Vengsiva
View older results
Back
Top Bottom