Latest activity

  • Sam Summers
    Hi Arnel, I have managed to get it working from your code. Thank you once again and thank you for all of your suggestions and help as...
  • arnelgp
    arnelgp replied to the thread Count Query.
    you need 2 queries: 1. Query1 select [account number], datepart("ww",[date of call]) from yourtable group by [account number]...
  • N
    Number11 replied to the thread Count Query.
    ok thanks so i have this now working and the count of call is working, but I am seing within the count of call 2,3,4 ect so i guess i...
  • J
    Thanks. I think is a little too complicated for me as I have very little knowledge one Access
  • MajP
    It is working. There are no results because the two tables are identical. You can verify be changing a value in one of the tables and...
  • isladogs
    isladogs replied to the thread Resize Navigation Form.
    Option groups are a known issue and can easily get 'oversized'...especially if they are close to the bottom or right of the form as...
    • 1628077019547.png
    • 1628077451180.png
  • arnelgp
    arnelgp reacted to MattBaldry's post in the thread Solved Duplicate Record VBA with Like Like.
    Tried, tested, works. Thanks Arnelpg. My append query that kept failing was so close to yours, I just had the [Copy To] parameter in...
  • M
    MattBaldry reacted to arnelgp's post in the thread Solved Duplicate Record VBA with Like Like.
    create an Insert query (qryDup): Insert Into tblProductLabour ( ProductID, LabourProcessID, ProductLabourQuantity ) Select [p1]...
  • Cotswold
    Cotswold replied to the thread Stock Calculation.
    You will need a stock table IQRARAO. The stock level will increase with purchases and reduce with sales. With a Stock table you can...
  • M
    MattBaldry replied to the thread Solved Duplicate Record VBA.
    Tried, tested, works. Thanks Arnelpg. My append query that kept failing was so close to yours, I just had the [Copy To] parameter in...
  • M
    MattBaldry replied to the thread Solved Duplicate Record VBA.
    Thanks Arnelpg, That was almost what I had but was getting wrong. I shall give it a go. ~Matt
  • N
    Number11 reacted to arnelgp's post in the thread Count Query with Like Like.
    you need a total query: select [account number], datepart("ww",[date of call]), count("1") as countofcalls from yourtable group by...
  • N
    Number11 reacted to Minty's post in the thread Count Query with Like Like.
    Write a query that pulls in the core data. Account Number, WeekNumber Once that is correct change the query type to crosstab. Put the...
  • arnelgp
    arnelgp replied to the thread Count Query.
    you need a total query: select [account number], datepart("ww",[date of call]), count("1") as countofcalls from yourtable group by...
  • Minty
    Minty replied to the thread Count Query.
    Write a query that pulls in the core data. Account Number, WeekNumber Once that is correct change the query type to crosstab. Put the...
Top Bottom