Search results

Thanks...I changed the formula to SubT: Format(DSum("[Total]","qryPaymentsToDate2","[OrderNo]='" & [OrderNo] & "' And [tblInvoices].[InvoiceNo]<=" & [tblInvoices].[InvoiceNo]),"Currency") and it's working...in both query and report :D

I have a control on my report that will not accept the number formatting. I need it to be displayed as currency but it is showing as a general number on the report e.g. $1,451.10 is displaying as 1451.1 This control source is from a query with the following formula SubT...

Thank you both! It works :)

plog - i don't understand which double quotation marks to remove; could you please show me?

Sorry...the query with the formula is just named Query1

The queries to look at are -qryPaymentsToDate -qryPaymentsToDate2 - this is the one that has in the Dsum formula above

I have a query with the following fields -SubContractor -OrderNo -OrderValue -InvoiceNo -Total One OrderNo can have several invoices. I am trying to get a cumulative invoice total for each OrderNo I've tried the following formula but it is returning the total for each invoice for each order...

Thanks. I'll give it a try and let you know if I was successful :)

The form closing on running a report was just a setting that wasn't a problem until today. I'll try minimizing instead of closing but I think the issue I was having was that on minimizing the form, new data entered wasn't showing in the report so I think that is probably why I set it to close...

I have a macro in the On Open event to refresh the form on opening; however, it always takes me to the first record when opened. Is there a way to refresh and return to the last record accessed on the form? This could be any record on the form, not necessarily the exact last record (e.g...

Okay...through trial and error I managed to get the invoice details to show on one report by grouping on Invoice No and adding a total to the group footer and forcing a new page after the group footer My next problem is how do I get the report header and footer to show on each page instead of...

I am trying to do a simple invoice database which will let me print all invoices for a particular week without having to print the invoices one at a time. The Invoice report is based on qryInvoice. If I enter a criteria in the query to print by invoice number, the invoice report is showing...

I'll give it a try

Ok...changed the formula and that works too! The Dlookup formula always gives me trouble (I always the quotation marks are in the wrong place) I've been trying to use it more often to try and master it. I use it all the time in Excel with multiple criteria but in Access it is still a...

That worked! Thank you. I amended it slightly as the combo box is in the parent form so I used the below formula =DLookUp("[DlyRate]","tblSubs","[ID]=" & [Forms]![frmInvoice]![cboSub]) Thanks again. :)

The row source for the combo box cboSub is SELECT [tblSubs].[ID], [tblSubs].[SubName] FROM tblSubs ORDER BY [SubName]; Thanks for your help

Sorry for the delay in responding. cboSub looks up the sub-contractor name in tblSubs. tblSubs only has 3 fields - ID, SubName, DlyRate. The combo is showing the name only not the ID field. I tried changing the formula to reference the ID field but now I'm getting an error. I found a...

Hello, I have a form name frmInvoice and sub form named frmInvoiceDtls. In frmInvoiceDtls I put the below formula =DLookUp("[DlyRate]","tblSubs","[SubName]='" & [Forms]![frmInvoice]![cboSub] & "'") I want it to lookup up the subcontractor name displayed in frmInvoice in the table tblSubs and...

Hi...Can Grow is set to Yes and it is cutting off at the same point each time. I increased the size of the text box (both width and height) but it's just stopping at the same word as if there is a limit to the text entry. I did over the whole report last night and so far no problems...just not...

Thank you :)