Results 1 to 4 of 4
  1. #1
    brobb56 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    65

    Null field blank

    I have created a report from a query. All information comes from one form. The data wants to be viewed in this format.

    Name Report ID Form 1 Year 1 From 2 Year 2

    I want the data be like

    Name Report ID Form 1 Year 1
    Name (same as above) Report ID (same) Form 2 Year 2



    If data is not present in form 2 or year 2 I do not want that line to show. All data present with repeating row info of Name and Report ID once complete then record 2 begins. I need it to look like an Excel spreadsheet. Can someone help.

  2. #2
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    First, create a query:

    Code:
    SELECT [Name], [ReportID], [Form1], [Year1]
    FROM tableName
    WHERE [Form1] Is Not Null
    UNION
     SELECT [Name], [ReportID], [Form2], [Year2]
    FROM tableName
    WHERE [Form2] Is Not Null
    Then bind your report to that query.

    EDIT: You'll probably have to sort by the Name or ReportID to group them together. Also, for the sake of "proper" database techniques, try to avoid field names called "Name" or "Date" as they are reserved words. Also, field and table names with spaces or other special characters make writing SQL annoying.

  3. #3
    ragpatil is offline Novice
    Windows XP Access 2003
    Join Date
    Sep 2011
    Posts
    11
    I am having Query which is returning Null value and I am binding that field to a textbox in Report.While opening the report , I am getting Data type mismatch criteria error.

  4. #4
    brobb56 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    65
    I do not know how to do this. Here is my database I am using ives query and ives report. Can someone help me figure this out

Please reply to this thread with any new information or opinions.

Similar Threads

  1. How to get pass the error I get when a field is blank
    By beanhead0321 in forum Programming
    Replies: 12
    Last Post: 08-16-2011, 08:09 PM
  2. If Field is Null - Then Use Data from Other Field
    By KrenzyRyan in forum Queries
    Replies: 4
    Last Post: 06-10-2011, 12:12 AM
  3. Replies: 4
    Last Post: 05-11-2011, 03:06 AM
  4. Initialize field with a blank
    By GregFarrell in forum Forms
    Replies: 5
    Last Post: 02-16-2011, 01:50 PM
  5. Converting dates from a field with blank records
    By NOTLguy in forum Programming
    Replies: 3
    Last Post: 10-14-2010, 06:38 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums