Hi
I have created two queries and the datas are picked from different tables.
Example are shown below
when i run Query1, below are the answers

Could anyone please assist me with a query that I wish to set up. The
basis of which is to find the nearest value in one table to a specific
value from another table.
In a table named [Source] I have a field named [CT] which contains a

I have a table that has a Start field and an End field both of which are
Date/Time type fields.  I want to compare the records in the table for data
entry errors since it is not possible to have two activities occurring at the
same time.  

I have an append query that takes data from Table1 and Table2 and appends the
data to Table3 for a mailmerge. Table1 and Table2 are joined by field
PatientID - list all records from Table1 and those in Table2 where the joined
fields are equal.

I am using Access 2000. In a query I have a field called docdate. I wish to
display this field's month name in same query as January, February,  and so
on . So I typed the command   Month:Format([docdate],'mmmm').
But when I try tun the query, getting error mesage - undefined ...

I wrote some code to get data between 2 dates:
   sql = "SELECT Sum(Uren.minuten) AS SomVanUur FROM Uren WHERE
Uren.Datum > #" & Format(Forms![Uur_overzicht]!Start_dat, "DD/MM/YYYY")
& "# And Uren.Datum < #" & Format(Forms![Uur_overzicht]!Stop_dat,

I am struggling with iff Statements. In my query I am trying to deduct one
column from another but if there is a blank in one field then input zero.
This is the statement I have tried but doesnt work...
NA4: iff(([4]-[5]=0,0),[4]-[5])

Is there a difference in results between using
DateDiff("d",Date1,Date2)
and
Date2 - Date1?

It seems like this subject is a popular one, but I can't seem to find a
solution that would work with my situation.  What I want to do seems fairly
simple enough, yet I just can't find a way to do it.
Basically, I have a query, qryLate, that shows people who have not completed

I have a table (say Table A) to which I am storing some data. After that, I
want to be able to insert records in another table (say Table B)
automatically (like by clicking a button).
In other words, I want to do is to read records from Table A and based on

    I've got a form which links to a table, called Input, with a subform
which links to another table, UpdateTable.  The subform table only contains 2
fields, one called UpdateStatus, and the other called ID.  I'd like to be
able to use this subform to add comments to the ...

I've got this SQL giving me a "Syntax error in Join Operation."
SELECT po.merchant_order_id AS order_id, po.source_currency_code AS curr,
po.pymt AS po_pymt, pt.pymt AS pt_pymt
FROM

Hi, I Have to calculate the difference in hours between dates and times
ignoring weekends, holidays and the hours between 6 Pm till 9 Am.
Do any one know how could I do that

I just created a Travel Expense database so there are very few entries in
the child table called tblExpenses. I want to create a subreport so I created
a query that groups on TravelID [each trip has a unique TravelID], the
TypeExpense [Air, Hotel, etc.] and then I want to sum up ...

How can I,  make a queries for the variable length characters. The inputA
field have a length which between 6-4 characters.
I try to use below queries, but got #Errors,
IIF(Len(InputA=6,Left(InputA,6),Left(InputA,4))