Results 1 to 4 of 4
  1. #1
    moha1520 is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2016
    Posts
    5

    act like excel sheet

    i have this table
    a b
    -------------


    10 0
    20 5
    0 10
    i want this result from my query or form
    a. b c
    10 0 c=a1-b1 =====> 10
    20 5 (c1+a2)-b2 ===> 30-5=25
    0 10 (c2+a3)-b3 ===> 25-10=15

    its just like you working in excel worksheet. .

  2. #2
    NTC is offline VIP
    Windows 7 64bit Access 2013
    Join Date
    Nov 2009
    Posts
    2,392
    column C is a calculated field in a query. A linear calculated field is very simple using other fields of the same record. The very challenging aspect of your requirement is the reference to the value of the preceding record. This is extremely challenging and beyond the scope of a forum reply. There is no such thing as 'preceding record' to a database nor unique cell names - and so you will definitely need a 4th column that is sequencing in order to establish which record precedes. Further you will not be able to use the normal query design view and will instead need to use the SQL view in order to write the query.

    It is do-able I believe however it may be easier to rely on excel for this task and link to an excel table. That would depend on the nature of your application.

  3. #3
    moha1520 is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2016
    Posts
    5
    how to link it sir

  4. #4
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397

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

Similar Threads

  1. Deleting Linked Excel sheet
    By BatmanMR287 in forum Access
    Replies: 4
    Last Post: 08-07-2015, 12:28 PM
  2. Replies: 26
    Last Post: 01-08-2013, 04:55 PM
  3. From Recordset to excel sheet
    By mark71 in forum Programming
    Replies: 1
    Last Post: 12-10-2012, 03:40 PM
  4. Exporting to Specific Excel Sheet
    By unrealtb in forum Access
    Replies: 2
    Last Post: 01-24-2012, 10:32 PM
  5. Import Excel sheet with query
    By tpcervelo in forum Queries
    Replies: 1
    Last Post: 08-03-2010, 07:10 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