Recent content by AccessDeano

I think so, the date is entered in a separate form, with both boxes set as short date. The query also has short date configured.

Thanks Wayne, that is what I suspected. Is there anything I could put in my criteria to make the selection add an extra day? I tried Between [startdate] And ([enddate] + 1) but that did not work. Thanks

This may sound a stupid thing to ask, but when you use: Between [StartDate] and [EndDate] does the period include data entered on the [end date] or data entered upto that date. Does that make sense? I seem to be experiencing problems with data entered today and when I run a query with an...

Rich, Thank you for your help with this issue but I have sorted it. It appears my If statement within another If statemnet was the problem. I re wrote the code as : Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.Question = "How satisfied would you be to RECOMMEND...

OK, I renamed the Text Boxes on the report and amended the code to: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.Question = "How satisfied would you be to RECOMMEND Wessex Garages?" Then If Me.[CS] = 0 Then Me.[CS].Visible = False Else Me.[CS].Visible = True End If...

They are field names from a cross tab query.

Thanks for the response. I have tried: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.QuestionID = "How satisfied would you be to RECOMMEND ******* Garages?" Then If Me.[1] = 0 Then Me.[1].Visible = False Else Me.[1].Visible = True End If End If End Sub But I lose...

I have looked at threads using Private Sub Detail_Format which I believe I need, however I am confused. I have a report, which is derived from a cross tab query. The report has 10 questions in it. 9 questions have 4 possible answers and the last question has 2 possible answers. Therefore my...

Thank you both very much. I am really grateful. Problem solved.

I have a report generated from a crosstab query. The crosstab has 4 fields I need to add together. In my form box I have used: =[1] + [2] + [3] + [4] as my column names are 1,2,3 and 4. However this returns a concatenated string rather than a numerical total. If I take away the [] I get...

Thank you very much. I had just found another post using NZ and had tried to get it to work, but with the expression the other way around - Count(nz([],)) and not suprisingly it didn't work. Thanks again.

I am very sorry, I did not engage brain before adding the attachment. It was an earlier attempt which I should have deleted. The correct file can be downloaded from http://www.auto-alert.net/access/csi.zip as it is too large to upload here (file size is 250Kb). This contains all of the...

I am sorry, I am confused. The mdb is all that I have. If you open the report and enter dates from 01-01-01 to 04-04-04 as an example the report is generated with several blank fields. I do not have any other tables, etc. I appreciate your efforts and happily accept that I am probably such a...

I am not quite sure how to add certain tables, etc. I have attached the mdb which is Access 97 format. Kind regards

I appreciate your help so far with this Unfortunately, that did not work My query is TRANSFORM Count(NewResponses.Response) AS CountOfResponse SELECT NewResponses.QuestionId, NewResponses.SortData FROM NewResponses WHERE (((NewResponses.Date) Between [Forms]![datetest]![StartDate] And...