Search results

  1. J

    String in expression is being treated as a parameter?

    This has got me scratching my head, am I missing something really stupid? I've got a query. One field is an expression on which I'm filtering. A shortened version of the expression is Expr1: IIf([Status]=”Active”,"Yes","No") There are other parts to the formula, hence why I'm not filtering...
  2. J

    Find records in one table and not in another

    I've got 2 tables, same structure, one [T-temp-Target] holds number of training units split by module a trainee needs to finish the course, the other [T-temp-Actual] holds what they've completed so far. Both tables have structure TRAINEEID MODCODE CountOfUnits I'm trying to find the modules...
  3. J

    Idle curiosity, why does it take so long for design view to open for a crosstab?

    What it says on the tin. I've got a very simple crosstab query, 1 table, no criteria, 5 row headings, 1 column heading, 1 data... the database is 900Mb, not big, and regularly compacted. But it takes 3 mins to open design view, it runs quicker than it takes to open design view. Why is that?
  4. J

    Is it not possible to link Excel to a crosstab query?

    Hi I'm setting up an Excel file to report on Access data. At the moment it's copy&paste but I'm trying to set up a connection to the crosstab table in Access. I can see the database, tables and a few queries in thge connection wizard. I can't see maketable queries which is what I'd expect...
  5. J

    Find dates in one table but not another

    Hi Sorry if this is a very dumb question I've got two tables, both are indexed by customer ID, with a series of dates against the customer ID. One has a list of all dates a customer was visited, the other is a list of dates where activity happened on the customer account I want to get a...
  6. J

    Basic question as to how Access does criteria

    I've got a query that generates a big table of data for use by multiple queries. There are criteria against a number of the fields. But when I run the query, it just ignores the criteria and returns everything. What I want is to restrict data from a Region fields to...
  7. J

    Greetings from the Grim North

    Hi Just found this forum and expect to make good use of it. I've some experience of Access, I've had fun with vba subforms and suchlike but in an old version of Access (2000) so if I need to use vba I'll be dipping in here for tips. I've more experience with Excel, have coded vba extensively...
Top Bottom