Recent content by Gordon

  1. Gordon

    Sum Rows where there is a Null Value in a Column

    Sounds like a possible solution. I still figure there must be a way to calculate this in a query, but could not get it to work.
  2. Gordon

    Sum Rows where there is a Null Value in a Column

    OK, I found a solution to doing this in the report, using the Null Value function: =Nz([c],0)+Nz([w],0) However, I suspect that there is a more elegant way to do this in the query? If so, would that also make the report run more quickly?
  3. Gordon

    Sum Rows where there is a Null Value in a Column

    I have a crosstab report with three columns: Name C W Total Paul 2 2 4 Jane 5 6 11 John 15 I would like to add a column that sums the values for each name (Total) - as shown above. For instance...
  4. Gordon

    Repeating a Column

    I am trying to do the same thing. I have a crosstab report where there are quite a number of columns of data, which will span multiple pages, so I want to repeat the leftmost column on every page. There must be a way to do this in Access! ???? Thanks for any help...
  5. Gordon

    Show Field from Crosstab Query in Report

    That worked and the query is doing exactly what I want it to do!... I also am able to show the chosen date range in the report using a text box with: ="Between " & [What is first date] & " and " & [What is last date] One odd thing... when I am working on the report in design view the parameter...
  6. Gordon

    Show Field from Crosstab Query in Report

    Thanks Paul, I placed the [] brackets around "date" and that dealt with the parameter box. However, when I try to use the "between [What is first date] and [What is Last Date]" the query doesn't seem to recognize the format. The exact error message is "The Microsoft jet database engine does...
  7. Gordon

    Show Field from Crosstab Query in Report

    Here is the SQL: TRANSFORM Count(Master.Report) AS CountOfReport SELECT Master.Violation FROM Master INNER JOIN Contacts ON Master.[Contact #] = Contacts.[Contact #] WHERE (((Master.Preserve) Like "fre*" Or (Master.Preserve) Like "*madera*" Or (Master.Preserve) Like "*pur*" Or (Master.Preserve)...
  8. Gordon

    Show Field from Crosstab Query in Report

    Thanks.... I tried changing the parameter for the "date" field to a date/time format in the query, per the instructions in the lesson which you linked to above. The result is that I get a box which requests that I enter a date value. I wonder if this has to do with the problem of the name of...
  9. Gordon

    Show Field from Crosstab Query in Report

    Yes:( Unfortunately, this is a basic field in a table which is used by many queries and reports and I worry that if I change the field name at this point that I will mess up a lot of work which was done "downstream." Gordon
  10. Gordon

    Show Field from Crosstab Query in Report

    Hello, I have a report which is based on crosstab query. One of the fields in the query is "date" current range is "Between #7/1/2007# And #7/1/2008#" Dates are not part of the column or row headings. The date field is there just to limit the range of data which is chosen. I would like...
  11. Gordon

    How to Print the Report Name in the Report?

    Boblarson, Thanks so much!! That worked fine.... exactly what I needed. :o Gordon
  12. Gordon

    How to Print the Report Name in the Report?

    Thanks for the suggestion. I put "=me.name" into a text box, which Access changed to "=[Me].[Name]" When I ran the report it didn't work. Am I missing something? Thanks for any help..... Gordon
  13. Gordon

    How to Print the Report Name in the Report?

    Hello, I would like to create a text box which automatically prints the name of the report in the report. This is the report name as shown in Access, in the reports area (example rpt_monthly_sales). I don't just want to type the name in, since I may change the report name at a later date, and...
  14. Gordon

    Counting Records based on criteria

    Counting Records in a Report, based on a Criteria I just wanted to add a big "thank you" as well. I was trying to get a report to count records, based on a simple criteria and was having a heck of a time. Here is what I ended up with, in case you are trying to do the same thing...
  15. Gordon

    Wildcards for Conditional Formatting of a text box in a report

    Thanks for the response. I haven't worked with modules, I'm doing this in the standard interface for conditional formatting FORMAT/Conditional Formatting...... I was hoping to find a solution that works in that venue. Gordon
Top Bottom