Howdy Folks,
I have two tables in Access. One table contains barometric pressure
measurements taken every 10 minutes. The other table has depth to well
water measurements taken at different time intervals (some are 30

I a RegisterZ report that combines all these notes into one field. How can I
seperate
the notes into there own field. I'm really only needing the Tax.
VISA $662.13‡MC $ 112.04‡TAX $157.34‡SAFE $500.00‡RJR $45.00‡PM $ 4.00‡S & M

I have created a donor database, I will populate the donor database via
import. I created a form to add additional people to the database as needed.
Now I need to be able to build some type of querry that I an scan a donor
account number and have it bring up the donor record for ...

Hello all,
I have a append query that works great if I just run the query via Access.  I
need to convert that query into VBA code.  Here is the SQL View of the query
I'm trying to convert:

I don't know how to set the source property on a query.  I don't have access
to the Access db yet but I have an excel spreadsheet that I would like to
populate my db so I can test the query. I imported the Excel spreadsheet that
comes from the access db to a table called ...

I am trying to build a query that will tell me the date a customer
crosses a predetermined threshold. I have an invoice table that
carries the invoice date and the amount invoiced among other things.
We would like to reward customers that do x amount of business with

I have a strange problem with a source code generator I have created,
everything works fine for all SQL Server queries, and all the Access queries
(Insert, FetchAll, Find and Delete queries) work correctly. The update query
does not work on any table, but the code works, the ...

I hope I am explaining this correctly, so here goes
I have a query that is joining two tables.  I want all records from my
"primary" table, and data from the second table if the key matches the first
table.  (If I am following, that is a Left Join.)

I have an issue that I cant seem to find a solution for.
I have a query that I am using as the source for a report. Data for
the query comes from the applicant, job position, and interview
tables.

I have a query that works fine, and I need to "sum" the ammount of ones that
appear in 2 sections.
I use another query to calculate this (obviously), but it doesn't work when I
have anything else other that the 2 expression.

Is there a way to organize queries, say with folders or indents?  I would
like to group related queries together including queries that query other
queries.
Thanks,

Which probably doesn't say what I want it to :--)
A variant on this was posted onto the Reports group a week ago but. so far,
no-one has been able to respond.
I'm writing a membership database which also includes exam registrations and

In executing the following query:
SELECT CurrentData.[VacRate], EmpData.[HireDate], SUM(TimeOff.[Hours]) AS
HoursTaken
FROM CurrentData, EmpData, TimeOff

Is there a way to define a field as a date, formatted as mm/yyyy from the
make table query? By default, the field will be text, but I will be loading
dates into the field in mm/yyyy format.
Thanks in advance for your help

I know I have done something like this before but can't remember how.
I have a table (Employees) that contains employee data and has a unique ID
(EID) which is an autonumber field.  There is a field (PCRType) that lists if
the employee is a Nurse, Tech, Sec, or Other.