SELECT tblStoffeerder.PersId, tblStoffeerder.Pers_naam,
tblStoffeerder.AantalUur, tblStoffeerder.WerkmyRef,
Sum(tblUurStaat.UurStaat_aantalUur) AS SomVanUurStaat_aantalUur
FROM tblStoffeerder LEFT JOIN tblUurStaat ON tblStoffeerder.PersId =

I have two access queries, there is one criteria "GB or ML" in both of these
queries.
In the first query, it still gives me back the GB and in the second query it
doesn't give me back the GB.  The only difference is that there is one more

I would like to display results in a weekly basis instead of daily.

In access query, design view, create a new field/expression:
take any text value with numbers and convert to number value, ie:
123 123 becomes 123123
123-123 becomes 123123

I would like to make a make-table query that counts records using a
type of row number, based on the number in the field [Batch].
For example:
Record--[Batch]

Hi
I need help with my access 2003. Can you create an executable that can be
distributed if the user does not own access
Thanks

Using Access 2003.  I have a query, sql below but I use the query grid to
make my queries.  When I put in a criteria [Enter Date] under my date field
so I can see the patients started on therapy yesterday, I get no records.
The field is a Date/Time field with data and time in it.  I ...

The first query is not updatable and the second one is.  I don't see
what the difference is other than the tables and fields. Can someone pls
show me the differnce, I need to have the frist one updatable.
Thanks, Robert

I have a select query with the totals row enabled. 4 tables are
involved in that query (tblOrders, tblOrderDetails, tblProducts,
tblPacks)
tblOrders ---<tblOrderdetails and tblProducts ---<tblOrderDetails>---

I want to create a query to search for all records where a particular field
begins with the # character.  My query criteria for this field is <Like "#*">
but this produces nothing.  I assume the # is reserved but I can't find what
the MS Access Escape character is.  Any ...

This query runs great in Design Mode
It runs only once after Query compiles, subsequent runs return Numeric Field
Overflow error.  The [US PUB DATE] FIELD IS 10 CHAR TEXT 'MM/DD/YYYY'
SELECT IsDate([US PUB DATE]) AS Expr1

I have a table like this
Customer    Week  Begining      Total week   End
1                 1                  0              0          10
1                 2                                10              

I have Query1 that when executed returns 4 records under 1 field.
I also have Query2 that when executed returns 2 records under 1field.
Is it possible to combine the two results into a third query as such:
 Query1                         Query2

Hi.  I am building an aviation database.  I am want to create a flight
summary query that shows only
Carrier
Date of Flight

I have a data Insert form with FirstName, MiddleInitial, LastName,
Email,Address,
City,State,WorkPhone. There is one more field not included in the form which
is AgentID as the primary Key. I want to insert one record in the table using