Page 2 of 2 FirstFirst 12
Results 16 to 20 of 20
  1. #16
    uncletreetrunk is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Jul 2012
    Posts
    72

    Link takes me to a google doc page... unfortunately the browser at work doesn't support google docs. Can anyone verify the link works? fyi Snow I pm'd you with my email

  2. #17
    snowboarder234's Avatar
    snowboarder234 is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    243
    Click image for larger version. 

Name:	DatabaseError.jpg 
Views:	2 
Size:	138.8 KB 
ID:	8433I made a copy database with only one table and stripped the table of all but the most relevant information. I got this error message when trying to upload it. Its file size is 372kb. I don't know what the error message means.

    Oh -- but look, it uploaded after all!!!!!!!!!

    So, at this point, maybe it would be good if I reiterated my problem/goal:
    Goal: To create reports organized by year -- a separate report by each year. The year is reflected in the grant number ID: ie; 04_375, with the first two digits indicating the year.
    Problem: When I write the query I'm not getting all the records for each year. When I go back and compare the query against the original table, records are missing within each year.

    Even though it defies the normalization rules, I tried creating an additional field indicating just the year: ie, 2006, 2007, etc. I still had the same problem.

    Thanks in advance to anyone who can assist. Much appreciated.
    Attached Files Attached Files

  3. #18
    uncletreetrunk is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Jul 2012
    Posts
    72
    Hey snow! Glad to see you were able to upload it!

    So I made a separate query for 2004, 2005, and 2006

    They seem to be returning all the grant IDs within those years.

    Hope it helps!
    Database1.accdb

  4. #19
    snowboarder234's Avatar
    snowboarder234 is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    243
    I see now what the correct criteria code is. THANK YOU, THANK YOU, THANK YOU!!!

  5. #20
    uncletreetrunk is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Jul 2012
    Posts
    72
    No problem! Glad I could help you out!

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. How to issue a GRANT statement from a macro
    By xfp39024 in forum Access
    Replies: 2
    Last Post: 06-15-2012, 11:48 AM
  2. Back to the beginning - again
    By Sorbz62 in forum Database Design
    Replies: 4
    Last Post: 02-19-2012, 08:39 AM
  3. Calculated Total with beginning Value
    By mcahal in forum Access
    Replies: 1
    Last Post: 01-03-2012, 11:46 AM
  4. Beginning and End of Filter
    By injanib in forum Forms
    Replies: 1
    Last Post: 03-24-2011, 02:01 AM
  5. Beginning Design Help
    By GenericHbomb in forum Database Design
    Replies: 30
    Last Post: 08-20-2010, 09:41 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