Recent content by lynn_victoria

Access Report filter via VBA Thanks Paul, I agree with the Nz thing and it dawned on me this morning (ahmm 5am) Howwever as to the query part, you totally lost me. I am having trouble because some people have multiple payments on one purchase so that's why the aggregate query to start with, I...

I have an aggregate query that is running a report. Access 2000 WinXP Pro I have these fields in my report: registrationfee paymentamount I want to total the registrationfees which i did like this: =Sum([RegistrationFee]) I want to total the paymentamounts which I did like this...

If your button is dependant on a macro...look in the macros section of Access..if it resides inVBA...look in the modules...you should be able to see it there.

if you give more information I can try to help...

create a subreport, inserting the pertinent fields into the main report...showing the connection between records as necessary... like one balance per every form id... hope this helps...do this all the time...if you need more info...please holler

create a subreport, inserting the pertinent fields into the main report...showing the connection between records as necessary... like one balance per every form id... hope this helps...do this all the time...if you need more info...please holler

Yes you can concatenate fields…. In the report…insert a control box…right click got to properties…click on Control source… click on the three dots to open the expression builder… Then type In your field names…like so…. =[FirstName] & " " & [LastName] with FirstName and LastName being an example...

why do you need more than one? if the answer is yes/no...it's either one or the other..please give more detail

In the query window... position the insertion point in an empty field text box... and then click on the expression builder.... set up the mathmatical calculation in there..(if you tellme what you want to do, fieldnames and amounts i can tell you what to write) then you can rename the field in...