I have built a database that tracks employees and the number of days
employed.  I created a query to let me search the database for the number of
employees hired in a certain date range.  I then created a field, in the
query that would calcute the days employed.  I now want to ...

I have an existing table that looks like this (training periods are between
startdate-enddate, empty value is because the training is still on-going):
RecordNo - TrainingID - Startdate - Enddate - PersonID - ClassWhenAttending
1               Tr_A    21/01/2007    1/03/2007    1    C1

Hello All,
I have two tables (tbl_1 and tbl_2) linked with a left join and I want to
count the related records between the two tables. If no records exist in
tbl_2 then I need to have the count represented as 0. I'm using the following

I am trying to use Data Access Pages to edit data in a MIS database.
I can display the data with no problems but I cannot edit it. The table is
definitely updateable. I can build a form to update it and save it as a DAP
and the data is still read only. The AllowEdits in the Group ...

I have a table with 10 fields; four fields are for photographers assigned to
a particular event. There maybe up to four photographers at each event. Now I
find I need a report by dates and each photographer. A report with start date
and end date is no problem, but how to sort by ...

I posted this on the wrong group.  Reposting for better result.
Thanks.
------------
Im trying to get all the files with any time posted 3 hours earlier

Hopefully this makes some sense. What I have is one large table of data for
each year, for each client. Within each year’s table has all of their
production records, soil fertility, soil types, field names, crop yields, and
so on. I have the same table structure for each client. ...

I have created a macro that makes some fields on a form visible and
others not visible depending on the selection made from a dropdown
list. Here is a portion of the current macro:
Line 1:

Is it possible to use the network days feature which Excel has in MS Access.
If not, how do I count the number of days between two dates, excluding
weekends/public holidays etc? Thanks.

I'm trying to write code that will kill any other old files in the
same folder.  Here's what i have so far:
Dim xPath As String
   Dim xExt As String

the if statement not execute .
the code:
v_checkvalue = xlRng.Value
If IsNull(v_checkvalue) = true Then

I have a table where I have :
IDDataBase       Part ID     WOID        Cut_Process   Cut_Process_Date
==============================================
AutoNumber     Text          Number     Yes/No           Date/Time

In order to improve performance of my Access application I do not bind forms
to data sources directly, but set them up, with filters, in the Form_Open
events. I use this throughout my app, and it really improves the snappyness
of just about everything.

I have two tables that contain part numbers that I want to match.  First
table has a job number, part number, and time entered daily.  Second table is
exported from PeachTree Accounting program that has an extended part number
for colorcodes etc.  I am trying to return part ...

Can someone email me a small sample database that reflects a yes or
no
answer to a group.  like if i want to know how many 35, 36, 40 yr
olds