namliam's latest activity

  • N
    namliam replied to the thread Solved Totals Yearly Query.
    Best way to address that issue is to add a related table, to "translate" your sources into 2 sources and use the related table to pivot...
  • N
    namliam replied to the thread Solved Totals Yearly Query.
    TRANSFORM Count([personal Detaill new].[Client ID]) AS [AantalVanClient ID] SELECT Year([DateCompleted]) AS Expr1 FROM [personal...
  • N
    This is where your troubles start(ed), never use a meaningfull value as your primary key ! I doubt the change from int to bigint is the...
  • N
    word to the wize, use a naming convention and avoid using special characters like spaces, -@#!#%^*&( and alike. Your Account-No would...
  • N
    namliam replied to the thread had to laugh.
    Classic mistake, though mistake #1 is not ... using excel.... basic mistake is to leave the data as is spread on lines. 1400 cases...
  • N
    So make your first query Select equity from yourTable Where (Type = "Sales" And SaleDate Between Forms!yourform!StartDate And...
  • N
    namliam replied to the thread Import files sequentially.
    You can investigate the DIR function and the use of that over your current method. Another alternative is use a table to store your...
  • N
    namliam replied to the thread Import files sequentially.
    You typicaly dont delete records you mark them obsolete, depending on the update date and time.... the order you import your different...
  • N
    namliam replied to the thread Import files sequentially.
    why want to force access to import the one store first? Simply add the filename/storename to your target table running an update query...
  • N
    namliam replied to the thread Excel - Obsolete?.
    excel obsolete, what kind of bad trip are you on? I still do things in excel 10 times faster then most others using "new shiny" tools
  • N
    namliam replied to the thread Fusion - With Legs.
    Super example of making something simple very complicated. Simply cover all roof tops in solar panels, that combined with some local and...
  • N
    namliam replied to the thread Nz Function for Access VBA DATES.
    If you are working in VBA, when your form value is NULL you want to OMIT the where clause all together not "force" it to be true using...
  • N
    namliam replied to the thread Matching records query.
    Nice that it works and nice you understand it, but it stil is less than optimal design and much less than optimal solution. If you are...
  • N
    namliam replied to the thread Matching records query.
    Using numbered fields in a database is a sure fire way of making it like an excel sheet, which is a bad thing to do in a database. As I...
  • N
    namliam replied to the thread Matching records query.
    Really? Sorry to be harsch but that must be the worst way ever to do this.... IMHO offcourse Do you know how to add criteria to fields...
Top Bottom