Recent content by MikeTampa

Gasmans answer works! Minty - I will look at your suggestion as well. Thank you both

I have a form which started with one tab. On that tab, the user would select the Resort ID (text) from a Combo Box and I used a dlookup function to retrieve the additional information relative to that hotel. Private Sub RESX_AfterUpdate() 'This identifies the basic items associated with a...

It look as though the above has worked for me.

I think I might have gotten it, still working through validation: SELECT [Output 1].AREA, [Output 1].RESX, [Output 1].[EXCH#], [Output 1].Today, [Output 1].GAP, [Output 1].HOLDCD, [Output 1].EXDTFDTF, [Output 1].UCDX, [Output 1].OFFER, [Output 1].CMGX, [Output 1].RESRTE, [Output 1].TRKFLD...

To add a bit of context, the reason I want to do a left-join is because every unit has to have a price. If I have an Output 1 table with 2,900 rows, that table has to still have 2,900 rows when the pricing is added.

Ok, I'm back at work and will try to better explain myself. Thanks for all your quick replies by the way. I have two tables with the following elements, and this is how they work together: Ouput1: RESX (Resort ID) EXDTFDTF (Start Date) UCDX (Unit Size) Priced By (Resort Code) Category...

Hi guys, thanks for getting back to me so quickly. I’m out of the office for the next two days but will try your suggestions on Friday. I am NOT familiar with non-equal joins but will do some reading on it. Thanks again

I have two tables: Inventory and Price. Price is built with ranges but inventory is built with discrete values. Meaning a price range can be 1/8/2019 to 1/16/2019 while the inventory has a date of 1/11/2019. I would need the inventory for 1/11/2019 attributed to the 1/8/2019 to 1/16/2019 price...

Hello, My name is Mike and I work in Revenue Management. I'm simply here to learn and get better at using Access to solve my day-to-day analysis problems. Mike