plog's latest activity

  • P
    plog replied to the thread Report field base on another.
    Perfect. You need to change your ExpDate field to catch those 0 values: ExpDate: iif(Expiration<>0...
  • P
    plog replied to the thread Report field base on another.
    Semantics time---do you want to not show any of the dates? Or any of the records? There's a difference: FirstName, LastName...
  • P
    plog replied to the thread Report field base on another.
    You should fix this in a query. You say you have a calculated field, which implies this Report is based on a query. So in that query...
  • P
    plog replied to the thread Assessing Project Size.
    By "time management solution" I meant an HR package from an outside vendor. That seemed to be a big part of its functionality. You may...
  • P
    plog replied to the thread Assessing Project Size.
    Not an answer to your questions, but my initial overall thought: Ditch this and hire a company to do it for you. And by "this" I don't...
  • P
    plog replied to the thread Need help with cross-tab report.
    Its too complex for me to breakdown and rebuild into one query. But looking at it, my method should work. Instead of 7 queries built...
  • P
    plog replied to the thread Need help with cross-tab report.
    It depends on the data. Can you provide a sample database? In general my recommendation would be not to do 7 subreports (one per day I...
  • P
    plog replied to the thread Querie Dilemma.
    You've not given us enough information, please post all the VBA code. Is the VBA line above the one being highlighted when the error...
  • P
    plog replied to the thread Calculated field question.
    You shouldn't do this as you have stated. And possibly not at all. What is this SKU for? Presumably you should have an autonumber...
  • P
    plog replied to the thread Filling in Repeated Data from Excel source Table.
    Only if you provide it--insert a column before/after the data and have a cell compute it (A1=1, A2=A1+1, A3=A2+1, etc.). Two methods...
  • P
    plog replied to the thread Solved Progress meter for reports & queries in MS Access.
    Agree with tvan. You're focused on what to paint the third floor bathroom while the foundation of the house is a a few cinder blocks...
  • P
    plog replied to the thread Several executes with currentDB possible?.
    Here's the part I wanted: So the goal is to export data to Excel. That can be done without a Rube Goldberg machine. You can get the...
  • P
    plog replied to the thread Several executes with currentDB possible?.
    Moving data is a huge red flag. Why are you doing this? What's the ultimate goal? Why can't data just live where it is and you use...
  • P
    plog replied to the thread Filter.
    This can't be a coincidence: https://www.access-programmers.co.uk/forums/threads/hide-inactive-data-and-show-active-data-only.330677/...
  • P
    plog replied to the thread Solved Access criteria.
    When you need to group data together that's called an aggregate query. One of the functions available when you do that is AVG. Give...
Show older items
Top Bottom