Search results

Creating new table??? Hello I have just finished creating an Invoice report. Basically I want to know how I would keep track of the invoices that have been paid?? On the JobsDetails Table I have and Invoice Paid field data type yes/no. (checkbox). I want to know the best way to keep track of...

I HAVE FINALLY DONE IT!!!!! Hello everyone just a little thing to say that I have finally done it. I know it took a bit of asking but its done and it works. I do have some other questions bout invoices but they don't belong in this forum so I will be moving on to another one> Thanks to all you...

Where is everyone ?? Please help me with this last thing As soon as this is sorted I will be away . I just really need the formula that I was chatting about above Please someone out there help me!!!!! I IS BEGGING YOU,,,..,.,.

BIG QUERY Hello only me again Right I have worked out the VAT business and It is working pretty proud of myself even though is was RICH who done most of the work. But now I have a problem with calculating the TOTAL TO BE PAID I add the formula in the text box and when I run the report I...

Thank you so much Rich. If I could I would give you cuddles and kisses but you are to far away;) . I know you probably think I haven't got any sort of brain in my head but I have (Could've fooled you init?) Thing is I haven't been around anything that remotely used any brain power for since I...

Thank you so much This formula is to get the grand total then yes??? So the one I am using to get the VAT (cos you gotta put the VAT amount on the Bottom of an invoice) is right?? I am gonna wait for your reply then try it on my database hopefully it will work now. When I was trying to get...

Hello me again. Thanx for that I know i said that I would leave you alone but I didn't know that I would run into trouble so I will apologise now in advance if you are getting annoyed with my dumbness???!!!:D Before I put the formula in that you have recommended me to use for the "Round...

How do I do the Rounding function??? I would just like to clarify something: Is it better to run the calculation just in the report or in query or both??? This is probably a stupid question but I have been told so many different things from books and things that I just want to know for sure...

Thanx again but I don't seem to understand what you mean by property sheets could you let me know what they are?? Thank you for taking time to answer me again I really appreciate it. And I apologise again for the mistake I made in the beginning I won't do it again now that I know. Thanx Rich

Thank you thank you thank you!!! Is it really that simple?? I tried something like that before but got loads of numbers. like 125.231546 I need it to look like currency ya get me?? If it comes out like this again doing it the way you suggested is there a way to make it like currency??? As it...

Yes" Just me bringing the formula that I promised. The formula I use to calculate the VAT on paper. Now will I be able to use this on Access as a formula to calulate VAT?? If so then How do I do it?? If not then HOw else can I do it and what else can I do. Right this is the formula that I use...

URGENT!!!!!! Calculating VAT (sales TAX) Hello, First I must say thank you for all the help I have received from this forum and the others.(Tables, etc.) The new question I have involves calculating in reports. I have set up an parameter query to generate an invoice. I have done a report based...

Thank you for that. I really appreciate it mate. And thanks for welcoming me back. Not alot of people do you know. Done a few things wrong ya get me?? Any how thanx for the advice. I do have quick zip that I downloaded from the internet however it is not exactly easy to follow I don't think...

Stupid Question???? Hello I am going to apologise in advance about the question I am about to ask. In my defence I would just like to say that I have only just recently returned to the human race. I sorta went down the wrong path in life about 8 years ago and have just found my way back. Since...

Nice one for that link. Just been there loads of info if you got the money to spend (which I haven't experiencing a bit of Xmas skintness at the mo) but will check it after Xmas for definite. Nice one if you have any other Access information websites I would love to visit them. Let me know...

Missing Northwind "show me" button???? I wonder if you could help me on something else, and I am wondering if anyone else has the same problem. It regards the Northwind sample database. I hired The Complete Idiots Guide to MS Access 2000 from the library and in this book it deals alot with...

Hello I would like to know about using MS Access to invoice. Any advice or any person that currently runs invoicing from there database I would like to here from you. Basically I work for a Courier company and would like to invoice from my database at the end of each month. I would like to...

Hello thanks for that I will no doubt posting my database on here at some point as I know that I will need help that maybe can't be explained by me writing it. You experts may need to see what is happening to advise me better init? Thanx alot mate you helped me right out. Any more advice you...

Re carrying data aroung Nice one pal. I better start looking for one of them in England I've heard of them I hope there as cheap as you got one for. Any tips on using access for invoicing?? let me know yeah?? Oh yeah people this is probably the most stupidest question anyone has ever asked...

re nice one for answering so quick Nice one. No there will be loads of invoices in the end if the database works properly. So Invoice table and payments received tab yeah? See I was gonna set up a parameter query for the monthly invoice then generate a report from the query to print out the...