Recent content by bookrackonteur

Yes I had a little time to experiment with that this morning - I've tried a few optons with mixed reults - many work, so just trying to figure out performance, and also working through my design trying to figure out if I can make the underlying summary query more efficient as well. Im...

(SELECT Max( FairID) FROM qrySalesTtlID Where Employee=[School] AND FairID<(SELECT Max(FairID) FROM [qrySalesTtlID] Where Employee=[School]);) Thank you! Somewhere out there oneof the pages suggests discovering Subqueries are a Eureka! moment - maybe so! The above syntax works but I wasnt...

The Metric is EventID Sorry if that wasnt clear - The event that just happened this week is EventID 192 So the query I showed above totals everything associated with EventID 192 So then I see King School SchoolID 54 EventID 192 Total Sales 900 The previous King School Event last year was...

I don't because its the sum of 2-10 different entries that are all around a certain date

I have a query that sums sales totals based on EventID and School ID So ColA(totalSales) ColB(EventID) ColC(SchoolID) 1000 154 1 1200 134 2 900 155 1 Then I have a...

are you saying to maybe import all this stuff to a different DB, clean it up and then import the nice clean table? that is intriguing.

hi, yes, I saw you comment on a similar post and downloaded that to take a look at. Publisher and Author arent normalized right now because the data we get in is so varied, we have a separate report we run to tidy it up, but this may help fix that problem if we put the garbage into a related...

Ok, this seems doable and sensible- there are 3 major sources, that have formats I am familiar with, and I can see what other formats I get. thanks! Also, if I recall, if I need to edit an import Spec, that's an unusual process because theyre stored in a hidden table? So if you do have any...

I wasn't sure where to post because I'm not sure I have the right concept for this. We have a table with book data ISBN, title, author, Pub, PubDate, StartDate(ie Fall25) We import that data from a couple different places depending on how we ordered it, and of course every place sends their...