Recent content by Johnthelleader

I am sorry if this is old hat but I am pulling my hair out on this. I hope it is something simple. I have a form; record source is Table "Invoices" The sub-form record source is the same. Using the wizzard, I created a combo box whose source was the table "Invoices" field called Law Firm. I...

Good point! I have now added the Form and the report

Here she is!

Windows XP

Thanks for going to all that trouble with the sample database. I have done everything you have mentioned but the report is still blank when one of the fields on the form is blank. Any other possible suggestions? I don't have a file compressor so cannot convert the query into Zip format so you...

There are three fields in total; a name field and the two date fields. If the name field is left blank but a date range is entered then the report brings up for the date range. If a name is entered and not a date range then all data is returned associated with that date. So far if a name is...

Yes that is right rainman89. So should it be something different?

I have tried the following: Criteria: Between [Forms]![Invoices]![Invoice date 1] And [Forms]![Invoices]![Invoice date 2] Or: Is Null But this does not work, it just returns blanks!

Thanks for coming back. I am sorry but the code was in the Criteria section and not field name. Any ideas on how I sort out the null value issue?

I am having trouble with some code I am using on a query. Part of the query comes from two fields in a form. The rest comes from a table. The query then populates a report. The code I have written works fine. The trouble starts when I try and enter in some code so that if some of the fields in...

I am trying to produce a report so that it groups figures greater than 50,000 and then over 100,000.

I have got the following code as an expression for a report: =Int(([Amount])/50000)*50000 & " - " & Int((([Amount])/50000)+1)*50000 How do I get it to pick figures greater than 50,000 and then figures greater than 100,000 plus?

I have created an invoice database. I have got various standard reports made up. I would like to be able users to create their own reports to their requirements. So for example create a report for invoices under their name. Ideally, this would be selected from a combo list from a form and/or a...

That's great that's done it. Thanks for you help.

Thanks for that. That is certainly what I want. However, as the Add New Invoice form is a pop up form, it stays on top, whilst the form showing the duplicated invoice is behind it. Is there perhaps some code to make the Add New Invoice close after I have hit the OK button on the warning box that...