Search results for query: *

How's it going dhookom? Sorry to bug, just wondering if there's any chance you'll have a solution for me soon. Thanks!

Hi Darrylles, dhookom is totally right. We only want to destroy a box of records once all of the records inside have met their retention. The boxes are supper heavy and many are on a shelf 10 feet high, so it would a lot of work to fish out the items that could be destroyed sooner than later...

Okay, I hope I did this right! The first bit is my data with significant columns/fields. The second set of data is the desired output if I were to enter a parameter of 2016 for Max(Year([SchedDestruc])). BoxID BoxNo Func Description DateFrom DateTo SchedDestruc TotalRet...

Okay, thanks. I'll give it a go.

What is PRE TGML? And, are you asking for a stripped down version of my database? I'm also not sure how to provide the desired output if I can't get a query to do it. Thank you again!

Correct!

Sure. If I didn't have a database, I'd go into storage and look at every box of records. Each box has: a number lists the type of records that are inside, and includes either a P for permanent or a SchedDestruc date, for each type of record. (Unfortunately, permanent and non-permanent...

Hi dhookom, I don't know why my reply to your last post is missing. I posted it on the same day as you did. So Sorry. Anyway, let me reply again and say I hope you'll stick with me for a solution. I'm not sure how applying the <>"P" after the Max()Year would affect things, since I don't...

Hi dhookom, Gave that a try, but still having troubles. 1. The [Records Query].TotalRet<>"P" part does not work. A lot of records are returned with a TotalRet of "P" 2. I tried things with and without either of the new criteria in the second Where clause, but I don't get all of the records...

I'm so sorry dhookom, I get your point about how explain. I guess my brain was so immersed in the details that I couldn't come at it from a simple point of view. Your solution works like a charm! ...except it asks me for the year for the destruction twice. Also, I can't seem to add criteria...

Hi, Skip and dhookom, thanks for giving this a try. I'm so sorry if I was confusing you! I should say that I'm working with a query in design view not SQL or VBA. Criteria for the field Expr1: Year[SchedDestruc] is <=[Enter the year for destruction:] When I enter a parameter value of...

Hi, I am trying to create a query that does not return any records with the same BoxNo (box number) if those records also have a scheduled destruction year that is <=Year(Now()) I’ve spent almost 16 hours trying so many different IIf statements and expressions that I’m so confused. So, I hope...

Hi feherke, You're a wizard! To answer your questions... I tried Tipue Search but it was not fully compatible with our MS FrontPage2003 intranet site (someday we'll move to SharePoint or something else more up-to-date). I didn't realize how the title[0]= functioned until I'd spent many, many...

Hi there, I'm have trouble tweaking the javascript for a search engine so that it sorts the result descriptions "desc" alphabetically. The search engine is otherwise running successfully on our internal website. I found the code here: http://www.javascriptkit.com/script/cut154.shtml Please...

Done. Thanks!

Another truth that deserves a good star! Thank you for confirming and encouraging me to do it, learn it right the first time. I couldn't find a gold star, so I hope this will do: [roll1]

I guess I was hoping for the simpler way out, which in the end is not the best. Thanks for putting it as you did Andrzejek. Now I know I have to buckle down and become proficient with normalization and relational designs. I'm the not so savvy one now! Thanks PHV, for the good reference.

Hi there, My dilemma is deciding if setting up my particular data in separate tables would be beneficial or make revising this data on an as needed basis by an end user more complicated than if were to store the data in one table. My data is approx. 50 different records retention periods, which...

Hi PHV, Thanks for getting back to me so soon! I got it!!! You were refering to my combo box property, event, VB code, not the property, "row source" sql query. Oh my gosh, what a relief!!! Thank you so much!!!

Hi there! I'm back to report that looking into your point that cboSubSeriesID has only 2 columns did not lead me anywhere, so I sure could use another hint or two. And I'm not sure I was clear in presenting my problem originially. My trouble is getting the second text box (Textbox2) to auto...