Recent content by SueK

It works, it works, it works! Over the years, I've actually worked around providing something like this, I'm so excited to know how to do it now!! Thank you both very much!!!!!!

I'm really close! I have it built and it works!!!!! Yay!! Now, I can't figure out how to call it. It doesn't show as a macro, except in the VB module itself, so a user can't get to it. I'd like to put a macro to clear the old data, append new and then call this procedure, but I don't know...

snueberg, Markk, I can't thank you enough for all your time helping me with this! I still need to incorporate what Mark's designed, but I'm very confident in being able to do that. I really appreciate your help, you guys are awesome!

Thank you, Markk! Can I ask you one more favor? Can you help me understand what 'sum + !Value' is doing? I can see this is the piece that's accumulating the values, but I guess I have no idea what !Value is?

Yep! Once you do these steps, if you use the little down arrow on the paper clip, it puts the link in. Just tried again - still getting the security code fail. Will have a look at what Mark sent and keep trying. At least I understand the query method now - beyond the slow running issue.

I thought be cute and ran the linked file through a make table, rezipped the db and tried to upload that, but it's failing on a security token again.

No can do :-( If I try .zip, it quickly says it failed and if I try the original .txt, it says there's a security token missing. I wonder if needs time to register that I've hit 10 posts?

As I had to close without saving the new field, I can now see that % of the first item is 10.3. I think if I used your logic in "1-(DSum), it would give me what I'm after. Just need to get it to run!

Sorry, cant upload the .txt file you would need to run it. Maybe because I'm too new? I did zip it....

Embarrassed to share, I inherited this thing and they literally can't tell me why have the garbage is in there, so I've been reluctant to fully clean up! I'm new to the co. You need a txt file as well, can't seem to upload, will try in separate post

I agree with you totally! I want learn both, as you never know what you'll need next time, right!? Right now, the query method sort of seems like it might have worked. It was painfully slow to run, saying Access was not responding, but left to sit there I did get results! What I'm seeing...

Can I use a table instead of a listbox? If so, I have a query that selects my records, and adds fields for total value and % of total. I would need to start at record one, set the value, and move down tot he next and set value there. Am I understanding correctly? If so, how do I write a...

This actually what I've tried and I currently have a query that shows the data with a column for the overall total and column for % that divides the line by the overall total (QryLate). Oddly, I had to query that query in order to get it to descending by %, but I do have that (Qry%Sort). I...

Is there a way to retrieve 80% of records by the value, instead of record count? For instance, given a list of late orders, I want to review the ones that cause 80% of the total value of late orders. In Excel, I'd sort descending, create a column with % of total value, then an additional...

Hi Doc Man! Thanks for all the great input. I'm absolutely going to have to play with parameter queries to see if I can find a way to make this work, as that would be seriously cool! In the mean time, I think I'll put into action some of your idea on managing the separate queries to get...