Search results

  1. W

    Paste Address values to new Word Document

    Hi. . I can't really find anything related to what i need. I need to be able copy a current records field values, load up a blank word document and place or paste the field values to the document. My user does not want to hassle with mail merge, they just want to be able to get the current...
  2. W

    summing different multiple amounts with grouping

    hey all, thanks to anyone that can help i have 5 fields facid custid empid amount invdate. i need to be able to get totals on the amount based on fac, cust & emp based on a date range given by user, but here's the kicker.. i need to get the current month totals, month totals - 1year (so same...
  3. W

    Sorting a report via code with already establised groupings

    Hi. thanks in advance to all that can help i need to sort a report via parameters set by a user in a form. i have a report with factory and customer groupings, but the parameters allow the user to set a sort of orderamount desc. i've tried reassigning grouplevels, turn on order by on, and...
  4. W

    update query with subselect for percent total

    Does anyone know a way to make this code work. I'm trying to get the percent total (curyear/sum(curyear))*100 the sum is messings things up when reworking it with a query so i created the code below but i get an error 3073, not being able to update . thank you in advance to anyone that can...
  5. W

    query design. current month. ytd, last ytd/month same query

    I know i know, double posting.. sorry posted it in wrong thread figured i get more hits this way... if anyone of you experts can help i'd greatly appreciate it. Structure: customer table - custid pk factory table - facid pk transaction table - custid - facid - orderdate - amount The...
  6. W

    last month / year, current month year same query

    I've been busting my head on this, Thank you in advance to everyone that can help. Structure: customer table - custid pk factory table - facid pk transaction table - custid...
Back
Top Bottom