how do i compare values between a input form and table.

[toby0595]

I am making a dp for end of day sales, and i want to compare data in a table to the numbers inputted in a form and see whether this value is higher or lower.


the table displays the target sales figures for each day, and the form allows the area mangers to enter in the current day figures.

thank you any help i am very stuck :banghead:

 

[pr2-eugin]

Would DlookUp help you to achieve this?

If not explain a little bit more what exactly you want to do..

 

[toby0595]

thank you very much that sort of helps, the mix and match looks like it could work.

i just want to make it clear that this is for my A2 ict project, and therefor i am not to familiar with access

Just so i am clear my database allows my client to enter end of day sales figures in to a sub form [input form], i therefor want to compare these to data in existing table, which has the target sales [Target] for each day. i need a way then of seeing if the sales entered in the form are higher or lower than the target value.

Any more help would be greatly appreciated.

 

[toby0595]

also the target is different for every store, in the input for there are navigation buttons that direct the user to the correct store.

i have tried IIF statements and vba code.

Private Sub Order_bay_AfterUpdate()

IF [Order bay] => [Order bay Target]
result = "target achived"
Else
result = "target not achived"
End If

End Sub