Results 1 to 2 of 2
  1. #1
    kmims44 is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    May 2012
    Posts
    24

    Generating a Doc from a Query, Next Record of a single field on same page

    So I have a query that I want to use to automate input into a document, however I can't seem to achieve what I need and I thought ok I'll just create a report in Access instead formatted like the doc but it says the text is too long and i cannot do it that way either. There is 1 field in the query that I want to export into a word doc basicly in list format. The field is called "CDRL_ROMorTDEP_Desc" and I want word to basicly do the following in a continuous paragraph not creating a seperate page for each:

    4.0 Period of Performance
    This paragraph provides the customer with the total amount of time from Contract Award through Project Closeout. This timeframe should equal that in the proposed Project Milestone Schedule.
    5.0 Schedule
    6.0 Deliverables

    CDRL_ROMorTDEP_Desc (Record 1)
    CDRL_ROMorTDEP_Desc (Record 2)
    CDRL_ROMorTDEP_Desc (Record 3)


    CDRL_ROMorTDEP_Desc (Record 5)
    etc. etc.

    7.0 Shipping and Packaging
    This paragraph annotates how all the materials will be shipped and packaged IAW (per MIL Spec #, best commercial practice, MARK FOR, special handling, UID requirement, other).

    Can this be done? am i supposed to be formating it as a table within the paragraph or something?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    I don't understand why cannot do an Access report. Why would text be too long? How are you building that 'paragraph'? Want to provide project for analysis? Follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 5
    Last Post: 08-29-2011, 05:17 PM
  2. Replies: 4
    Last Post: 06-30-2011, 08:39 PM
  3. Multiple records on a single page
    By neo651 in forum Forms
    Replies: 1
    Last Post: 06-29-2011, 10:21 PM
  4. Single Record Update Query from a Form
    By Steven.Allman in forum Access
    Replies: 0
    Last Post: 03-30-2011, 09:34 AM
  5. Creating an HTML report as a single page
    By Harle in forum Access
    Replies: 2
    Last Post: 01-22-2011, 11:18 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