Results 1 to 2 of 2
  1. #1
    watzmann is offline Novice
    Windows XP Access 2003
    Join Date
    Nov 2009
    Posts
    5

    Reporting Issue

    Hi All ,



    I build acess database consisted of 5 tables and with the same primary key which is the "Date"

    Then , i decided to build a report which gather differnat fields from all this tables and to show it in only one page

    My issue , when i preview the report it doesn't show anything other than blank fields .

    for that i made some relationaships between the tables and "Date" field was the gate to each table but it doesn't work

    Can you please help me ? - i need to know if for example i need to extract some fields from all tables in the date "01.09.10" how to do that ?

    Thanks

  2. #2
    pkstormy's Avatar
    pkstormy is offline Access/SQL Server Expert
    Windows XP Access 2003
    Join Date
    Mar 2010
    Location
    Madison
    Posts
    682
    First, if you have a field in the table just called "Date", please change it (ie. DateOfSomething). MSAccess coding works very poorly using key reserved field names such as: Date, Name, Field, Value, etc... Avoid naming any tables or fields with reserved key words (along with spaces or odd characters such as $@# in the field/table name.)

    I wouldn't make a primary key off of a Date type field. Not a good idea. Instead I might create a primary key type field which perhaps has some other field value and if necessary, embed the date into this value as a string value - ex: Kohn05232010 (although again, I would avoid having the date value as part of any primary key value.)

    It's difficult to say why you're not seeing any records on the report without seeing it. You may want to look at the recordsource of the report and work with that to get it to display values since your problem could be the recordsource itself or something on the report which is preventing records from showing.

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

Similar Threads

  1. Replies: 2
    Last Post: 04-16-2010, 09:24 AM
  2. Need Help with staffing calendar reporting
    By chrisfromwa in forum Reports
    Replies: 1
    Last Post: 02-24-2010, 04:15 PM
  3. Question on Reporting
    By jbarrum in forum Access
    Replies: 20
    Last Post: 01-14-2010, 02:05 PM
  4. Dynamic reporting
    By pushpm in forum Programming
    Replies: 0
    Last Post: 04-22-2009, 12:45 PM
  5. Rookie needs help with basic reporting
    By James Rousselle in forum Reports
    Replies: 0
    Last Post: 03-01-2007, 02:36 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