Search results

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

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

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

Hi, I am a newbie so bear with me. I have a table which has data record1 | question 1 | 3 record1 | question2 | 2 etc I have a cross tab query that generates a table that now looks like Headings Question | 1 | 2 | 3 | 4| and the data shows how many questions were answered as 1, 2...

I have a form that is used to enter data to a table. The form has toggle buttons for a series of questions, with answers of Completely Satisfied, Somewhat Satisfied, etc. and depending what button is "clicked" a value of either 4,3,2,1 is written to the table. I now need to display the number...