Reports
To display the totals go onto "Totals" and click "sum"
Use ID number to identify genders easily wehn creating Reports
Percentages in Access
"=[Score]/[Out of]" (change box format to percentage)
Combine two fileds together
=[Field name 1] & " " & [Field name 2]
Validation Rules
Field is required (don't put "Required" field as "Yes" if using this)
"Is Not Null"
Allow this date and dates after this date
">=#27/09/2019#"
Between a date and now
>=#SpecifyDate# And <=Now()
For Emails
Like *?@?*.?*
Querys
Look for Certain Names
Criteria box= "name1" or "name2"
How to add in access
"=IIf(IsNull([Table1]+[Table2]),0,([Tabel1]+[Table2]))"
Number of days
Tablename: "DateDiff("d",[Tabledatereported],Date())"
Serch for records that are between two dates
To display the totals go onto "Totals" and click "sum"
Use ID number to identify genders easily wehn creating Reports
Percentages in Access
"=[Score]/[Out of]" (change box format to percentage)
Combine two fileds together
=[Field name 1] & " " & [Field name 2]
Validation Rules
Field is required (don't put "Required" field as "Yes" if using this)
"Is Not Null"
Allow this date and dates after this date
">=#27/09/2019#"
Between a date and now
>=#SpecifyDate# And <=Now()
For Emails
Like *?@?*.?*
Querys
Look for Certain Names
Criteria box= "name1" or "name2"
How to add in access
"=IIf(IsNull([Table1]+[Table2]),0,([Tabel1]+[Table2]))"
Number of days
Tablename: "DateDiff("d",[Tabledatereported],Date())"
Serch for records that are between two dates
