Search results

Everyone, I'm trying to make a query to return payroll data, but I'm not sure how to get Access to return 0 where data doesn't exist for a particular month. For example, imagine this table: Name Month Hours John 1 160 John 2 160 Dave 1 160 Dave...

Hello Everyone, I have a subform that displays records from a query. Usually, there is no issue. Sometimes, though, the subform stays blank for no apparent reason. Observations: -Open form and select relevant information (subform stays blank) -Open query and 1 record is present -Go form layout...

Hello everyone! So, I have 2 tables with the same structure (one for 2013, one for 2012). Each contains 4 columns (County, Market, UPC, and Sales). What I'm trying to do is make a query that will condense these 2 tables into 1 list containing columns for County, Market, UPC, Current[sales], and...