I have a table with an stock number (STOCK) and a sequence number (SEQNO)
and a bunch of other fields (TITLE is one). This table is maintained by a
proprietary software package.  I just read it.  The sequence number is
unique, but the stock is repeated multiple times.  In those ...

I want to list the contents and attributes of a folder using MS Access.  How
can this be done?

I want to write a query that groups records based on the first or second half
of a year.  For example, records with a date of March 4th, 2005 (3/4/2005)
would be grouped as 1st Half 2005.  Records with a date of October 20th, 2004
(10/20/2004)would be grouped as 2nd Half 2004.  ...

Please can somebody help, I have taken the training courses over queries but
I still have a few questions...If anyone could please help me and let me know
how to use more than one criteria in a query, Thank you so much

I a form with the following field:
Report Date, Loans on Report, Renewal Loans and Total.
I have the Loans on Report and Renewal Loans Adding to calculate the Total
Field. as such: =[LnsRpt]-[RenewLns] in the Control Source and works fine on

I have just one more question if anyone out there could please help answer. I
just need to know how to exclude certain information in a query. Thank you so
much

Is there a simple way to update a field in one table from a field in another
table? The SQL that works in SQL Server doesn't seem to work in access...
update tbl1 T
set T.field = S.field

  I have  a query to report on sales results.
what i would like to do in the query is to rank sales items by total sales
so ex
clothing  $500

I am creating a database that tracks when hospital employees take certain
required education courses.  I have a query currently that lists what
employees have not taken a specified course.  However, I need this query to
be a little more involved, and I am stuck.  There are certain ...

Hi all, first time in Access Group.
I have a question and I cannot seem to find the answer anywhere in the
discussion groups or on the Access Online Help. I am hoping that some one
here may have an answer or have come accross this before.

I am creating an Access database to keep track of our employees's education
requirements.  More specifically, our employees are required to take certain
continuing education courses, and there are several courses.  I am able to
query to list what an employee has taken using:

I am trying to create a simple-looking billing report. Customers need to be
organized by protocol; High-speed first (FTP, VPN, HTTPS) and then dial-up
(ASYNC, BISYNC, SNA). But each group also needs to be in order by ID. I have
two queries right now. One does high-speed and the ...

Hi,
I am trying to design (write)  a query to pull inventory cycle count data
for metric reporting . There is field is my query  that contains values of
A,B, C or Blank. I want to change these values and sum:

Here's my query that I would like to query against:
JobNumber (text)
StartDate (date)
EndDate (date)

Need to find out the average number of days between the  date and the ship
date. This needs to be shown line by line for a future report. I am new to
access so not that familiar with writing code to do this.
date    SHIPDATE