Search results for query: *

I have this working. It was a simple error on my part. The format for the text box on the report was wrong.

In addition, I use a different date range and in the text box on the form the correct number appeared but on the report it displayed 1900

The correct number (4) is being shown in the text box on the form. I am still getting 1900 displayed in the text box on the report.

I am not sure what you mean when you mean when you mentioned to "change the Count of the value column to Avg". I have tried changing Count to Avg in TRANSFORM Count(tblOldAbes.RawData) AS CountOfRawData An error came up "expression is typed incorrectly or is too complex..." I should have given...

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...

In addition, What would be the best way to display this info from this query in a report so it could be printed out

You were right I was working to hard. I am a novice at this as you may have figured out. I do have a question. The cross Tab query works great and is a lot easier than the way I was doing it writing a single query for each time of day. Is it possible to get the totals of the columns and rows to...

I am not using access to its full potential. We just want to use the reports and graphing portion of the program. We have 1 table that is all. The headings in that tabel are RawData, Day, Time, Month, DayNum, Year, and FullDate. The table is an Excel file that is linked to Access. RawData is a...

The report is only 1 page long because that is all that is needed. It has 8 columns and 17 rows. The last columns and row are for displaying the totals of the other 7 columns and 16 rows. The 7 columns have the heading of the day of the week while the rows are labeled with hours of the day. Then...

Will using a cross tab query help solve the problem of now being able to display the results of my query in a text box in a report.

The record source for the report is set to the table name. This is the only table that data is being pulled from. I am not sure what to check when you ask me to see how many records are being returned. Each text box is displaying 1 number from a query. Except there is 1 row and 1 column of text...

I have only 1 table that all the data is being pulled from. The table has; RawData, Day, Time, Month, DayNum, Year, and FullDate. This table was created by linking an Excel file to Access. RawData is a unique number for every entry in the table. Every entry in the table represents one unit. My...

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...

The report has 112 text boxes. There are 7 columns for each day of the week and 16 rows for the hours of the day. Each text box will return one and only one value. When I use the Dlookup as mentioned in my fist post I get #ERROR and when I tried [qryAvgMonday12pmManual]![AvgNumOfPics] I get...

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...

Pwise, I did try your suggestion just has you have it written and received a syntax error in the from clause. I am a novice with access as you may have figured out and was unable to get it to work. any suggestions would be greatly appreciated.

Thank You that seems to work with the small test run. What I am really trying to do is have the denominator be automatically generated without having the user enter in the number. Is there a way for me to count the number of Saturdays in a given date range. The table I am using will have...

That is pretty good Duane. I went to school in Eau Claire at UWEC. I am still in WI. Sorry for the long wait between replies. The first step I am trying to do is divide the results of my query by a number entered in by the user. The query in my first post works fine a returns the number I...

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...