I am a beginner at databases, and am wondering if it is possible to calculate
according to the parameters of a start month, and payment cycles such as
montly, bi-weekly and so on the next payment due dates?
If I should be asking my question in some other forum could you please let ...

I have two tables, one table with one primary key and one table with several
keys:
Table 1
NDC                   GPI

i am trying to subtract 2 days from today's date as part of a filter query
date()-2
i do not get any results.  i have seen that access may not perform this
function as stated. is this true or am i doing something incorrectly?

I create a parameter query to allow users to check records with interview
dates that fall between a specific time window on a timely basis. To do so, I
first create 2 fields as:
start_date: [On! or AFTER (m/d/yyyy):]

I created a query with two fields, first field is the qty field, 2nd field is
the description to the qty field (Router), I'm summing up the qty of each
description (Router), The query gives me totals by description (router), the
descriptions for the qty's are 4 different ...

Could anyone help with this:-
Can this be achieved in a SQL statement other than making physical tables
(other than the  FromTo table) ?
I have one table called auaudit and need one query to select records that

The following query allowed my to manually update records up until last
Thursday. It has been working for 2 years. Any ideas on why all of a sudden I
can no longer update from the query below. I am working in Access 2003.
SELECT tblRoughCutHdr.WeekStartDate, tblRoughCutHdr.WeekNo

Group,
    I have the following query that I have tried using both the LAST and MAX
and yet I still cannot get it to return only the last record determined by
the date.

Access 2003
I think this must be a pretty easy question, but unfortunately I'm unable to
identify the solution . . .
SIMPLIFIED SUMMARY

I am importing an array of information from excel, and I am stuck with
respect to replicating the same result within access on the query grid.
I have four columns representing daily data. And I group data by calendar
periods to obtain a weighted calendar HDD result by calendar ...

I have an append query that takes a parameter and two combo box
selections from frmEmpSetHours. One of the combo box selections is
Shift (1, 2, or 3).
The resultant dynaset is appended to tblEmployeeProduction.

Tbl is as follows;
name, dodate, team.
I must first select the single name that matches a specific dodate, then
select all the names that match the team of the first selected name,

I wnated to use make table query to create temp local table at run time.
It seems that the query uses "INSERT tblMyTable ... INTO  ..." which is
create a table from another table structure.
Does MS Acess support "CREATE TABLE" query to create a brand new table temp

want to assign week 1 to the starting date for each new group is this
possible?  The groups will be around for about 14 weeks each, so would
want each group to have 14 weeks of information
Any ideas?

I would like to know how to sort some results of a couple of tables.
Help would be most apreciated as my skill level is growing fast but but it
seems not fast enogh at the moment and Im stuck.
I have two tables one called tblCategory and another called tblResults