ACCESS / EXCEL formula comparison

[Leadparsons]

Hi All,

New DB is working great thanks to all your help. Have a new problem.
I have 3 columns in excel and a 4th with a formula

Main Reject Return 60 days
27/08/2014 21/10/2014 22/10/2014 21/12/2014
24/01/2015 25/01/2015 DO REJECTIONS
17/02/2015 18/04/2015

"Main" is the first input date
"Reject" is the date it gets rejected
"Return" is the date returned after Reject

The 4th column needs to show 60 days from the "Main" date, "Do Rejections" if a date is in "Reject" and 60 days from "Return" date

Excel I use"=IF(AND(B2>0,C2>0),C2+60,IF(AND(B2>0,C2<1),"DO REJECTIONS",IF(AND(B2<1,A2>0),A2+60,0)))"

I Have tried in access IF(AND([Reject]>0,[Return]>0),[Return]+60,IF(AND([Reject]>0,[Return]<1),"DO REJECTIONS",IF(AND([Reject]<1,Main]>0),[Main]+60,0)))

Can anyone help ?

 

[Leadparsons]

This works, but I now have the record 1 of .... status bar attached to it. The one that appears at the bottom of forms !

If you've written the query that gives you the total from Expr2 to work (i.e. returning one cell with a total in it) you can add a sub form based on that query to your form:
Open your form in design view and click on the Subform/Subreport button in the toolbox - if you can't see the toolbox, click View and click on Toolbox
Select Use existing Tables and Queries and select the query with the total in it and move that field into the Selected fields box. There are a few more steps but you should be able to work it out
That will add the total to your form.

 

[Ben Nevis]

In design view you should be able to move the SubForm to a suitable position.
If you click the mouse over it and drag to select it you should be able to move it where you want.
Otherwise delete the SubForm and start again. You might find that if you right click and add a footer you can position it better in there.