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