I'm posting this to this group also since it pertains to queries, primarily.
Hello,
Using VB6/ADO, I'm thinking I can create a recordset and insert it into
another table in a different Jet database, all within the execution of a

I have created a lease database that contains lease and rent information
(rent and sales information is entered every month by date such as 5/1/2007).
Each lease has a different start and end date which constitutes the lease
year.  We pay percentage rent based on the lease year. ...

I am working im Access 2000, and now have a requirement to create a query
that shows the records for items shown as received in a date range (decided
by user)
I have created the basic query but i am struggling with the following issue.

For my database, each employee can work in many departments and I want to
create a query that will select the department in which each employee works
most.
SELECT tble_employee.FName, tble_employee.SName, tble_hrs.Dept,

I have a wildcard search which is linked to a form with 2 textboxes on it
which allow my users to enter search criteria. My current SQL statement looks
like this:
SELECT DOCUMENTS.[UNIQUE ID], DOCUMENTS.[DOC ID], DOCUMENTS.[DOC TITLE]

I am running an append query when opening a form in order to add records from
a linked SQL table to a table within Access.  The Access table is then used
in the form to lookup individual records. This works fine when only one
person opens the form, however the query slows down ...

I want the expression to show "BI" from all values start from BI**** BUt it
doesnt work. I am using * as wildcare:
IIf([Subject]=BI*, "BI")  and this too: IIf([Subject]=*F1*, "F1")
Is BI* valid value? (in Subject field I have BIF1A, BIF3B & etc)

I am somewhat of a newbie and very new at having to change all the data in
one swipe.  I have a overtime database that tracks overtime worked and
refused for the company.   On April 1st we have to roll back their total
hours worked by the lowest number of overtime hours within ...

In design view in an access query:
I have a date field. I want to group the returns based on based on the year.
Can I do this is the total row?

In a query; the fields are:
CustomerID, Customer, NotPaid, Overdue, Outstanding.
Where Notpaid is under 10 days, overdue is over 10 days, outstanding is over
30 days.

I have a MakeTable query which uses the fnConcatenate( ) function to merge a
bunch of information into a single field.  Unfortunately, the field length
exceeds 255 characters and the MakeTable tries to dump this into a text
field, rather than identifying that the field should be ...

My table:
Employee No    Work Code        No of hours    Start Value
2                                               4.0
2                          89               2   

How would I find a 5 character substring at the end of a variable length
string that is in a field that appears to be padded with spaces to the Right
because nothing shows up when I use the Right Function?

I have a query that has the following fields:
PatientID
CaseNo
CaseBgnDt

Hi, I'm new at this, so I'll try and explain what I'm trying to do here,
maybel I"m going down the wrong road.  In my instance a member equals a
customer.  Just so you know.
I built a query which is pulling member history data for members with bad