Results 1 to 5 of 5
  1. #1
    Middlemarch is offline Competent Performer
    Windows 10 Access 2019
    Join Date
    Mar 2015
    Posts
    331

    Impossible Query ?


    Can a query insert a blank row into it's output where the first 9 chars in Field1 change ?

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,925
    No
    But you should be able to write a procedure to do so
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    Middlemarch is offline Competent Performer
    Windows 10 Access 2019
    Join Date
    Mar 2015
    Posts
    331
    You mean build a new table, or something else - UDF the query calls ?

  4. #4
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,342
    Do you mean something along the lines of the demo here?
    https://www.access-programmers.co.uk...report.326715/

  5. #5
    xps35's Avatar
    xps35 is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Jun 2022
    Location
    Schiedam, NL
    Posts
    226
    I don't understand. Insert one blank row where you want to change something? It won't be blank then. And, changed compared to what?

    Please provide an example of what you want.
    Groeten,

    Peter

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

Similar Threads

  1. Replies: 17
    Last Post: 04-14-2021, 05:20 AM
  2. Mission Impossible?
    By cmccarter in forum Access
    Replies: 18
    Last Post: 01-21-2017, 07:57 PM
  3. Replies: 2
    Last Post: 08-25-2015, 02:26 AM
  4. 0 divided by 0 = impossible..
    By LanieB in forum Queries
    Replies: 13
    Last Post: 01-03-2012, 05:24 PM
  5. Impossible to open more database
    By Grooz13 in forum Access
    Replies: 54
    Last Post: 08-06-2010, 05:17 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