Search results

Good Morning Good People, @cheekybuddha What had I done wrong to cause the data mismatch error? I am trying to understand and Learn I think that I have called a number field a string where as CJ original code the field was a text field cname=' OrderId=' does this act differently on a text or...

The day rank messes up as soon as the data table includes extra days. The extra dates taken out.

Yes that works on unit price, I had it like that using DESC. However the dayrank has gone to pot.

clearer CODE. SELECT ftq1.odate, filtertable1.orderid, ftq1.sumofunitprice, Dcount("*", "ftq1", "sumofunitprice>=" & [sumofunitprice]) AS DayRank, filtertable1.unitprice, Dcount("*", "filtertable1", "unitprice>=" & [unitprice] &...

Hi cheeky buddah, Thank you. I have to click the OK 10 times, once for each row. Then the data is produced with "error"

Yes George you have hit the nail on the head. It is very useful to me. I have tried to explain in previous post. there is lots of other data to be tagged on, this will be the basic sort.

HI George, Thank you for trying to help. I have used the northwind type data as a way to express my attempts at a soloution to the problem I have. The field names are irrelevant as I can transpose the theory to the real world DB In reality the "orderId" is the sales rep who worked on a...

This is what I am trying to achieve. a loop (i think) through each date and perform the analysis then move to next date and perform same operation on that day then move to next date. I hope that makes sense

I have input 3 days data into a small table

Hi George, that is not the specific issue I have, the date format was just to come up with a way to present data for inspection

I did have it working By day, but when I try to include several days data ( with the same mini report needed for each day) I cannot guess the loops

I have made a new table. Then adding together the prices on each orderID Giving me these total for each order I have then tried to order the day totals and within each order the Hi price and rank 1-------whatever The first part has worked Disclaimer ; I am no where near experienced...

its the Northwind "orders" table where all orders contain date and time stamp I want to filter on date only and its messing me up. I will create my own table I think

Hi Majp, You must be psychic. I have run into the first problem with sample DB. The date has a time function added to it. When I filter by date only it does not pick anything up due to the time aspect of the field. DOH.....

thank you majP

Good Afternoon Good People, I am struggling with an idea and need your help How do I lift a table from a DB and post it here so that you can see what I mean. I can also lift two queries to show my attempts so far, hopefully so that you can provide any guidance that you think would help me.

club sandwich

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...