Total 2 column When 1 Column Has A Null Value

Problem  : I have 2 column that contain numeric fields but then one column sometimes does not have any value, means that it has null value.

Solution :  Use NZ function to convert the values to zeroes.

Example : NZ ([columnName1, 0 ]) +  NZ([columnName2, 0])

Running Number On Report MS Access

Problem :  Running number for each records for report  MS Access / Numbered Query

Solution : First add unbound text box. Then click properties, control source is = 1 and set Running Sum
               to all over.

                                       

Credit To : http://rogersaccessblog.blogspot.com/2010/12/domain-function-examples-numbered-query.html

Relationship Indeterminate

Problem : I want to create One-To-Many relationship between 2 tables, but it show indeterminate.

Solution : Specific fields must be primary and make sure dekat properties tu choose no duplicate.

Include All Records On Query

Right now I'm working on access project..

Problem : Pegawai yang tidak berkursus tidak akan di display dalam result query

Solution : Click edit the relationship line in the query and select the 2nd radio button to include all records from the first table termasuk pegawai yang belum pernah berkursus.

Credit to : http://stackoverflow.com/users/13302/marc-s