Search results

Re: Do Not select records if duplication in specific field Thanks to Brianwarnock for getting me as far as I currnetly am. There's one more thing I would like to accomplish here. I forgot to mention if the CaseID is the same in more than one record, take only the record where the Trip field...

Re: Do Not select records if duplication in specific field I apologize Brianwarnock. I believe it does do what I asked for. I was just messed up because my CaseID was pasted from scientific notation in Excel into text in Access so the CaseID were almost all the same. Thank you very much!!

Re: Do Not select records if duplication in specific field Thanks Brianwarnock!. It's not quite where I'd like it but definitely in right direction I think. I've attached a sample database including only the table I'm talking about. I would like to have a query to return all records in the...

Do Not select records if duplication in specific field Hi. I have a table with several fields. Some records will have the same information in certain fields but different info in other fields. Three fields in question are: [CaseID], [Batch], and [Trip]. Suppose there are 3 records in the table...

I apologize for the code tag error on my part.

Hey guys. Would someone be able to please point me in the right direction? Here's my sql: strSql = "INSERT INTO t_EmployeeData ( PayrollID )" & _ " SELECT t_employees AS t_employees.ID " & _ " FROM t_employees LEFT JOIN t_EmployeeData ON t_employees.ID = t_EmployeeData.PayrollID " & _ " WHERE...

That's awesome Scooterbug!. Thank you very much. There's a considerable increase in performance. I really appreciate the time and effort you have put into this. That says a lot about the kind of people on this forum.

The average per day is calculated in another database. I just import the table into this database.

Here's a sample. It's a big database so I've removed many tables and forms that don't apply here. Click the 'Suggested Inbound Items' button to open another form. Click the 'Build Table' button to run the code I originally posted in this thread. All of the tables and queries in question are...

That sounds really good Scooterbug but would this work if I have 20,000 products in the t_CombinedVelocityTotals table, all with different averages for each day? All the products could have different delivery dates as well.

To begin, I'd like to say that I appreciate all your time. Let's see if I can clarify what I'm trying to accomplish. The code I originally posted does work properly but it's really slow. Because I'm relatively new at vb , I just thought it might be a good idea to see if someone could tell me...

I have a table containing average cases sold for each day of the week (Sunday to Saturday). What I'm doing is calculating the estimated cases to be sold from today until the next delivery of product([Days Until Delivery]) . So if today is Wednesday, I want it to add the average cases sold on...

Hi. I'm wondering if someone would please let me know if there is a better way to run the loop in the following code. My code is extremely slow on a core 2 duo 3.16GHz cpu with 2G RAM. My goal is to loop through a table of approx 5000 records, perform a calculation for a field and update that...