Search results

Yes, the format on both the table field and the form control is set to Currency. That's what I meant (but didn't state explicitly) when I said I'd changed the format to General Number and back. Which I've done to both field and control. Anyone else have an idea????

I have a form with various controls that reflect dollar amounts. One of those controls, despite deleting and replacing it, despite deleting the field whose value it displays, despite changing it to 'general number', saving, then changing back, despite comparing its properties with that of...

Actually... Never mind. It's finally sunk in, what you said about tax RATE. Each transaction has to store the tax rate, which is not a calculated value, but imposed from outside, in order for old records not to recalculate themselves by a new tax rate. I'd neglected to think about it being...

Thank you, Pat. Sorry if my explanation of my situation had been less than clear. When trying multiple different unsuccessful routes, I tend to lose sight of things. I've had the cost coming up ok, and using the code for Taxable also works (both your last suggestion and a couple of others I've...

Pat - Why does anyone do something that makes no sense or is wrong. Out of ignorance, rather than some perverse sense of deliberately hamstringing themselves. I'd realized that the Taxable field was not coming across into my tblPurchased_Items from tblPurchase_Items. I didn't know why and was...

So, you want the user to be able to select which field in your table you want to get more information on, then have them be able to type into a field to identify the exact record you're looking for and display other information about that record, once it's narrowed down to one? If so, I think...

Well, Big.. this is what's confusing to me, or part ofit. I'll be referring to earlier instances of the same form: frmTransactions. Today's frmTransactions needs to look at previous frmTransactions. I need to know how to distinguish between fields of the same name on THIS and PREVIOUS...

I'm not sure what to search for to figure this one out. My searches, so far, haven't helped me much. I'm tracking transactions in a clinic. The amount due for the visit is calculated fine, but sometimes people don't pay right away. (And sometimes pay ahead, which will just be a negative amount...

Pat - I know that I don't know about keys very well, but both tables have primary keys, both of which are Autonumber fields. List of available products and services, some taxable, some not: tblPurchase_Items Primary Key = ItemID List of things actually purchased in each transaction...

Looking closer, I'm sure that the value of 'Taxable' is not being passed from my Items table to my Purchases table, so the code just can't tell what the value should be. I have a relationship set up between the fields named 'Taxable' in each table, but it's "indeterminate" and if I try to...

Thanks for the suggestion, Gumby - I will explore the "-1" option... but SUM doesn't work on controls, only on fields in a table and, since storing calculated numbers is bad normalization, I don't think your idea will work for me. But is -1 how Access values a Yes or a No? It's not 1,0?

I have a combo box with the following 4 columns: ItemID, Item_Name, Item_Cost and Taxable. The fields are Autonumbered, Text, Currency and Yes/No, respectively. I am trying to SUM sales tax, in the form footer, based on the Yes/No settings. Some items are taxed and some are not. So far, I am...

I have a form that currently adds services and products paid for by a client, via subform calculations, indicates payment, via cash, check or charge, and shows, finally, what is still owed. This is for a clinic and some old folks, for example, pay small amounts over time. The subtotal, sales...

Thank you, Pat. Sorry about the dual post. That syntax works. So, my previous #error was because I hadn't included the nested Nz function, it looks like. The Nz, in this case, prevents a Null, where no item has yet been selected, from messing up the calculation, correct? It forces any Null to...

I have a subform listing items for purchase. Some are services and are not taxable, some are products and are taxable. So far, I am calculating the sales tax for each record (item paid for), based on whether the thing is taxable or not and putting that result in a text box (txtSales_Tax) on the...

I have the controls for doing the sums in the footer, already, Pat. Working with ScottGem, I found that they don't seem to work on calculated controls, just on values stored in fields in tables. That's how I ended up trying to get code for this working in the Control Source in the first place...

Actually, I have gotten a sales tax control working within individual records. By creating a control bound to the Taxable field, and having the IIf statement look at that control for "True", I am able to calculate tax where I need it. Trying to look at the Taxable field in the table just wasn't...

Thanks for the info, Pat. Knowing more about brackets helps. I've "gotten it" with regard to field and control names. None of them are the same. Fields are named, controls start with txt or cbo or lbl, or what have you, so none of them are the same. The quantity value ought to be valid. It's...

Thanks, Pat. This is very similar code to what I'd tried. Access put square brackets around "Taxable". Is this expected? It's still not clear to me when they should be there and when not. In any case, the code doesn't work, as is. All I get is zero in that control. Tweaking it in various ways...

I'm creating an order form for a clinic. Health-related services are not charged sales tax, but products are. In order to have one subform to do the job (rather than one for non-taxable and one for taxable items), I'm trying to create separate running sums of taxable and not taxable items from...