Search results

I think I will be able to nest the calculations so they are done first, then include them in the query. is best way SQL or VBA? PS. I am proficient at neither.

thanks Ebs17, very handy that link. 50* nested queries. ye ha!

I have a table that has general info the other tables for sites, reps, parts, manufacturers etc I am building a query where calculations need to be done and then fed to another query, but I will still need to link to the original table again eventually. It seemed to me inefficient. to go round...

Good afternoon good people, How many joins can you have on a table?

thank you guys, Form it is!

Thank you all, I suspected that report may be print only. I also thought the "form" was for inputting data to the DB. I want to look at an analysis by each sales rep, then the next rep etc Without going through a new query everytime.

Good Morning Good People Can the report facility be made interactive so that its possible to scroll through the table by client or part number etc or is it to produce something that can be printed off?

Thank you, I would rather it stay usable mathematically.

Thank You for your kind words and support George.

thanks @The_Doc_Man Will that calculation go into SQL anywhere, and if so where? as part of select?

Good afternoon Good people, I am old and overweight with various age and weight related problems. I am trying to correlate my health with me weight. As my weight goes up I get foggy head and various other problems etc, MY weight is recorded in pounds, it fluctuates between 235 ad 250. My brain...

@The_Doc_Man The database is already in existence, it has 50 tables with 20-25 fields in each table and100's of thousands of rows in each table. I cannot do anything about it really. I do not like the output that it generically spits out so I am trying to learn how to manipulate whats in there...

I have changed the resoloution to 125% and black background and that has helped a bit

Ha Ha, I have three monitors set up. two 20" and a 24" at top. I want the whole page bigger. Are there no accessibility options?

How can I make the writing bigger on the screen? I can hardly see all the comma's and dots.

Hi June7, I am new to access, I do not even know what is possible never mind how to do it. I have ordered 2016 access bible and 2010 programmers reference so I can try to get a handle on whats possible. At the minute I am trying to translate my thoughts into data, I have hundreds of questions...

Thank you all so much, This little problem has been a fantastic learning experience for me. I think that I now understand the "group by" operator. My goodness, that is one powerful command. Formatting through the field properties sorted out the display issue. Apologies for being PITA but every...

Thank you Gasman, that appears to be it. Whats causing it is recurring number on the decimal place. Is it possible to limit that to 2 decimal places?

This worked out very simple in the end Select saleitem.sales, avg(sales.price) As AvgOfprice From Sales Group by saleitem.sales; far simpler than my thought process, I just wish I knew what does what. 67,000 rows took a matter of seconds. thank you all for you help and direction to relevant...

Thank you @The_Doc_Man