Results 1 to 2 of 2
  1. #1
    T1986 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2014
    Posts
    1

    Problem with null values using Cross tab queries

    Hello,



    I was hoping someone could help:

    I have a database that each day reports output by actual batches, planned batches and hopefully incomplete batches.
    The data is imported from an excel spreadsheet on which each row represents a different batch (each with a specified volume). Each batch will have a planned and actual output day, from this I use crosstab queries to count and calculate total volume of batches planned and actually produced on each day.

    I am trying to also report batches that have only been partially completed, so I have added another column to the excel sheet and created another crosstab query. Importantly, batches are not necessarily ever incomplete (the report runs once a day and most batches are started and finished in one day) so there is not a date in this field for every batch.
    When I try to report this data in conjunction with the planned and actual output, it only reports for records where there is a date in the ‘Incomplete’ field. I’ve tried using isnull and nz functions but without success.

    I haven’t included any examples as I think this is probably more of an organisational problem but can paste some samples if necessary.
    Thanks in advance!

    Tom

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    I use Booleans (Yes/No fields) in my tables to aid in data validation/verification during import procedures.

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

Similar Threads

  1. Cross Queries
    By zminek21 in forum Queries
    Replies: 4
    Last Post: 11-04-2013, 06:47 AM
  2. Null Values in Parametery Queries in forms.
    By FreddyFordo in forum Queries
    Replies: 1
    Last Post: 01-31-2013, 10:51 AM
  3. Replies: 2
    Last Post: 11-19-2012, 05:42 PM
  4. Merge 2 queries with null? values
    By PrintShopSup in forum Queries
    Replies: 2
    Last Post: 10-03-2011, 09:09 PM
  5. Cross Tab Queries
    By Nixx1401 in forum Access
    Replies: 6
    Last Post: 02-16-2010, 11:55 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