Basic questions

[#1]

HI,

Added to LISTBOX Q unnecessary. How do I delete it (Q without a number).

What is the formula for bringing the names of days? I used with DayName

  This resulted in the dates.

Budget Sheet: How can I make it every year will be the same budget. If I click in the list box in the cloud for 2007 it will give me the result as in 2010 (888).

Last question, and most important: how to make the most appropriate links between the tables with JOINS''

I do not know how to do JOIN between tabs.

[rustyfishbones]

Hi Alon,

first problem you have is that you have dates in a number of tables, link the Sales to sales history

using concatenate something like

the formula for days is WeekDay(Date) as Day

[rustyfishbones]

Hi,

to disregard the selection for year try adding the expression SUM({<Year=>}SalesAmount)

see below

[rustyfishbones]

Added to LISTBOX Q unnecessary. How do I delete it (Q without a number).

do you have a blank orderdate in your dataset? it could be causing the issue

Regards

Alan

[rustyfishbones]

I may have misunderstood an earlier question, if you only want to see 2010 budget regardless of any other year being selected use the following formula