Search results

Try this on your Report Taking for granted that you have the message textBox on you Form name it "txtMessage" If not create one with no RecordSource On your Report also create an unbound textBox and name it txtMessageRpt make it RecordSource as followes =[Forms].[The Forms...

Got it solved The above should be PrevPaidCalc:Format(Nz(DSum("RemitAmount","tblCust omerRemitsDetail","SOInvoiceNumber=" & [SOInvoiceNumber] & " And RemitDetailID<#" & [RemitDetailID]),0),"$#,##0.00") The expression now does what I needed it to do. Which is create a Running Sum Invoice...

Folks are here to help you, not to do your work for you. Hope you try harder at you new job.

Try this site, http://support.microsoft.com/default.aspx?scid=kb;en-us;210350&Product=acc

Do you really need to show the subReport Header. A Report Displays Data, if there is no data to display you will have nothing displayed.

Place a Box, the size of the control you want to match on your report, and then place your Control inside the box, Set it's can grow property to yes. Unless I'm not understanding you this should look like you want it to.

no need to apologies thank you kindly for your in put

Will take it for granted, that you Report or subReport is base on a Query. If it is not, then you will need to make it so. With the Query open in design view, look at the top of the screen, you will see the word "All" with down ward arrow on the right side. Left click on the arrow. The list...

Thank you kindly RV, your reply is not incorrect, it solves half of the problem. I should explain in a little more detail The brain twist is, If the Invoice Number has a previous payment before this remit date that value is returned, if the Invoice Number does not have a previous payment...

Is there a way to add to the below code (a Field in a saved Query) that if the RemitDate is the same as the RemitDate and SOInvoiceNumber is the same the SOInvoiceNumber, that the DSum function will work. And also still work as the code reads...

Try this Like Iif(IsNull([Forms]![ReportDialog]![PlasticGauge]),"*", [Forms]![ReportDialog]![PlasticGauge]

Try this Like Iif(IsNull([Forms]![frmStat]![FirstDate]),"*",[Forms]![frmStat]![FirstDate]) You'll need to put this in the criteria fiel uder each of you fields, with correct field names

I'll be taking for granted that you are wanting to do this from PreviewReport. Create a Form that looks just like your Report. You may have to uses subForms to get what you want. To Print the Report, base the ReportForm and Report on the same saved Queries, and use a CommandButton to print hard...

Multiply by -1 -403,26 * -1 = 403,26 [NameOfTheControl]*-1= to change 403,26 to a negative number do the same.

Are you using Access 2000 or higher You can use "Conditional Formatting"

Do this in a saved Query, you can name it qryCalculateCustomerAging. InvoiceNumber ShippedDate 0-30 days Current: IIf(DateDiff("d",[ShippedDate],Date())<=30,([TotalInvoice]-[TotalPaid]),0) 31-60 days Over30: IIf(DateDiff("d",[ShippedDate],Date()) Between 31 And...

Try Me.cboSearch.Requery cboSearch = the name of you ComboBox Hope this helps

Joe Apologize for taking so long to get back; wife said I had to go to work. The “Document” field that I had mentioned was to store the “Purchase Order Number” or “Pickup Number” that you may need to add to the BillOfLading. You’ll need to have this on the Form for entry and on your report...

Joe Add a field to your BillOfLading table name it something like "Document". And add the same to your Form and Report. Am I understanding correctly that you may also have to change the Name or Address as well.

Didn't have my "mEANiNG CoNVErTOR swItch oN" Oh! sorry yes I did, I did have "mEANiNG CoNVErTOR swItch oN" switched on. Would seem that there was not enough data to convert to anything meaningful. Thank Dave will take a look myself.