Search results

I have a pivot chart which currently has 4 field buttons on it I only want to see one of them. The one I use for my filter fields The Row, Column and Value fields really do not need a button attached to them. How can I hide them all leaving just the ones I want to show. Martin

I am trying to open a form that will display only the rows in my table where two conditions are met 1 is Country Code [CountryCode] 2 is Retail Chain [Chain] Theses are both stored on the same form I am trying to run the VBA from so I hoped that my VBA statement would look like this....but...

I have a query that has been returning unexpected (to me) results. After some interigation I have come to the conclusion that null values are the culprit. I am trying to average some figures. In the past I have used this to make sure any null values are passed through as 0...

Thanks Guys Love the discussion. Just for the record WHERE IS Not Null worked for me. But I'll bear in mind that it may not always.

I am trying to find the stores that sell the least amount of a product each week, when it is sold at least once. I am using the Min of sales with a where clause of >0 to elliminate 0 sales stores as in a year every store may fall in to the categeory. Max works fine but Min is causing me...

4 of you on the 14th and not a million miles away, hmmm You really dont want me asking stupid questions over pigs in blankets even if my wallet if full :D. Enjoy it guys, you deserve it.

You are blowing my brain, I get the jist but not the knowhow. I'm guessing you are talking about my previous post, which I have to go back to or I will not get anything done again today :(

You two are my guardian angels at the moment. Wish I could get you both some festive cheer :D

I have a report that I want to export to Excel however it is generally around 100K lines The reaqson for Excel is the pivot table and cahrt capabilities that Access does not do so well. Due to th efile size I cannot use the normal Excel Export as it truncates at 65535 rows I have added...

Sorry guys I'm posting my code so I can look back and laugh at my stupiditty later. This does the Unique thing and appears to work SELECT tblStoreMaster.CountryCode, tblStoreMaster.Chain, tblStoreMaster.PlanNo, Count(tblStoreMaster.StoreNo) AS CountOfStoreNo FROM tblStoreMaster GROUP BY...

Paul, that looks like sound advice... Hi namliam Ive looked at the crosstab, its like a spreadsheet and I can see why you suggest it. I'm getting results but the numbers do not add up. I think this is because I need a distinct count somehow. TRANSFORM Count(tblStoreMaster.StoreNo) AS...

no not VBA, Design View and stumbelling through SQL Sorry Guys I must appear so thick

Hi Paul It appears to trip up on the AS PlanC in the SELECT at least that is what is highlighted the msg box says... Syntax error (missing operator) in query expression 'Sum(IIF([PlanNo] = "C",1,0) AS PlanC FROM tblStoreMaster WHERE [CM-DATA].Week = (SELECT Max([CM-DATA].week) As MaxOfWeek...

Hi Paul You are of course 100% correct. The speed is awful, but I have yet to get my head around subqueries. I still struggle with left/right/inner and outer joins :eek: I understand what they are and am reading about them on...

Hi Mihail reading up on DCOUNT I believe you are correct and it should do what I want. However all my results are 0. Attempt to show Design View below

Hi I am trying to count how many plans a retail chain has over its stores. So WeekNo | StoreNo | Product |PlanNo 1 | 10001 | Dog | A 1 | 10001 | Cat | B 1 | 20008 | Dog | B 1 | 30005 | Dog | B Query/report to show Product | PlanNo A | PlanNo B Dog | 1 | 2 Cat | 0 | 1 Numbers in...

Hi CJ London I understand your point and I am using a subform connected to an update query I have continued to search the forums but none appear to help me, I'm using a check box. I have made a very small simple example for anyone to look at. 1 table with 3 records 2 fields 1 query 1 subform

I need to give the user the ability to select either all of a table say [tblStores].StoreNo or only those stores where [tblStores].StoreNo Is Null I cant for the life of me get my query to accept Null or Is Not Null in the parameter box. What do I need to do. Rethinking the problem is not an...

That is music to my ears :) i'm currently building a pilot case But when this goes live (hopefully in Jan 2014) I will have at least that maybe more. I still have to set it up for the data to be stored on SQLserver, Access will then just be the front end, I have no idea how to do that yet :eek:

I am indeed updating tblForecastMaster and this is an Access Table The data it is getting the values from was ForecastUpdate which was an Excel Linked Table. Apologies if I did make that clear :( I have created an import table which over writes each time from Excel and then update...