Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: GPnew
  • Content: Threads
  • Order by date
  1. GPnew

    Power Pivot Filter out Rows where data is not in all columns

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

    Power Query

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

    Power Query Extract from pdf

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

    Access 2016 report export to excel column order changes

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

    Give each line in group the same number on a report line

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

    How Use VBA to upload attach file to webform in Internet explorer

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

    Outer join or Union or

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

    Excel match #value

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

    Excel Pivot Table Max Date

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

    Pivot Table Excel 2007

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

    Access Subquery in select not working

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

    Access Query

    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 =...
  13. GPnew

    Print and Save after previewing

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

    Import Word Documents to Report?

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

    Outlook 2003 Add Contacts

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

    Function on Subreprt Error

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

    Record Bottom Line of Report

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

    Sumif Range Problem

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

    Query runs before On Open Event

    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, , , ...
  20. GPnew

    USB 1.1 & 2.0 KB822603

    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

Part and Inventory Search

Back
Top