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...
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...
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...
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.
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.
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
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...