Hi Folks - Here's my scenario:
I have a query with the following fields/data:
CaseID    StatusDate    Status
1                1/11/2005    Open

I have 2 tables :

Match            Score
----------------------

I have three tables : Quotas,  Results, and Predictions. In the Quotas I have
for each match the koeficent for Win, Loose (eg. Team1-Team2, Win=1.5,Loose
=1.7).
The Results its the result of the game (Team1-Team2:Win=1 Loose=2), and the

I have a few queries that I have imported to excel using its "external data"
method, but when I try to set up a link to a new query, I get an error when
I select "return data to excel":
Too few parameters. Expected 11.

Hi, I have read several posts on this topic and still can't quite figure it
out.
I have a combo box on a form called CSRList. It is populated from a query
with this in the row source:

Hi!
  I have a question about making criteria in a field. The field is
employeeID. Now it will show all employeeID. Now I want to change to this:  
If user select an employee ID, the query only show the matched employeeID.

I hope you can help me with this.  
I have a Table1 that contains, eg.:
CardId   Date          Time
10        15/01/05     12:00

I am currently using a pass-through query to run a SQL stored procedure
- is there a way for me to create a 'make table' query to run the SQL
stored procedure and create a table with the results.
Thanks

Hi group,
Wonder if anyone has ever come across this:
I have a table with a few thousand records. One column/field of this table
is a 'Batch Id'. This is a non-unique identifier (ie there can be more than

We have converted an Access 97 db to 2003.  We have a field name called
[Addres1&2].
Our Append query will run as long as we do not open it in Design View after
conversion.

Hello. I need to create a query that will take off the last character
if it is a letter.
For example, our database has a unique identifer for each mold of
products. Well, some of these molds were duplicated by using a A, B, C,

I have a table of trouble tickets for a group of test events.  The table is
like so:
table Tickets
{

Instead of .openquery("Name of query") is there a function that will allow me
to call a SQL command using the actual SQL command string (SELECT * ....)?
Or is there a way to modify a prebuilt query from the form code?
Any help is much appreciated,

Background
I have a report that uses a combo box to filter the data.  The user can
choose ‘All Reports’, ‘Blank’ (i.e. field has not been filled in), or choose
a specific Report. The query used to populate the combo is shown below with

I having some complication with make table query. I have lots of very complex
query and in a given time access was not able to make all the calculations I
wanted too. So I started making make table query to hold the results of my
queries. My problem is that I want access to keep ...