Help with MS Access

[krismcmillan]

I have got a query that shows the following information


-- removed inline image ---


I want to put this information onto a form, but it needs to be like this.


-- removed inline image ---


This is what I need “If Date Added = Date (text box), then display the figure that’s in the countOfSum box”

Is it possible to do this in MS Access, could you please provide the steps for me?

Thanks

Kris

 

[sheetspread]

dcount

 

[krismcmillan]

Hi Sheetspread

Could you explain how to use the Dcount formula?

Thanks

 

[sheetspread]

Here's a good explanation of the basic form:

MS Access: DCount Function

 

[sheetspread]

You actually don't need dcount if each of the dates to be compared as well as the countofSum box are in separate fields and in the same query or form (just the IIf). Otherwise you have to keep all the sources open.

 

[Micron]

What is the DCount for if he/she wants the count figure that is already in the countOfSum "box" (textbox?), wherever that is?

You can do this by creating an AfterUpdate event for the control that gets the date input, but I don't know what to do if it does because I don't understand this
display the figure that’s in the countOfSum box” Display where? How? Is it hidden and you want to unhide it? You want a message to pop up? That will be my assumption.
In that event write
If Me.nameofcontrol = nameofothercontrol then
msgbox Me.countOfSum
End If

Becareful of how you use the reserved word 'Date'