Search results

I have looked for a similar question, but could not find one like it. I am not even sure if this is the right place to put this question, but here I go. I have a table of sales information. Part of my products are kits that are a combination of individual products. (Think of it as a value...

I am trying to build a query based on a number of factors. First, I am referencing a table of sales [ALL_SALES_DETAILS] and data within a form [frm_MainMenu]. In the table, one of the fields is the the transaction date [TRANS_DATE] and I am trying to figure out the [MaxOfTRANS_DATE] based on...

I am having an issue running queries. They are just running very slow. I have split the stand alone tables into a separate file, and compacted/compiled the heck out of the database to be about 1% of the original size. However, the queries still run slow. Most of the linked tables I base the...

I have searched and searched and cannot seem to find someone with the same issue I am having. Any/all help would be greatly appreciated. Background: I have a huge database of transactions by item. I have written a query to pull a portion of the transactions based on date/product family/etc. I...

Hello all. New member here from North Carolina, USA. I have accessed this site looking for advice/direction for some time and finally decided to take the plunge. I use Access (2010) daily in my job and have used Access to some degree since 2001. Everything I know is self taught. But...