Search results

What do you do when you want to total more than one? I tried a text box with =SUM([product1]+[product2]) or =[product1]+[product2] but nothing seems to work. =SUM([product1]+[product2]) should work, are you putting it in the Report Footer section? Are both the field set to the correct...

SQL SQL - Structured Query Language. It is the name for the language used to compose Query's for retrieving, updating appending ect data. There are many sites in which have crash courses on SQL. its not very difficult once you get used to it. If you would like to see some examples makes some...

Thank you so much WayneRyan. Looking into it now. Sincerely, Jordan

I cant figure out why whenever I run the report, when including a subreport it prompts me for a value. The Value its asking for is the tblInvoice which is the name of my invoice table. I think the wizard is the problem but im not sure? Anyone else run into these problems?

I have a report that prints cheques, it works great. It is based on a 3 table query. It displays the Cheque, and payment details after. I then added a subreport, to show how many passengers the cheque is paying for, this is done by associating the invoice ID in the invoice table to the...

Thanks all, I used a report and it worked great. Sincerely Jordan

I was wondering if anyone uses a template to print cheques through access? Has anyone had to do this? Is there a report template you know of? What would be the best way to do this? Use a report? Any help is appreciated. Thanks Jordan

Thanks:) 10 hours coding and my head was starting to explode, thanks again:)

I left clicked on one of my querys and set the property to hidden, I cant figure out how to find it now, is there a way to see the hidden queries? so i can set it back so I can view it? Thanks. Jordan

Thank you so very Much, not only have you helped me considerably you have shown me a method i never knew before. Thank you again. Sincerely, Jordan

I have 2 destination Tables: The table looks like: Code Airport1 Airport2 Airport3 Airport4 Airport5 AP1 $ $ $ $ $ AP2 $ $ $ $ $ AP3 $ $ $ $ $ AP4...

Here Ya go On your form you can have a command button open a report any time you wish by using the wizard. Click on the button and draw it on your form, it will begin the wizard. Youll have to create the report first by doing this: Click on the reports tab and then click new, it should open...

Answer for the rookie: You need to do some more reading, you were putting the info in the page footer section and not the report footer section! WTG Brainiac! Yes I answered my own question:P but I read up on some old posts:P heheh

Ok Ive completed my inputing and recalling data features, now its time for me to hit the reports, it seems I need a little direction is someone could give me some:) All I need to know is at what level do I SUM currency data if I need to display the total amount of all records of payment. For...

Thanks for the help, I must not be implementing it right, it doesnt work when I do. I appreciate the time though.

Thanks! Great! Thanks So Much, Lastly, Where Should I put this to test? in the Total Text box, BeforeUpdate event? Thanks Again.

Hey all, I have 5 Text Boxes: 1: Name 1: 2: Name 2: 3: Name 3: 4: Name 4: 5: Total Number of Ninja's: What I need to do is, I need to check if each of the first 4 text boxes (names 1 through 4) contain data, if they do, I need to add a count of 1 to the number of ninja's box. The name...

Thanks! Ok gonna try some of the suggestions, thank you. I was sort of hoping I could use a CountBlank Function like i did in Excel but I guess not:) Thanks for the help. sincerely Jordan

A bit better explanation Ok the DB is used to store invoices. 1 Single invoice can be used to purchase 3 plane tickets. So I have 1 Box Passenger Information: (user enters the names of the passengers into this box, I am using a text box and currently they separate entries by commas) Under...

I have a problem, I need the user to enter in 1+ passenger names, then I need the number of passengers to be automactically calculated so Billing is not skewed. My problem is, I was using a large Text Box to store the multiple names, I thought I would be able to separate the values and count...