Calculations

[littlelis_19]

Hi,

Can someone tell me how I can get the result of a query into an unbound text field on my form.

For example, I am creating a staff database which records Sickness and I have a Query which contains dates From and To. Ive managed to create a calculation which tells me the total number of days taken off due to sickness but now I need this figure to disply in my form.

Please help me. I tried all day yesterday and I've tried Lookup and it doesnt work.

HELP!!!!

Lisa

 

[M8KWR]

use a list box instead of a text box, it will work then....

Hope this helps. You can make the list box look like a text box, or you could put the headers on, instead of using a label next to the text box.

Any more issue let me know.

 

[M8KWR]

use a list box instead of a text box, it will work then....

Hope this helps. You can make the list box look like a text box, or you could put the headers on, instead of using a label next to the text box.

Any more issue let me know.

 

[Oldsoftboss]

Use a dlookup in the controlsource of your textbox

=Dlookup("qryfieldName","qryname","qryIDfield = 1")

I usually create a second query that uses the first query as a record source and use a SUM type total.

Dave