Search results

  1. I

    how a query can calculate difference of new odometer & last odometer

    Hi guys, I am designing mileage database in access 2010. table: 1- maintbl (date, truckNo fillinQty,rate,cost, odometer, mileage) Query: 1- mainquery (based on maintbl) Form: 1- mainfrm (Based on mainquery) i want to calculate mileage : example:new odometer reading - previous odometer reading...
  2. I

    How to use 3 criterias in filtering a report using VB

    Hi, My report(Invoice) is based on a query. I am filtering report(on a filed 'DriversName') using following command: DoCmd.OpenReport "Invoice", acViewPreview, , "DriversName like '*" & txtname & "*'"(working fine) Can anybody tell me please that how to use 3 criteria or two more filters in...
  3. I

    How to filter report using 3 criterias

    Hi, I have following table, forms and reports in my access database: Tables: 1- maintbl Query: 1- mainquery based on maintbl Forms: 1- Input or mainform based on mainquery 2- unbound form: to Filter report Report: 1-mainreport based on mainquery Objective: I want to filter...
  4. I

    Multiple Criteria in one macro

    Hi, I have a unbound form with 3 text boxes and a cmd button: 1- txtname 2-monthname 3-yearname Button: 1-search Objective: I want to filter report on 3 criterias with: name month year Can anybody help that how can i use these 3 criterias in one macro or any other solution. Prompt help...
  5. I

    Enter Parameter value

    Hi, I am trying to create a report, filtered on a combo box(txtname). This combo box is having a list of names. I have one query(mainquery) based on a single table(maintbl). I created a blank form(GenerateReport) with abovementioned combo box(txtname) and a simple button, which will open a...
  6. I

    How to retrieve data from other table in Access 2010 web database

    Hi, I am creating a database using Access 2010 Web Database. I have two tables: 1-Maintbl with these fields: 1- Date 2- RTNo 3-DriverName 4- ConID 5-ConName 6- Zone 7- ZoneType 2- Consigneestbl with these fields: 1- ConID 2- ConName 3- Zone 4- ZoneType These...
  7. I

    How to assign values in combo box

    Hi, I am new to access so please bear my question. In a form, I have a combo box(combo1) that store values in field(remarks1) in a table.The values in combo box are: SL ST DI SL + ST SL + DI These all values are being saved in remarks1 quiet easily. I have more fields in the table: SL1 ST1 DT1...
  8. I

    Search and compare the value from three tables in a form

    Hi, I have three tables: Table A, Table B and Table C Fields of Table A: Truck No, Capacity Fields of Table B: Consignee ID, Capacity A, Capacity B and Capacity C Fields of Table C: Consignee ID, Final Rate Input form is based on Table C: 1-I select Truck No using a combo...
  9. I

    How to save the result of DLookup function (used in unbound text box) in a table

    I have a form based on query. On form i am retrieving data from another table using DLookup in a unbound text box. So i want to save the result of DLookup function in another field/table on same form. Plase take out me from this problem. Thanks
Back
Top Bottom