Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. adamdunko

    Report won't sort!

    It is actually a hyperlink (text) field.
  2. adamdunko

    Report won't sort!

    My issue is as follows: I have a simple report based on a query of 2 associated tables. There are 5 fields, Doc#, IssueDate, Title, Author, Remarks. All fields come from one table, with the exception of Title. These fields are being reported in a straight line under detail of the report. When I...
  3. adamdunko

    Total count of unique records.

    I am not looking to see how many of a particular Docname there are, just how many different Docname's have resulted from the query.
  4. adamdunko

    Total count of unique records.

    I have a query pulling out all records of a specific type: Docname, Docversion, Doctype are the fields for example... Doctype is the same for all results of the query. Docversion is unique for all results of the query. Docname is not unique for all results of the query. What I am trying to...
  5. adamdunko

    Print a Report based solely on the Current Record in a Form

    That worked well! Since I wanted just to print the report, I followed that wizard instead and added the: ,,"[ReportID] = " & me.ID to that line and it printed. Incidentally, I had to add a unique identifying autonumber field to the table and to the form (made it invisible). But it worked...
  6. adamdunko

    Print a Report based solely on the Current Record in a Form

    Hello, I am not a programmer so keep that in mind. What I am trying to do is include a button on my form, whereas when pressed, it will print a report that includes only data from the current record on the form. I feel like there is a way to do this with a query and macros, but I really can't...
  7. adamdunko

    Checkboxes on Reports - Help with Expression Builder

    Okay I figured out what my problem was.... The Checkbox field in the Query cannot be said to be null... it has to be referred to as False.
  8. adamdunko

    Checkboxes on Reports - Help with Expression Builder

    I am building 2 reports that will have checkboxes on them. On the first one, there is only one field to consider (a date field) so I just used that field name as the control source for the checkbox on the report-- the result being that if there is any value at all, the box will be check on the...
  9. adamdunko

    Access Report formatting by date

    I want to change the background color of a record in a report if the date field has already passed.. Not sure how to do this. Please help!~
  10. adamdunko

    Access Reports: Format Record Background Color based on Date

    Here's what I would like to do: I if a date field contains a date that has passed, I woul dlike to change the background color of that record in the report. I am not sure how to do this.

Part and Inventory Search

Back
Top