Search results for query: *

I have created a power pivot table to show the % year on year (23 to 24) change, of the weighted average prices per part Not all parts had sales in both 23 and 24 = TRUE in the last column I would like to filter out the TRUE's or even create a slicer on that column When I dragged the column...

I am newish to power query and have been struggling with the following when I think it should be quite simple I have loaded data from a pdf file. On one of the 30 or so lines of imported data that should be in the [Name} column , appears incorrectly in the [Employee_No] column. Therefore a...

I am extracting data using power from a pdf file with headers and was wondering if there was an easy way to transform the data into a data cube in power query eg currently it imports like this Dept Sales Jo Bloggs 120 John Smith 100 Dept Sales Total 220 Dept Admin Ned...

Hi, I am exporting a report to excel but the order of the columns changes. I have checked the tab order and made sure they was correct. Also tried removing all the fields and adding them in order. This worked for most except on a calculated field that ended up in the last column Any Ideas

I have a report that typically has 3 or 4 groups each with 2 sub groups ..ie group within the groups I am trying to assign a number to each subgroup and show it on the report . eg I need to show the number 1 in the first column on each line in the first sub group, number 2 in the first...

I am populating a webform on internet explorer using vba I have succeeded in doing so with textboz, check box and drop down selections HOWEVER I cannot get the code to upload a file As below I am successfully using getElementbyId to identify the field to populate the form...

This is a cut down version of my problem. I am sure the answer is so simple I have a sales and budget table Sales ID Period Sales 1 1 200 2 3 300 3 4 500 ID Period Budget 1 1 100 2 2 400 3 4 50 I would like a query to produce Peron Sales Budget 1 200 100 2 0 400 3 300 0 4 500 50...

Sample Dahttp://www.tek-tips.com/threadminder.cfm?pid=68ta a 55 56 57 55 56 b 12 12 12 13 13 Trying to return the column number where row a = 56 stored in F5 and row b = 12 (F6) The answer should b 3 This is what I have tried =MATCH(1,$F$5=$A$1:$F$1*$F$6=$A$2:$F$2,0) Result #value...

I am trying to create a pivot table to show in the grouping , the last (ie maximum) payment made by a debtor who trades with several companies (NAME) in the group . Debtor Name DDDATE Amount Closed CO NBC Brands Ltd 21/03/2012 3,003 Closed CO ABC Ltd 17/09/2012 1,000 Open...

We have 4 trading companies who often sell to the same Customer We combine the debtors reports though a pivot table in excel to understand each customers total debt with us. The pivot table shows the amount the customer owes to each company and then sums the group. All that work fine. But we...

Simplifying my sql Select a.accountcode as Test , (select b.accountname from b where b.accountcode = Test) from a I have found the parameter 'Test' (which is a number) is not recognised in the subquery. However I have found the following works in the subquery (select b.accountname from b...

I have 2 table I wish to join. It's an account ledger The tranaction table (GLTrans) had a field DrAccount and another CrAccount. The other table is the chart of accounts (Chartacc) which has a field Accountcode DrAccount must always = a Chartacc.AccountCode ie GLTrans.DrAccount =...

I input data on a form then click on a buttom which preview how the Invoices (Access report) look before printing. I currently print off the standard menu bar. I need to save the date to the DB at the same time but there is no Onprint event in which to put my save sql ? On which event do I...

I have 5 Documents on WORD ...including bullet lists and tables of Contents. There are only 3 or 4 peices of information in these documents which come from the Access DB. I would like to incorporate the documents with reports in Access and ideally keep them all in one location ie the access...

I have received an email of which I am one of many recipients. I would like to add all the other recipients to my address book. Is there an easy way of doing this ? Thanks

In Access 2002 i have a function on a subreport the is returning #error. It works fine on the main reprt Its control source is =UseDefaultCodes([ProductCode],"CARTSTAFF") The [ProductCode] is the link to the master form The code is Public Function UseDefaultCodes(PCode As String, ExpCode As...

I have created a report in access (2000) to work our the costings of our 200 products ...there is one page in the report for each product ie 200 pages . The report is quite complicated ... it applies wage costs and other overheads ...so I have used sub reports and (too) many textboxes (for...

The following formula works =SUMIF(Month,"<"&MonthNumber,INDIRECT(V23)) where cell v23 contains the following concatenation ="'Food Last Year'!$C" & MATCH(B$23,LYIndex,0) & ":$N" & MATCH(B$23,LYIndex,0). This gets the range I want i.e. 'Food Last Year'!$C6:$N6 where 'Food Last Year' is the...

My form has a record source that is a parameter query. The "parameters" are to be obtained from a second form that is opened in on open event in the first form as follows Private Sub Form_Open(Cancel As Integer) On Error Resume Next DoCmd.OpenForm "Month Report Dates", acDesign, , , ...

I have installed (or I think I have installed) the 822603 fix however I am still being prompted to install it again. Can somebody please tell me how to check whether it is successfully installed and then how to stop being prompted to install it again Thanks