Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2006

    Importing new time for header and update report

    Hi there, Im a newbie at this, i have a database importing a csv file every 15mins, I am using a loadtime update to query the time updated.

    I have created a cross query table and i have all the figures i need, i can create an auto report from this and create all the calculations on the form.

    But when i update the database with new info, the heading adds to my query but the report will not open, and it doesnt recognise the links, (ie the time was 9.15 9.30, etc and now i require it adds 9.45 and 10.00 etc through the day

    I would appreciate it if somecould advise how i can make it that the report updates including the new times and data ????


  2. #2
    Join Date
    Dec 2005
    Wilmington, DE - USA
    In your crosstab query, check the ColumnHeadings property for your Column Heading field. Make sure that there are entries for all of your time intervals. Then, once you have done that, go back to your report, and pick up any columns that were missing. (Or start over with the Report Wizard, if that's easier.)

    Bottom line: for a report based off of a crosstab query to work correctly, you need to define fixed column headings in the crosstab query.

  3. #3
    Join Date
    Feb 2006
    Thanks for the reply, much appreciated

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

Similar Threads

  1. Importing Xls and CSV files into MS Access
    By Jeff in forum Import/Export Data
    Replies: 1
    Last Post: 02-17-2009, 11:56 PM
  2. Update a combo box in real time
    By protean_being in forum Forms
    Replies: 0
    Last Post: 05-17-2008, 07:39 AM
  3. Importing from Excel
    By joer in forum Forms
    Replies: 0
    Last Post: 03-14-2007, 02:01 PM
  4. Importing Time Data from AS/400
    By smunie in forum Import/Export Data
    Replies: 0
    Last Post: 11-17-2006, 03:12 PM
  5. Replies: 1
    Last Post: 12-09-2005, 09:16 PM

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