Search results

Hmmm I'm getting #Error slight change to your example "[]" =Sum(IIf([Type]="STD",1,0))

I have a report where I have added a package type to my Query (STD or XL) I have currently included this in the report although I dont need to show it, however I do need to show at the bottom of my report how many rows are Type "STD" and How many are Type "XL"

Maybe it was because I was changing it and didn't delete enough of the code. But thanks I will bear it in mind for next time.

Thanks Paul, That was just what I was looking for

Hi guys and gals [I moved this from Macro to here as I think this is a better place for it] I am probably going about this all wrong, so let's just call it a learning question. I have a need to display a pivot chart by clicking a button on my menu screen. At the moment my button will just...

Well I dont understand that, You are quite correct. it must have been later than I thought last night as I could not get it to work. Thanks for your help

Hi I am trying to run a query over a single table that will show me how many stores have a range of products in stock Access does not have a distinct count and googling has not helped much, maybe its me. My table looks something like this: tblSales StoreNo UID Stock 11112 T123 13 11112...

Hi Paul Thanks for your time. I am getting the same result for everything and I know that is not correct. I had to ammend your code a tad so maybe thats my problem. SELECT Combined.Country, Combined.Chain, Combined.Year, First(Combined.WK_No) AS FirstOfWK_No, Last(Combined.WK_No) AS...

This worked for me SELECT Table1.EmployeeID, First(Table1.TimeFrom) AS FirstOfTimeFrom, Last(Table1.TimeTo) AS LastOfTimeTo, Table1.EmployeeID FROM Table1 GROUP BY Table1.EmployeeID, Table1.EmployeeID; [Change names to suit]

Hmm maybe an example will help, as I dont have enough credit I cannot attach a link to dropbox so here goes: Combined Country Chain Year WeekNo ProductID GB ABC 2013 1 A GB ABC 2013 1 B GB ABC 2013 1 C GB ABC 2013 2 A GB ABC 2013 3 A GB ABC 2013 10 A My Query needs to show Country Chain...

Hi Guys I have seen this discussed in various places but I cannot for the life of me make any of the suggestions i've seen solve my problem. I have a query that pulls out first and last week number. I wanted to add a count of distinct week numbers to see if there are any weeks missing...

Hi David, No I havent, But I can ask if there is the possibility of doing so. In my ignorance can you describe what you mean by "Splitting the Database" and when you say SQL Server backend are we talking about where the sales data is stored or the whole database. Martin

Hi I have been working with Access for about 2 months now and using sales data have created a nice simple working database. My problem is that I have just started to role this out for more customers data and my database just went BANG. My initial database had a table with 390,00 rows of data...

OK guys you may have guessed by now I am a dangeriously new user of Access. Field MinOrdQty:Val([fieldname]) seems to work was that what you had in mind?

I have a query and one of the fields currently contains alphnumerics: 4 units 5 units 8 units etc. I want my query to just bring back the numbers 4, 5, 8 etc the highest value is 60 units so in Excel I would have the option of using the formula: Left(a1,2)*1 By multiplying the result by...

Hi JHB Apologies I have not got back sooner. I have looked at your db and, well it works. However I have no idea how and because of that I cannot apply it to my current build. :( The fact it does work is amazing, so many thanks for the time you put in. Would you mind stepping through the...

I've stripped out a subset of the data this is the file I pull in from Excel www DOT Box DOT com / s / uc84lynn3au5pkrmdvov (remove spaces etc) It does not contain a date, however its easy to add one before importing or maybe Access can add the date on import. I use this excel formula to...

Hi JBH OK I'll keep this as brief as possible, if further details are needed I'll fill in the blanks :rolleyes: I am attempting to create some sort of forecasting tool. Historically I have been using Excel as thats where my best knowledge is and what I do best. But this is a new job and the...

I have a spreadsheet that I am importing weekly. it only contains a year and week number I could add the week end date in excel using a formula like =DATE(A2,1,1)+((A1-1)*7)-WEEKDAY(DATE(A2,1,1)+(A1-1)*7,2)+6 which basically takes the two fields and converts it to an excel date in another...

Apologies if this is so easy in Excel I'd do this in VBA, in Access I haven't a clue but assume SQL can do this. I am trying to get a user to enter a year and week number and get Access to append this to Table "A01 Date" This I have managed by creating a Query Qry A01 Enter Date 1 Field Y...