i want to use access query to determine total bookings for the previous month
automaticallyat the beginning of each new month. What formula in access
language would do that taking into consideration the fact that all months are
not the same number of days

Consider the following:
tblWorkOrders
WorkOrderID            Primary Key
WorkOrderTypeID    Foreign Key

Hi From Oklahoma!!
I am just learning ACESSS and have came across a problem I cannot figure
out.  I am using the Query Builder in Access to build an Append Query but I
want one of the fields to appened from a text-box on a open form.  

I have encountered a problem:
A couple of records in my database contain some noise.
They are represented by the following text: ? and ?????.
I want to filter out these noise (i.e. both question mark records) in a

I am trying to (i) take an existing table, scan it, and identify records
where 4 particular fields match and the sum of another field is zero. and
then (ii) update a different field on both/any records that qualify
I am trying to learn how to build part (i) by using a Find ...

I am converting data from an Access database into SQL Server. As a part of
the conversion, I need to add a GUID as the primary key in the SQL Server
table. Is there an equivalent function to NewID() that can be used in an
Access append query?

how do i move paragraphs within a document

I have two tables as follows:
Client Balances
------------------
Contains.... Division ID; Client ID; Current Balance

how do i set up medical coverage for only 4 employees

I am trying to create a query expression for an existing text field and I am
having problems doing so.
Example:
The existing text field is called Wound Class.  I have pulled this field

I know I should be creating a stored procedure for this, but I simply
haven't got the time to do the learning...I'll do that when I've
finished this project. But a question is how do I use the following in a
VBA strSQL string:

Man, I have been away for Access for some time.  But for the life of me, I
can not seem to get the sintax correct for Select Distinct Function.
I tryed to do the help function but no examples...
Should it not be select distinct [name] ?

i have a criteria in a query for the OrderID to be;
[Forms]![TblOrder]![Order ID]
i want the same query to check another field 'Paid' (the 'Paid' field is a
tick box) to see if its been ticked, if the box is ticked then the query

I have an autonumber field in a query that I want to put criteria on.
When a text box on a form has a value (say 1, 2, or 3), I want the
query to run with the autonumber criteria set to this value. When there
is no value in this text box, I want it to return all the records.

Say i have query with these entries
Identficator | Value |
-------------------------------
1                     66