I use qryCreateCompEn to create a table with field EN which is integer. I
want to see if the table has record or not. My IF statement generates error
message "Type mismatch". Where did I do wrong?
Thanks.

I am working on a school project which I have been for weeks.  I have
one problem that I can't resolve.  I have a two tables that I have to
divide to get a percent of free throws made.  I have 0 that appear in
the each table and sometimes both of the them have 0.  I used the

Last time I'm trying this
SELECT Test.Customer, Test.Year, Test.Score, (SELECT Count(Test.Score) FROM
Test As X WHERE X.Year = Test.Year And X.Score <= Test.Score) AS Rank
FROM Test

I have a table of products, and each product can have a category, for
example, "laptop" or "desktop".
I have another table that has a top-level category name (i.e "Computers")
and a memo field that stores sub categories ("laptop, desktop" etc). There is

Is it possible to do the following @ all.  I need to query a field
called DiaryEditor within table Extract for the next two words after
any occurence of the following "Updated By: ".  I understand that the
InStr() function could be used but not quite sure how this is meant to

I need to find the rows that exist in one table but not in the other
with this condition:
(prod_name exist in table1 and not in table2.prod_name )
table1.prod_name build as a sting that include 'S' and string after

I'm slowly trying to learn SQL in Access. Probably the usual way - for
every  query I build with the QBE grid I then switch to sql view and get
to grips with the code. (That and the usual book learning etc.)
However, SQL view in Access is *so* unfriendly. The code in a one-colour

i have the following table:
Duguje  Potrazuje Partner PartnerName Date
----------------------------------------------
   1     3       P       Tisak     12.3.2006

Hi,
     I desperately need some help. I have got an append query which grabs
data from different tables in order to create an Invoice.
The system is ofr a nursery and therefore, 1 child can have many sessions. A

I have a query that sorts infomation in a particular sequence.  I want to put
an expression in the query that numbers the records sequentially.  Is there a
simple expression I can enter to tell me the row number as a field in the
query?

I am trying to run a procedure (visual basic - the code has been debug and
in order) by using macro (run code) and I hv create a function to run the
procedure.
By hv the following error msg:

running access 2k;
I have 2 queries - BOTH should work as far as I can see, and NEITHER
does; each reporting "could not delete from specified table".
Obviously, they are 2 attempts to complete the same deletion task,

Hi, i have a question for y'all, i have a table
D    P       Partner
---------------------------
1    3           P

OK, I'm hoping I'll describe this right, but bear with me.
I have a table of values I need to generate a list from.  This list will
have 2 or three lines per record.
As an example, here is the table layout

I have a query that has one field Type which is set to Count
The query results are used in a report.
The report has the fields in the detail section as TYPE and CountOfType (1
line only in the detail section)