Sum

[BringTheR41n]

I keep trying to get the total sum of my not cleared checks amounts within a given time frame. I have all of the not cleared checks amounts displayed on my report but when i create a Sum() textbox in the footer, it says "error". I have the amounts in currency format as well as total. I have it set up as: =Sum([NotCleared-MQ]): the MQ is my bank. Any ideas what im doing wrong? I have tried changing the NotCleared-MQ to NotClearedMQ but it still reads error...

[pbaldy]

That should work if it's the field name. Do you have it in the report footer or the page footer? It won't work in the page footer.

[BringTheR41n]

Ohhhhh I wasnt aware that it wouldnt work in the page footer. why would that make a difference tho?

[BringTheR41n]

with the page footer, it wants to put it on every page. Right?

[pbaldy]

It would be nice for it to work in the page footer, but it won't. About half-way down:

http://office.microsoft.com/en-us/ac...001122444.aspx

[BringTheR41n]

is it possible to pull data from another table and insert it in directly to a report? the report was drawn from a query but i need to add some info from a table.

[pbaldy]

Options include a subreport based on the table or a query and the DLookup() function.

[BringTheR41n]

I have tried the DLookUp() function and i can get it to pull data from the table but it only pulls the first entry. =DLookUp("MQBalance","BankAmount") is what i have so far but i dont know what to put for the criteria portion of the function to look up the most recent date. i do have a DateChecked column next to the bank amount tho. I check it every day to keep on top of everything. can i incorporate the function to pull "today's" Balance? meaning everyday i check it, i enter a value and run the report to compare numbers.

[BringTheR41n]

I figured it out. I had added ,"DateChecked = Date()") and it seemed to work.