| :: Microsoft Sql connection :: show all messages | Post a New Message | Post a Reply |
 Re: Microsoft Sql connection | Post a Reply |
from: Washington, DC
y - no of enquiry
x - months (jan, feb, mar...) filter by years
What do you need the advertisers table for? The information you want is in the enquiries table.
As for the month names, you can create (and populate) a new table called
Months (MonthNumber, MonthName) and join it with the enquiries table for SQL Server, your relationship statement might look as shown below:
Month([AWS_Enquiries].[EnquiryDateTime]) = MonthNumber The create an aggregate report and select a
SUM for Quantity-------------------------
Ghost