Recent content by AlienV

Hi CJ, No everything is correct as the query has not been modified since inception. It's not until I did the compact and repair did it do this. My backup (pre Repair and Compact) gives me the data correctly. Interesting update though... I ran the C&R a few times with the same results at...

Thank you CJ for your response. Yes, I split the database. To clarify my Monthly Report query is missing a few rows of data which represent specific months. For example this years months are now missing from the report. However if I query those specific months (e.g. Month =1 or 2) the data...

Hi Everyone, I'm new to the forum, Access and DBs since the late 90's in general. I used to do some DBA on a DOS based DB called R:Base. I am the sole user on a work DB that was created by another employee before he left. Three months later I said to myself "Self this thing probably needs...