Search results

Hi All, I’m working on a database that will show us when and possibly why we had stock issues in store. I have a form, where the user can: 1. Look up certain stores and see how often they run out of stock on average. (Number of instances when they ran out / Total number of days) 2. List all...

have a form which has a ComboBox on it that pulls all DISTINCT colleague names from a huge table that includes all of our sales (50k+ records). It works perfectly fine, but it takes 3-4 minutes to open the form because it takes so long for Access to find all unique colleague names in the table...

[SOLVED] Combine nested IIF and SELECT TOP Hi All, I'm working on a database which shows the performance of our field colleagues. I'm done with almost all functions, except for one. I have a search form where the user will be able to search colleagues based on different criteria. One of this...

Hi All, I have a form with multiple fields (e.g. exact date, store name, store type, coverage status etc.). The user can fill in any of them and then a query returns the results. Everything works perfectly, but when I try to put the between dates in as well in SQL view, it keeps returning an...

Hi All, I have a database with loads of different sales data from Jan 2014 with other product details as well. I also have a form where the user can input any of these data (this is based on a query): - Campaign name - Exact Date - Month - Year - Category - Campaign Type This should run the...

Hi Everyone, I’m trying to create a database, which shows all of our campaign sales from Jan 2014. The database includes details like: - Campaign name - Campaign type - Product ID - Category - Exact Date - Month - Year - Total Sales - Incremental Sales - Uplift % - Etc. I have a form with...