Recent content by Tblqryfrmrpt

Sorry for the odd title, but my problem is a little tricky. I have a query that is a union query that captures all incoming and outgoing changes to a field in a record based on today's date. These records need to be emailed to an outside source. The idea is that an admin user can click the...

Hi Guus, Thank you for your reply. I was looking at trying to use BeforeUpdate and AfterUpdate to track changes before, but I was under the impression that this only worked when you're talking about controls. I didn't think it would capture changes from an update query. I'm trying to look at...

Hi everyone, I'm trying to create a "Change Log" type of table based on my append and update queries. I have two tables, tblHistorical and tblDaily (data dump). They have the same exact headers. Each day, I have an append and an update query that will append/update the information in...

Great, thanks. I have this set up successfully, now I need to figure out the right criteria for the unbound form. I have a ComboBox that is pulling the Name from the Clients table, but can't successfully figure out the query syntax to filter out the zip codes after messing around with two inner...

Hi Spike, Thank you for the response. I figured that there may be an easier way to handle it because it seemed like the zip group idea wouldn't be normalized form. I guess my problem is how to build that zipgroup table. Multiple clients may share multiple zip codes. I can't have one field...

Hi everyone, New to posting here, but these forums are great. Thanks for the information. I've been trying to wrap my brain around this for a while and I can't figure it out. I have a table of properties. I also have a search form that works great when you search individual criteria or a...