Recent content by randy700

Recently seen: Near the Air Force Base AV8OR While traveling over the Christmas weekend ONAJRNY IIIII1 Randy

The question was "Do you want tea or coffee?" Should be: Wants both tea and coffee = Reply "NO" because it means: I don't want tea OR coffee (NO) I want tea AND coffee - not offered. However, you left out the most obvious: Wants either tea or coffee = Reply "YES" Which brings us full circle...

ICU81ME My best guess: I SEE YOU ATE ONE BEFORE ME Randy

So sorry, Skip. I thought giving the OP an example to go by would help address his question and solve his problem. I didn't realize that I'm not supposed to offer suggestions other than those YOU give - I'll refrain in the future. Randy

It's just an example - what I'm currently using in a spreadsheet. My data will never be older than 1/1/2004. If yours could be older, use an earlier date. Another option would be cell value less than TODAY(). Randy

The formula I use is: Cell value between 37987 and TODAY()-1 Randy

Care to share the "work around" solution? Randy

So, what you want is 3 lines because you sold 3 computers and 3 software systems? How would you want it displayed if this was your Order_tbl? LineNO OrderNO PartNO PartDesc Qty 1 100100 10001 Computer IBM 2 2 100100 20002 Computer Dell...

Another option would be to add an 88 level to var2. 01 VAR1 PIC 9(3) VALUE ZEROES. 01 VAR2 PIC 9(6) VALUE ZEROES. 88 VAR2OK VALUE 999991, 999992. 01 VAR3 PIC X(10) VALUE SPACES. IF VAR1 > 0 AND NOT VAR2OK MOVE VAR2 TO OUT-VAR. Randy

Saw this one on the way to work today. UBU IBI Randy

In the Naval Shipyard, I once encountered a PROTECTIVE COATING ENGINEER. He was a painter. Randy

I got this code somewhere on this website long ago. Can't remember exactly where, but I think SkipVought provided it. Sub ImportWorkbooks() Dim FilesToOpen Dim x As Integer On Error GoTo ErrHandler Application.ScreenUpdating = False FilesToOpen = Application.GetOpenFilename _...

Or, you could adjust the column width to 0 (ZERO). Randy

Setting the fourth parameter of the VLOOKUP command to FALSE forces it to find an exact match. Randy

I would combine the tblAdopted and tblReturned_to_Owner tables: ID DateLeft Reason 1000 1/1/15 A 1001 1/5/15 R 1002 1/6/15 R 1004 1/3/15 A 1005 1/5/15 R Randy