Search results

Hi, I'm sorry, I don't follow. I got the IIf statement off the internet when I searched for help with the Divide by zero. It seemed to work for a short while until I added the multiplication. Where do you believe I've gone wrong? Thanks,

Hi, I'm trying to run a query that calculates a figure over a certain number of months. The exact calculation is: Contribution Value divided by Duration of Works I then have the report set up to take into account the Anticipated Start Date. From this date it takes the results from the above...

Minty, Wow, thanks! Seems too simple when you see it in front of you, however can be frustrating feeling you're miles away from the end results! Huge help, thanks! Chris. :)

Hi, I want to update a record when I select a specific option from a combo box in a form. The concept seems simple, its the code that I struggle with... I have a combo box in a form that has two options -- "Won" or "Lost" I have a field in my table called "DateWon" When I select "Won" from...

Hi, I'm hoping that you can help me with my issue. I'm trying to use the Totals function in Reports to total Sum our Quote Values. The field that is being totalled is from a calculation in a query that makes up the report itself. The calculation in the query works out the ContributionValue...

Yes, apologies. I have the Tables and Forms. They are. tblFitterOrder FitterOrderID* OrderNo Fitter InputDate ProductID (FK) tblInstallStages InstallStageID* StageInputDate StageQuantity Paid DatePaid FitterOrderID (FK) The forms I have are one for entering the Fitter Order and select the...

Hi all, I'm hoping you can help me with a small question I have... I have a database that we use for our Fitters that install our Products. It works simply by attaching an Order No and Fitter next to a Product. At a later stage once the fitter has installed the Product, we input the quantity...

I've found it also creates 5 blank records in the source table. Directly underneath the record I created?

Hi, Thanks for this! Apologies for the stupidity. I've changed the code and it now works by generating a sequential number, as desired. However, It shows me this error: "A data macro resource limit was hit. This may be caused by a data macro recursively calling itself. The Updated (<field>)...

Also out of interest, how would I do option b? Thanks,

Here's a snapshot of the error...

Hey, Thanks for the reply. I've changed the expression to the beforeupdate of the form and changed to square brackets for the table. However when I try to close the form, It opens up the debugger and says: Error: Syntax error and highlights the entire expression. Any ideas?

Hi, I'm trying to create a simple command button that will generate a sequential number using the DMAX function. The database will be used only by one user so I wont have the issue of 2 users attempting to use the same number. I've spent some time looking through this forum to try and find...

Hi pbaldy, After playing around with it last night, I managaed to successfully get the report to total up the Total Appointed Charge. However, when I've run the report and calculated the figures myself, the total for the Delivery Allowance seems to be incorrect. I know what the issue is...

Nope, it's still not letting me do it. It allows me to insert the text box and include the formula in the source. However when I open the report the text box shows 'Error'. I'm definitely inserting it in the report footer. Could it be because the Appointed Charge field is calculated in the...

It doesn't appear to. Gives me an 'Error' result. I have a report that shows me the cost of the deliveries based on the mileage. It's a pretty basic report that works by listing all the jobs, the total miles travelled for each and gives me the appointed charge for each job (which is the...

Hi, Is there a way I can sum a calculated field on a report? I have a report that calculates the cost of miles travelled. Under the Detail section is a text box which totals the miles using =Sum([Appointed Charge] However, I'm looking for a way I can include a text box in the...

SELECT [Materials Requested].[Job No], [Materials/Orders].Total, Jobs.[Project Name], Product.Despatch FROM Product, Orders INNER JOIN (((Customer RIGHT JOIN Jobs ON Customer.[Customer ID] = Jobs.[Customer ID]) INNER JOIN [Materials Requested] ON Jobs.[Job No] = [Materials Requested].[Job No])...

Hi, How can I include a field from a table in to a query - that has no relationship? For example... I want to know the cost for all materials on each job - I can get that answer. However, I only want to know this for jobs that have been despatched (indicated by having a '2' in the field) The...