Search results
-
B
UNION Query syntax Issue
yes i want to join all three tables to get results from all 3 years -
B
UNION Query syntax Issue
and silly thing is: SELECT wj_attendance.ShopID FROM wj_attendance WHERE (wj_attendance.EmployeeID=3372) AND (wj_attendance.SerialDate Between 20160101 And 20191016) UNION SELECT wj_attendance2017.ShopiD FROM wj_attendance2017 WHERE (wj_attendance2017.EmployeeID=3372) AND... -
B
UNION Query syntax Issue
Tried it with these brackets: SELECT wj_attendance.ShopID FROM wj_attendance WHERE (wj_attendance.EmployeeID=3372) AND (wj_attendance.SerialDate Between 20160101 And 20191016) UNION SELECT wj_attendance2017.ShopiD FROM wj_attendance2017 WHERE (wj_attendance2017.EmployeeID=3372) AND... -
B
UNION Query syntax Issue
Hi Im trying to combine 3 tables into 1 using a union query. the 3 tables have the same fields/Data types but i keep getting this Any ideas? -
B
on-the-fly Totals in Access Reports
thanks guys. I think i can get something that works now instead of using several different reports. much appreciated -
B
on-the-fly Totals in Access Reports
=Sum(Val(Nz([Custom6a],0))) This one doesnt quite work because if there are values in a text field it sums those =Sum(IIf(IsNumeric([Custom6a]),[Custom6a],0)) This one seems to work. as long as the output is numeric i get the correct result (Could just set conditional formatting on the total... -
B
on-the-fly Totals in Access Reports
Run-time error '3464' Data type mismatch in criteria expression. -
B
on-the-fly Totals in Access Reports
both worked fine. I reverted to: =IIf(IsNumeric([Custom6a]),Sum([Custom6a]),"") but got the same error message. -
B
on-the-fly Totals in Access Reports
If it is numeric i get '-1' if it is not numeric i get '0' Thats What i expected. Not sure why my command doesnt work. -
B
on-the-fly Totals in Access Reports
Ive tried adding this to the control source in one of the total columns: =IIf(IsNumeric([Custom6a]),Sum([Custom6a]),"") This works on numeric values but not with text values -
B
on-the-fly Totals in Access Reports
yeah cant seem to get that working -
B
on-the-fly Totals in Access Reports
I need to check if the field is numeric first because when you try and sum a text field i get an error -
B
on-the-fly Totals in Access Reports
I have created a report that is a template report (a basic list) I have done this so i can call the report from various places without creating lots of similar reports. when i want to use it i pass the query, column names and ordering to the report and in the 'on open' event i assign the...