Search results

GST is taxes, I just either omitted the column and forgot to delete the reference or forgot to add it.

Wow StarGrabber, thats amazing! I don't know much about SQL code but its not crashing anymore. I'll have to see what you did that prevented the crash. This will take me some time to figure it out :) really appreciate all the help you have all done for me. Thank you, thank you, thank you.

using Nz([Daily WO Query].[Form]![TotalPayment]) gives you the grand total of all, if you go to Jan-25th, you'll see a value for master card. the 'transaction types' (showing in white) will give you the totals for each 'type' for that day. This # should be the same that shows in totals (for...

You'll have to forgive me but I don't see where there is a problem. The names may not be as per the way you recommend them, but whether the form is called frm, or form, how is that going to correct the issue? The code =Nz([Daily WO Query-debt].[Form]![TotalPayment]) or...

ok, the database should be here

i have it down to 1.35mb but i don't have anyway to upload it, suggestions?

if it would help, I can email you a copy of the database. Its about 12MB in size. Feel free to email me darren@tagervision.com

[COLOR=black]

I'm in Northwest Alberta, Canada (MST) Mountain Standard time. [TotalPayment] is a text block (and name) in each separate form/subform. It totals the full value of that form (i.e. -Master Card Payment) =sum([Payments]) called "TotalPayment" the results of this is either a number value (or)...

Q. Did the First Calculation work when Data was there. - A. No. it always gave a value of zero; In order to get a value the code would have to look like this:=IIf(IsError([Daily WO Query-mastercard].[Form]![TotalPayment]),0,([Daily WO Query-mastercard].[Form]![TotalPayment])) --> this code gives...

I tried your suggestion and it didn't crash but it also would not take any record that had data -always showed zero even though there was a record for 25.00. (Note* when i put this code into 4 seperate text boxes (one for each category) the system eventually crashed)

@Rainmaker: I have a table that has all the records for each sale slip which has the $ value, discounts, gst, client, and payment method (The payment method is a picklist from another table - mastercard, visa, cash, debt, etc). From this I use multiple queries to seperate the $ values by the...

@Rainlover - you are correct, there are no records for some of the forms. But the code works and gives me a zero value if there is no record (or has an #error) but also gives me the proper value if there is something entered. - but its crashing access. I am trying to take a value that counts the...

I did as you said and imported it into a new db; worked for about 5 clicks then got a crash and this popup "Microsoft Office Access has stopped working A problem casued the program to stop working correctly. Windows will close the program and notify you if a solution is available" Then it...

OK, here is an update. This code works BUT, seems to crash Access: =IIf(IsError([Daily WO Query-mastercard].[Form]![TotalPayment]),0,([Daily WO Query-mastercard].[Form]![TotalPayment])) Any suggestions?

Its not in a table, its from a query as a Sum calculation. But that record does have a default of zero, but in order for that to take action, there has to be a record created each day The issue is that there are no records, but i need the value to add in a total because i'm using 4 different...

I'm using Access 2003 and have an issue with getting a zero value from a query (or) form that has no records. It works great as long as there is at least 1 record but not for a 'no record' issue. I've used Nz; IIf, and IsNull and the codes work providing i have at least one record with data in...