Recent content by wmix

Thank you. I'm just learning how to use forms to filter queries and generate the reports I need. I will certainly look into it.

Thank you Markk, this worked perfect.

I've never had to do this before and my brain is not processing how to get this to work. I have a query that pulls information based on criteria from several tables. Then I have a simple report that populates a list of information from the query. Now I have to change the report slightly and...

Thank you DBguy, it finally worked. No idea why it was being so darn stubborn but I duplicated the column as you suggested and it finally all went in correctly. I appreciate your insight.

Hi Everyone, I need help moving data into a table and I'm going crazy because no matter what I try it doesn't give me my desire results. I have 322 records in an Excel file and the records are currently sorted in Ascending order by a value called ComplexID. This ID matches a bunch of other...

Thanks Doc Man for your reply. Yes, you are correct. Each CollectionID and CollectionDate coincides with paper-money in or coins-out. I think I understand what you're saying, but I'm not sure we could dump the old records. It's certainly something I had never thought about, I'll ask our owner...

plog THANK YOU! This worked perfect. I greatly appreciate your help. Now to work on creating the rest of the queries I need based on other tables that have this same type of START indicator.

Hi Everyone, I'm trying to automate a process I currently do manually and need some help. For vending machines, we track all the money in/out of the machine. I am specifically looking for our "CHANGER" machines. These are the one-to-one coin machines that return money, example, something you...

So I deleted everything and retyped it, must have been missing something, not sure. This now works with the dates changed to strings. Thanks everyone for your help! strWhere = "WHERE qProducts_MachineCheck.MachineID IN (" & strList & ") AND qProducts_MachineCheck.FillWeek Between #" & sDate1 &...

Micron, they either have to select one machine or several machines for the query, we have over 700 machines so we don't want the report for all of them. We are trying to narrow down the data to only what is currently needed.

CJ_London, thank you for your reply. I think this might be the issue. Here's the code I'm using to get the dates. I'm not great at VBA so this may not be correct, but it does give me the dates I need. I used a MSGBox to review the WHERE code for my string and it "appears" correct but it's not...

Thank you Plog for your reply. That was a typo on my part, the Select is FROM qProducts_MachineCheck.

Micron, thanks for the reply. I do need the IN because it's possible to have multiple machines I'm searching for. I will try your code and see if it works, thanks.

Hi Everyone, I'm struggling with creating a string that's being used to create a query. Couple of quick notes... strList - data comes from earlier in the code. SrchDate.Value exists and has been verified before the below code happens. sDate1 and sDate2 have been previously defined in the code...

Thanks for your reply. I'm trying to normalize my database as much as possible and avoid redundancies, so I was hoping to just filter the one query I have. I appreciate the feedback and will look into this option. I suppose it wouldn't be too difficult to rewrite the code I have to work this in.