plog's latest activity

  • P
    plog replied to the thread Need a Form With sub form with populated client info and a subform with services and price in items invoice, please help.
    Your database seems simple enough, but there's a few things I don't understand. 1. Only one item goes to an invoice? That seems...
  • P
    plog replied to the thread Access table Formula.
    Doc doesn't want to belabor the issue, but after your two recent posts it seems someone has to: 1. Type is a poor name for a field...
  • P
    plog reacted to MajP's post in the thread Solved A Really Simple Question with Like Like.
    No there is not a simple answer, but IMO the time to use an unbound form is very small. I am not saying there is not a place for them...
  • P
    plog replied to the thread Solved A Really Simple Question.
    I only use unbound forms for menus. If I want the user to act on the data (create, update, delete) I use bound forms. Even if I want...
  • P
    plog replied to the thread Sorting in access queries.
    When you have ties there's no predicting how its going to sort. If you want to ensure the same sorting you should add a unique field...
  • P
    plog replied to the thread Solved Starting Appended Data at 1.
    Also, who cares? Why must your numbers start with a particular value? Autonumbers should only be unique. If you have that they will...
  • P
    plog replied to the thread limit date formula as variable.
    Disregarding the issues pointed out before, here's all the issues I see with your date logic: Case 48 'All Dates [CkDate] The...
  • P
    plog replied to the thread Need Help With Code VBA For FIFO.
    Totally agree with jdraw. Here's the 2 codes that set those 2 boxes on your form: ... txtSI_FIFO = Nz(DLookup("[SoldQty]"...
  • P
    plog replied to the thread Solved From with One-To-Many Relationship table.
    Agree with jdraw and also recommend working on populating your tblPropertyTypeAttributes table so we can see your attributes. Some...
  • P
    plog replied to the thread Count(IIf( ....
    Quit throwing files at us we just want you to explain your data. Here's the last of the help I am giving: What you want for Number...
  • P
    plog replied to the thread Count(IIf( ....
    1. AA03 was not the selected partnum I wanted to examine, AA02 was. We are paying attention to you and your issue, please pay...
  • P
    plog replied to the thread Count(IIf( ....
    Boy that was not helpful. You simply removed selected data from your initial screenshot which I have access to. You need to hold my...
  • P
    plog replied to the thread Count(IIf( ....
    Walk me through one specific calculation: For Row=5, PartNum=AA02, NOTE=Ready; explain why number of repetitions=2 and Sum of Count=3.
  • P
    plog replied to the thread Help query Count.
    My guess is you put every field in the GROUP BY. You only need to put things in the GROUP BY that you want to....group by: SELECT...
  • P
    plog reacted to MadPiet's post in the thread Performance Issue with Like Like.
    What if you create a new blank database and import just the 3 tables and the minimum number of queries and forms for us to see the...
Show older items
Back
Top Bottom