Recent content by MsCrow

Hello My mother is working on a new database to handle event people and bookings. For these events she wants to book people on activities. For each booking, they can attend many activities. These person activities are stored as a sub form to their booking as a register. It draws from the event...

:cool: you star, thank you so much!

Hello I have a form, of which part of it works out the costs for labour - see gif attached. The formula in the total field is: =[Labour_Rate]*[Labour_Cost_Days] which is also used in the related queries for reports. Thing is, it doesn't like 0.5 being entered in the days/hours field and...

hello In my table/form I have 'business name' - which is linked to an ID number, 'forename' and 'surname'. In a form the user select the business name from a drop down box, i would like the form to then automatically insert the customer forename and surname rather than retype it. How can i...

anyone please?

I have a form with a button which is sort of but not really working, connected to a word document with mail merge elements of a query linked to the form - this ensure only the current record is extracted to the query/report etc. It's not working, ideally, I just want it to open up Estimate.doc...

you wonderful wonderful person, you've assured me a decent sleep tonight :) Thank you so much. Ellie

ahhh ok then, makes for some long sums though! especially wen it comes to the total invoice charge one. is there ahy esier way? How do you mean by refer to the previously calculated field - would that make the sum shorter? Ellie

i realise that, and would have done so but couldn't work out the relationships and got into a bit of a tangle. Solved the one i edited out - sorry hadn't realised you replied - by: Charge...

ugh, still a bit stuck with the other two. Following your advice I've done: Total_VAT: [tbl_Jobs].[Charge]/100*17.5 and when running the query, they're blank

thanks for replying :) where would i put that code? in the query i can only add tbl items edited to add DUH, i've done it :)

oh dear, i can't get it to work - i'm new access user, kind of. when i run the Estimate or Invoice queries from the frm_Units you'll see the error. i would like to be able to save all the sum fields to the table but does that mean they're not changable?

Thanks for replying, how would I make sure the sum results showed up in the report/query as if they're from the table they're of course blank. E.g. a query uses 'Charge@ but there's no data in it as i can only select tables for the query to use not forms

Hello, I've searched here but didn't find any help so I hope someone can. I want a sum from two entry boxes in a form to do a sum and update the table. It's to work out a labour rate but though the sum works nicely and always shows in the form, the table field 'Labour_Sum' remains empty. The...