I have two queries, where each accept parameters. I'm using the DLookup to
call the one query from within the other, however I don't know how I go about
sending the parameters from the outer query to the inner. Below are my
queries.

My query is linked to a couple tables, one of which contains the fields Date,
Type, Hours. There are only four different  categories of "types."
In the query then created four additional columns. In these columns, I
wanted to total each "type" category seperately. I would want the ...

I am designing a database to follow patient records in a medical office. The
records are strictly medical data and not to do with billing. I am trying to
create a report and form that will list each encounter of the patient,
incorporating their medication lists. This means that ...

I need to make a DB with relationships so that I can compare results of a
test with the real answers and other people and work out the averages of
each section (e.g. Math, Spelling, Reading) how do I do this
Thanks In Advance

I have created an update query which will update the table with the contents
of the fields entered into a form as follows;
UPDATE TabTapes SET TabTapes.ContractNumber =
[Forms]![TapeDispatch]![TXTContractNo], TabTapes.Customer =

I am trying to create a criteria formula in a query that will find values of
a particular field that are greater than 5 and less than 10 among values
between 1 and 20.
I have run out of ideas and there appears to be no help for me!!

I'm a novice at VBA and I'd appreciate some pointers on how this macro I've
written (well, recorded mostly) could be made to run faster. I'm reading the
defined range D7:CU213 on 84 sheets and looking for cells which aren't protected
(sub totals are protected)to apply some Data ...

Query in my database is showing double records while the sorce table is
alright. In my query i compare two tables for processed entries. My query has
the following fields:
ID / Name / ProcessDate_T1 / code_T1 / amnt_T1 / ProcessDate_T2 / code_T2 /

I wanted to write an update query which ID must exists in table A but not
table B
I use following SQL, but it seems Access doe snot let me use "not in" and
"in" at same time.

how do I extract part of a field after the "/" character in a query?

Hi gurus, I have benefited tremendously from reading your postings,  more
than from my work or books. Thank you in advance for your help here.
I have two tables: DrVisits and HealthCoverage. I would like to find if a
doctor's visit (tbl: DrVisits) is covered by a plan (tbl: ...

I have a table like this:
ID    Absent    Reason
1    1    a
1    1    b

I know that this has been answered over a thousand times, but I've bee
working on this project and for the past 5 days I am unable t
calculate a running daily sum. Can someone assist me please?
Confused  :confused:

Hey all:
Need help with converting Julian Dates to Regular Date Format. I did see a
thread with similar question but I am pretty sure my data is in the real
Julian format. For example, I have the year and ordinal day for the year

I am making a query where I divde a field in my query (Week Hours) divided by
5 to get Daily Hours. I would like that number to be rounded to the nearest
half hour.
Example: 2.01-2.24=2