User Profile

Collapse

Profile Sidebar

Collapse
yanni12
yanni12
Last Activity: Apr 10 '12, 02:54 PM
Joined: Jan 5 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • yanni12
    replied to Creating a filter query
    in Access
    This worked well. Thank you for your help.
    See more | Go to post

      Leave a comment:

    • yanni12
      replied to Creating a filter query
      in Access
      Code:
      SELECT [Special Servicing Loan Performance Filter].[Asset Status Report Date], *
FROM [Special Servicing Loan Performance Filter]
WHERE ((([Special Servicing Loan Performance Filter].[Asset Status Report Date])<[Most Recent Special Servicer Transfer Date] Or ([Special Servicing Loan Performance Filter].[Asset Status Report Date])=IsEmpty("«varexpr»")));
      See more | Go to post
      Last edited by NeoPa; Jan 12 '12, 11:05 PM. Reason: Added mandatory [CODE] tags for you

        Leave a comment:

      • yanni12
        replied to Creating a filter query
        in Access
        I in the Advanced filter section design view. For example
        field: Asset status report date
        Table: Special Servicing loan query
        Sort:
        Show:
        Criteria: < [Most recent Special servicer transfer date]
        or: ???? this is where i want to also search the column for blank fields
        See more | Go to post

          Leave a comment:

        • yanni12
          started a topic Creating a filter query
          in Access

          Creating a filter query

          I have a date field in a certain query. I am creating a advanced filter Query to search one date less than another. I was able to accomplish this. The problem I am having is the blank data fields. In my table the field has dates but a few blanks. I am trying to query a date less than another date or a blank. I am having trouble pulling the blank items in. How do I get a query to filter by blank fields also?
          See more | Go to post
          • yanni12
            replied to Run Report Form Combo Box
            in Access
            I chose to have this done in the Form's Open() Event? Where do I do this? int he combo box's properties?
            See more | Go to post

              Leave a comment:

            • yanni12
              started a topic Run Report Form Combo Box
              in Access

              Run Report Form Combo Box

              I am trying to run a specific report from a combo box list. I typed in the report names my self to the list. I went to onclick and provided the following code:

              Private Sub Report_Click()
              DoCmd.OpenRepor t "Modificati on Monitoring Report", acViewReport
              DoCmd.OpenRepor t "Special Servicing Loan Performance Report", acViewReport
              End Sub

              I need to be able to only open the report chosen...
              See more | Go to post
              No activity results to display
              Show More
              Working...