?
Solved

Microsoft Access 2007 continuous form - refer to value in previous row

Posted on 2014-02-04
3
Medium Priority
?
402 Views
Last Modified: 2014-02-05
Please see previous post:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_28356635.html

Great solution with a little snag because I did not supply enough information.

It works with one project, however there will be multiple projects so the tasks will need to be grouped by project.

Can the following be altered to somehow say "grouped by project id"?
[Required_Start]+Nz(DSum("[T_Aggressive_duration]","qryTasks","Order<" & [Order]),1)
0
Comment
Question by:mlaurin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 10

Accepted Solution

by:
Gozreh earned 2000 total points
ID: 39834611
I changed it also there, (maybe after you sow it - you should refresh the screen)

Your Startdate should be =[Required_Start]+Nz(DSum("[T_Aggressive_duration]","Tasks_tbl","Project_ID=" & [Tasks_tbl]![Project_ID] & " AND Order<" & [Order]),1)

and the enddate =[Required_Start]+DSum("[T_Aggressive_duration]","Tasks_tbl","Project_ID=" & [Tasks_tbl]![Project_ID] & " AND Order<=" & [Order])
0
 
LVL 10

Expert Comment

by:Gozreh
ID: 39834618
I also attached there your sample with this code in the qryTasks,  i'm sorry for the in-convinces.
you can delete this question if you want.
0
 

Author Closing Comment

by:mlaurin
ID: 39835436
Thank you, quick and perfect solution!
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question