Search results
-
L
Query asking for a parameter where none needed?
Hi, I have a macro set to run over night that runs a hundred or so queries in a row. I've just added a few which now cause the macro to pause and ask for parameter values - only none are needed. The parameter box asks for a value for "total". In the query itself I have a column - total... -
L
Query not opening in design view
Hi, Just this morning I set up a new create table query in a new 2003 database. The query was too complex at first so I removed a load of criteria meaning to do it in a later query. At which point it worked ok. At some point the database must have been shut down and when I reopened it again... -
L
Question Other factors which affect access - queries producing incorrect results occassionally
Hello, this is my first post and I'm really hoping someone else will have encountered this. I have an access database which has a run of 100 plus queries which all append data to a single table. I have a macro set up to run these in order so that I can run it over night when nobody (in...