I have an unbound list box with the multi Select properties set to ‘Extended’.
One of the fields in the list box is a unique Number field [Group_ID].  I
would like to create a query that is based on the lines selected in the list
box.  E.g. If Group ID 2, 5 & 6 are selected then ...

Every time I run filter by selection it displays records in different order.
There is no indication of any kind of sorting anywhere. I set Advanced filter
to "Not Sorted". But it is happening anyway. I tried to analyse the data but
there seems to be no specific order in any field ...

I have a table populated with Equipment items that is transferred from
contract to contract.
The table stores the ItemNo, ContractNo, DateOfTransfer -
Looks something like:-

I need to create an aging report.  I have the amount ,the due date of the
amount.  I need to show current period 1 to 30 days late, 31 to 60 days late,
61 to 90 days late and over 91 days.

I need to be able to append data if the entire record is new and update if
only part of the record is new.  I am still somewhat new to Access and am
confused as to how to do this.  
I have my three queries that all append different records to me EARLY_POINTS

I have QUERY for my purchasing data information, on Tables I just Have one
table and the other are link_tables.
IM, RQ, MOS,OP,ID AND TX.
On the form you need to type an Item Number and this one should looking for

I have three really small tables, which gave me a lot of headache.
They reside in a MS Access database and a I am accessing them through
ADO.NET(VB).
Can't figure out how to make a "Select" query on them.

I have created a query to count the amount of records stored under each
driver ID. I Created 2 queries, one that ounts all the records booked
under each driver(Q1). The second query uses the first query and sum up
the data using the following code:

Howdy from Oklahoma!
I am relatively new to ACCESS and just getting intoduced to VB.  
I have a query that is pulling a Lot# from a table and the lot# has the
Purchase Order as the last 5 or 6 characters of the Lot #.

I have a Group By query that groups records based on whether the Result
is Pass or Fail for a test. So for each item there could be 1 or 2 rows
in my query with more than one result for Pass or Fail. So I have a
Count on the Pass or Fail (ResultDescription) field.

I have a set of dates ( for 1 yr) , from those dates how can i pick up the
2nd friday in every month. what is the criteria for the query. so it picks
all the 2nd mondays
any ideas please

I am currently working on a database that monitors the entry and exit of
outsourced workers. Each worker will generate the maximum of four entries in
the database as follows: Entry (arrival at work), Exit (for lunch), Entry
(return for lunch), Exit (departure from work). I would ...

Im very stuck with a query. I am trying to count records from 3 tables
based on the DRIVER ID field. I want it displayed as
P01     6
P02     4

I have the following query;
SELECT dbo_SYS_INFO.SYS_NME, dbo_SYS_INFO.SYS_URL,
dbo_SYS_INFO.TEST_BEGIN_DATE, dbo_SYS_INFO.TEST_END_DATE,
dbo_FINDG.FINDG_STAT_DATE, dbo_FINDG_STAT.FINDG_STAT, dbo_FINDG.SMRY AS

Hi.  I created a  macro group.  The macro name RECRUITER should open
the Recruiter form in Form view.  Instead it is opening the Territory
table. I do have a TERRITORY macrro  in this macro group
This is what I have: