I have a two tables that look like:
Emp table    Punch table
employee------------employee
lastname    date

I am designing a database that will produce reports on the fuel usage
and mileage of fleet vehicles. The main table is the
VehicleFuelLog;the fields are: [fuelID]-[fuelTruck]-[fuelDate/Time]-
[fuelMileage]-[fuelGallons]. In order to get the mileage for each day,

I'm trying to do a simple calculation with dates (getting the number of
weeks in the school year that an employee is working), and then write the
number to a field in an update query... and I keep getting the aggregate
function error. Here is a sample,

I want to design a query in which the user will be able to determine any
projects that were in process between 2 dates. I have 2 fields in the
underlying table, one being the StartDate, the second being the EndDate. I'm
stuck. Can you please help me with this one?

I have some large Access databases that only a title for a number of records
that have been input. If the title is the same then the field is null. I
would like to add thiese titles to the records but not overwrite ant titles
input.

I use Access more for it's data handling capabilities than it's
database capabilities so here goes.
In one table I have specimen information that can be characterized
into ~30 different study groups.  Each specimen can be in one or more

I have an Access db with many different queries.  I tried connecting to one
of the queries from within Excel using Microsoft Query and, although I can
see the query in the table listing, when I select it to try and link to it, I
receive the "Can't access table" error message.

I'd like a query to return results greater than six weeks from whatever date
I enter (or preferably the date I am running the query).  Right now I'm
manually editing the query every time I run it to say ">#04/14/2008# but I
know Access has to have a way to automate this.  Thanks!

I am trying to run an IIf statement that will return a value of "Y" or "N"
for any records where the [settle-dt] occurs within the current month.    I
found how to automate the results from the beginning of the month, but is
there a way to automate the statement below so that I ...

I need to create a sequence/order # field in a query so it puts the data in
order by 2 fields (company name and employee ID).  
i.e.:
order    company name           employee ID      total sales

I have emails being exported from Outlook into Access.  I then would to take
certain data in the body of the email into another field.  The emails are
automatically generated, and are always in the same format although the data
I want to pull out can change (the length will ...

I have two seperate fields with the same type information "2/11/2008 4:49:23
PM", date created and date of response.
I'm trying to write an expression that will compair the two fields that will
tell me if the response was on time or late.

I want to use a DLookup in a Query.  The table that the ChkServer is coming
from is in the Query, However the tblEmployees is not.  Here is the field in
the Query.
SERVER: DLookUp("[EmpFirstName] & "" "" &

is it possible to display 2 data series in crosstab Query i.e.
Manager      USD
AAAA           100
BBBB            125

I am working an invite list.
I have 30 fields for each record.  When using a query, I shorten it down to
Title, First Name, Last Name, Spouse, Dinner Invitation, Event Invitation and
Total Invitees.