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

Thanks, but that doesn't work because when I try to type in LIKE " & strText, it thinks it's the end of the quotation. I've been suggested to use: Me.CollName.RowSource = _ "SELECT CollPerf.Colleague FROM CollPerf WHERE CollPerf.Colleague LIKE '" & strText & "*';" but this doesn't work...

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

Whoa. Thanks for the quick reply. I'll try to figure it out, but I have the feeling my Intro to SQL training might not be enough for this :(

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

Thanks for both of your replies. vbaInet, that's a good idea, I'll see if the users think if it's necessary. Thanks again!

Thanks for all your suggestions, I'll rewrite the code how CJ_London suggested, with IS NULL instead of NZ. One last note regarding the * - if they want to find a specific campaign (which will happen often), they can only type in only a part of the full name. Some people I trust will remember...

Thanks for your reply. I corrected Date to BookingDate as you suggested and also changed Like to =. Regarding your second point: if the field is not filled out, I want the query to move on to the next field and check if there is anything in that one. If there is, it will still have to check...

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

I was going through everything and found the problem. In the query's code the year and month were not listed after SELECT. Which is quite strange because I definitely remember seeing it in earlier datasheets.. Thanks for your help though!

Hi, Erm..I'm not sure, I don't think it is. (Sorry, I'm new to Access.) The query is built to find certain data in a huge database based on the user's input on the form. Only after I've done both of these, thought maybe it would be nicer to open the results in a report and not in Datasheet...

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

Thanks a lot! I've seen this on a forum, but it always returned an empty table. Probably it's something on my end, but just can't figure out why it's not working like the way you suggested. In the meantime, I've also received an answer on a different forum and it works correctly, just FYI...

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