Search results

How do you change the page orientation after a page break in the reports on access 2003? I wish to put a graph/chart in a report but it is better displayed in landscape then in portrait. Thanks,

I'm using Access 2003. Therefore the total row isn't a feature

I have monthly Electircal use for different buildings in a field in a query. They are arranged monthly. I want to create a Query that shows the annual electrical use for the building. Therefore i need to calculate the sum of the 12 months for the given year in another query. But this is a...

I want to sum a particular field in access 2003. But I need to sum the value in 12 month blocks and display the results in another Query, so i can have the total value for 2008, 2009 etc. I'm unsure how to do this. Anyone can help me?

SELECT [Building information].[Building name], [Utility meter data].[Account number], [Electrical Monthly utility].[Date from], [Electrical Monthly utility].[Date to], IIf([Days 'to' passed]>[Days 'from' to end],[Month to],[Month from]) AS [Utility month], [DAte to]-[Date from] AS [Number of...

I thought that at first myself but I made the equation in the expression builder and it works if i don't put in a criteria value.

I am having trouble with stopping with the parameter popping up. I want to look up a particular value that is a result of a series of formulas. However If i put a value in the criteria cell of say "3", I get parameter pop up boxes asking me about individual values, which are different fields, in...

I am sort of new to access so I was wondering could this forum help me. I have a table that contains contract fixed billing on a month by month basis Jan, Feb, Mar etc for each account that, never changes. However there is another sheet that contains the actual cost of these bills but these are...