I have field KRITERIUM containing strings for example Biii(aii) or Biii(D1)
an so on. I want to select all rows that contains uppercase letters anywhere
in the string. I want to get 2 rows where there is 2 uppercase letters. Is it
possible?

I am trying to create a list box to give the user the ability to select a
specific data point to view actual and budget detail. See my SQL below. This
query provides the data needed, but I would to give the user the ability to
select a specific country to view instead of all at ...

I know not much about sub queries.
I need to learn it better.
Can anyone recommend any KB Paper, template, book, or anything else where I
can learn a bit more?

I want to calc the end time of jobs that I store in a table.  We only store
the beginning time of each job but the end time would just be the start time
of the next job.
For example Job 1 has a start time of 1:30

i have a access2003 qry "qryWages" which looks something like this
paymentID     Week           6             6a
      1               1          £63.89       £63.89
      2               2         £127.79         ?

Does anyone know of a site where I can get a sample of interview Questions
for Crystal Report Developer.
thanks in advance
Ismail

I am trying to get a report to run on a query that gets it's records from a
table with Yes/No data types in it.
When I preview the report or look at the query content, the Yes/No data
types return a numeric value, either -1 or 0. Is there anyway to change the

I need to make an update query but not too sure how to do it.
I need to count the number of times an item is listed in table 1 and
update a quatity field in table 2.
I have many items listed in table 1 and want them all updated in table

Help.  I'm writing a personnel tracking database.  At this time, I have two
tables.  First table is "Main Table".  It has everyone's unique barcode from
their ID, names and personal data.  The second table is "Scan Time".  This
table is joined to the first table through the ...

I want to be able to generate a report that counts the number of instances
that the number 2 appears in a field called BookingStatusID in a table called
Booking.
How do I do this please? Do I do in it with a query or directly on a report?

This is a query-of-query in ColdFusion and MSAccess      
This works ok
  <cfquery name="session.getAlpha" dbtype="query">
     select distinct signerName

I am running a query to select all payment and payment reversal records for a
corporation based on company name. When I do this I lose seven records
because they match similar records. I want these records included in my
query. What am I doing wrong to not see these records in my ...

I am trying to query a table with Yes/No data types in it and keep getting
either -1 or 0.
Is there a way to change these values back to Yes or No, so they appear
correct in a report?

I am using the following query:-
SELECT tblApprovedDefects.RequiredFor,
tblApprovedDefects.[Severity/Closure],
Sum(IIf((LookupResource([AssignedToContact]))="Business",1,0)) AS Business,

I have a column with the following values