Search results

  1. D

    How to combine two query which have the same column name to be another

    Hi friend I need your help. I have made 2 query (named "QryReceivesum" & "QryWithdrawsum"). But query have the same common column called "ProductId". I want to combine 2 query to be just one. Currently I have mae one query named "QryStock". but the data from this qry is not correct. As you can...
  2. D

    How to set a calendar to be the entry of paramenter field to make graph in report

    Hi friend Anyone can help me If I need to make the graph in report. (the report are made from the query and i set one field as the parameter value.) Now the parameter that I key in , normally is the date. Many time that I key in the correct date but it show nothing in the graph. So i...
  3. D

    How to calculate the accumulate value of the current field

    If I have the field name as below: Oil quantity Accumulate Oil quantity Date Recordnumber I want to get value of "Accumulate oil quantity" of current record to be equal to sum of "Oil quantity" from first record till the current record: Let say after I input "oil quantity" in the record # 1...
  4. D

    How to make Form/ Report show full page immediately after open the file

    Hi friend I already make a form and report. But i do not know how to make Form & Report open full page immediately after we click into the file. Thank you everyone to help me.
  5. D

    How to export data to exel daily and not overwrite with old data

    I try to export the data from "Form" to exel file. I need to key in the "Form" daily and then export in to "designed column (fix column)" in exel file daily also. How can I export to exel and do not make the data overwrite to lod data. Thank you for your great help.
  6. D

    How to make our own navigation button

    I am doing a form with my own navigation button I can make button to - add new record - go to last record - go to next record but I can not make "page number" show up - total page - current page Thank you for your help Happy new year to you all
  7. D

    Set field value of current record to be qual to previous record field value

    Hi friend I am making easy database to collect water consumption If I have field as below RecordID Date Startmeter Todayusage Finalmeter If I want to set startmeter value to be equal to Finalmeter value of prevouis day How can I do it. Also If I enter the date in one field, and want to...
Back
Top Bottom