Jump to content

JJMcM123

Members
  • Posts

    6
  • Joined

  • Last visited

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

JJMcM123's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. I have not created table relationships. Each table has id fields to related tables. Would creating table relationship links help with a view filter?
  2. Thank you both for your help. I was able to use the formula but only in a datapage report based on a Table. However I have 2 tables, one Product (Plans) that relates to multiple Prices in Price Table. I need to use a Report based on a View that combines details of Product (Plans) to the Price, but in View cannot filter One of each Product and One Price for that Product. I'm sure this application has been used before. Any ideas is appreciated. Products 1714, 1785, 1829 shows more than one price: Search again City SqFt Story Bed Rooms Baths Garage Price Price Date Chino 1626 2 3 2.5 2 $423,880 08/18/19 Chino 1714 2 3 2.5 2 $441,426 08/18/19 Chino 1714 2 3 2.5 2 $454,426 07/09/19 Chino 1732 2 3 2.5 2 $431,880 08/18/19 Chino 1785 2 4 3 2 $458,770 08/18/19 Chino 1785 2 4 3 2 $469,770 07/09/19 Chino 1789 2 3 2.5 2 $433,880 08/18/19 Chino 1829 2 3 2.5 2 $461,990 08/18/19 Chino 1829 2 3 2.5 2 $466,990 07/09/19 Chino 1838 2 3 3 2 $482,470 08/19/19 Page of 4
  3. Thank you for your help. I'm still not having success though. Is there a way to filter the prices with a view and then apply the results in a another view to combine with product?
  4. Thank you MayMusic. If I did correctly, it is putting newest price date at top, but still displays older prices. How can I have just the current price showing. The idea is that I have a price sheet and only want to display current price to client. SELECT TOP 1 Price_Price FROM Price WHERE Price_Price = target.[@field:Price_Price] ORDER BY Date desc
  5. I have 2 tables, one with product and second with multiple price updates for each product. I created a view to combine product and price but need to to show the most updated current price (and ignore all previous price updates). How can this be done in the view or a datapage based on view?
×
×
  • Create New...