Recent content by hilltop804

THIS! This is EXACTLY what I was looking for. Thank you so much. I had no idea you could do a multi-table FROM clause without a join. I apologize for the lack of sample data (I was in the process of fudging some for you), but I greatly appreciate you proposing a solution without it.

I think I may have poorly communicated my issue initially, so sorry for any confusion there. Thanks for responding, though!

The issue is that Matt has no record with month 2. So if I select name and nz(Month), I can't always specify the correct month because it could be any number between 1 and 12, right? Any given employee could potentially be omitted from the data if they have 0 hours for that month, but every...

Thanks, I didn't think Access would create records that didn't exist. My thought was the easiest way to do this is to have a table with all possible name/months and then join that to the actual data table. The issue is I'm not really sure how to specify column values that must exist for each...

Thanks for the reply. I'm aware of the nz() function, but I didn't think it would work here. In an instance where there are 12 months, I couldn't specify which month each value needs to be.

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

Thanks, but that didn't fix it either. Ultimately, I solved my problem by adding another button that copies * to a table and linking the subform to the table instead of the query. I don't have display issues anymore. Still, I wish I could figure out what the deal with this was.

Thanks, but that didn't seem to do it.

IMO, there's not a lot of code on the form (I try to keep them as light as possible for efficiency). There are 3 list boxes and when the last one is selected, there is a requery on the subform in the "after update" event. I tried changing various settings, but it just doesn't make sense to me...

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

Your idea of combining the tables worked great. Thanks for the help!

How will the append query look any different from the current setup, though? Won't it look and behave the same, but instead of displaying the information, it will change it in the table? Edit: I see what you're saying. Instead of basically vlookuping the past year sales info, I create and...

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