I have two or more tables (example):
Table 1:
Date             Time     Data1     Data2
17.04.2007    12.20     10

I have two tables with 1 to many relationship
[PatServices] 1one-many [Pmt2Serv]
[PatServices] holds all the charges and [Pmt2Serv] holds all the payments.
Here is the sql statement:

I'm very curious. I have a book I'm working through on Access using VBA. One
of the chapters speaks of using ProperCase([FirstName]) but this doesn't work
as a direct command. The books has me import a "Samples" database with an
"mdlUtilityfunctions" built in. After doing this, ...

The following query gives me a count of open records using "closedate = Is
Null"
Example: Bob = 3  Sue = 1
I need to add one more value to the query and when I do the results look like:

Could someone please help me with a query to filter out records in a table
that overlap.
I have a table with 8 fields and approx 40,000 records.
Fields 1 and 2 relate to a position, fields 3 and 4 are 'from' and 'to'

Can anyone help please? Report Gross Grand Total and Sales tax Total are off
by a penny or 2
The amounts are being generated by the
sum expression below that calculate unitprice and salestax so users only

I'm trying to set a date using the following formula:
ratebase_date: iif([formula_rate] = "False", [rate_case-date],
iif(month([planned_isd])<6,
date(year([planned_isd]),6,1),date(year([planned_isd]+1),6,1))

can anyone please tell me how to add a comment to a Access report?
on certain pages i wish to add comments, but when i add a comment to one
page it shows on all of them! how can i just keep the comment to specific
pages only?

Ok, this has been a challenge I've been trying off and on for about a
month now to solve. The speed issues related to domain aggregate
functions sent me looking for better methods. Over the past month or
so, I've been trying to impliment the subquery method posted various

I am working with a set of data for which I need to produce a sorted
hierarchy (1.1.1.1.1.1. ...) list. There seems to be no limit to the
number of levels, though I am using 12 levels as a practical limit.
Each record has 3 fields to define its position in the hierarchy: ID,

Apologies if this is a bit basic - I'm rather new to Access.
Am using Access 2003 on XPSP2
I have one table with data that looks a bit like this:
UserID1, Field1, Field2, Field3, Field4 . . .Field36, CreationDate

I have created a query:
DELETE
FROM Employee
WHERE Number = [Num]

I have an Access database I created.  They key fields of a particular sort
are the "employee number" and the "Hours Worked YTD Total."  I have created a
query that sorts in ascending order based on the "Hours Worked YTD Total"
field.  This query works but on a periodic basis all ...

I have been helping someone with a database. I am stumped and would like
some suggestions on what to try next to solve a stubborn problem.
The dtabase is a simple "Contacts" application. The table "tblContacts"
contains contact information, including "DOB" (Date of Birth) and ...

Hello all.  
I have two tables with the following fields:
Table1:   Rate_Table
Field1:    Resource ID