Search results for query: *

I received some help on construction a cross tab query. The query is PARAMETERS [forms].[frmDateRangeOA].[txtDateStartOA] DateTime, [forms].[frmDateRangeOA].[txtDateEndOA] DateTime; TRANSFORM Count(tblOldAbes.RawData) AS CountOfRawData SELECT tblOldAbes.Time FROM tblOldAbes WHERE...

I am trying to display the result of DateDiff function in a report and am having trouble getting it to work. I am using a text box and in the control source i used =DateDiff("ww",[forms].[frmDateRangeAvgOA].[txtDateStartAvgOA],[forms].[frmDateRangeAvgOA].[txtDateEndAvgOA]) For the example I...

I have a report that has 8 columns and 17 rows. The last columns and row are for displaying the totals of the other 7 columns and 16 rows. This is all in the details section of the report. The user uses a form to enter a date range that populates the report. When you click the print icon it...

I am having trouble getting the results of a query to be displayed in a textbox in a report. I was able to get the results from the following query using Dlookup SELECT Count(*) AS NumberOfPics FROM tblOldAbes WHERE ((([tblOldAbes].[Day])="Monday") And (([tblOldAbes].[Time])="12") And...

Here is a little background first. I have a report with rows labeled 9:00 - 10:00 am, 10:00 - 11:00 am, thru 12:00 -1:00am and the columns are Mon, Tue, and so on. In addition we have a total for each row and column. The report is generated from a date range that is entered into a form from the...