I have three tables:
Accounts - store an id and information about the account.
External Transfer - stores an account id and the amount transfered into the
account

I work for a residential home builder.  I have a query that pulls notes
regarding homes.  I have another query that combines these notes with the
details of each home--project, unit, plan, address, homeowner (if any), etc.
I would like the results to display all of the fields ...

I have calculated date field in my query:
Target Closure Date: [Date Report Issued]+45
the problem is when i try to filter particular date range in the Target
Closure Date field (ex: between 8/21/2006 and 8/31/2006) it doesn't work. Now

I have a table of Job Codes as follows:
Job Code        Job Family Number
The Job Code field is populated, but the Job Family Number field is
currently empty.  I want to add a value to the Job Family Number field based

I need to retrieve data from a table which is 4 columns by 4 rows, I have the
column and row information but don't know what statement to use to look up
the information that I need

I have a query that is grouping by a process ID.  This ID has several
different names associated with it due to entry errors, etc.  I would like to
group by the ID and keep the most frequently occuring name.  For example:
Table:

In an Access database append query, I could put   Forms!frmOrders.OrderID    
in and append it to an order details table.  I can't seem to be able to do
this now that I am using a SQL database in an Access Database Project (.adp).
The 'Build' option is no longer available to help ...

I have a table where we key-in Delivery notes for customers; in my form I
use the following : =Nz(DMax("[dnnumber]","delivery note table"),0)+1 to have
continuous DN number, and its working fine.
At the end of the day, our remote office e-mails me a list of DN that we

I have an update query where I am trying to remove the '.' out of the version
number and populating a numeric field.  On execution I get  a type conversion
error which I assume is because I am trying to populate a numeric filed with
a string field.

Can somebody help me with an urgent request, please?
I have been given an Access database file that has the table 'Table' and a
field 'surname'.
Data in 'surname' is all in Upper Case. I need to quickly change this to

how come when I'm doing some SQL queries, access auto change my dates to
strings??

I'm trying to write an update query, but am stuck because the criteria
required make the query non-updateable.
tblTask:
TaskID (pk)

I have an excel sheet linked to an access database but it is setup as read
only(and must stay that way), It will not allow me to run queries...(I keep
getting an error message). Is there a simple way (I don't write code well) to
do this while keeping it read only?

i want to calculate the overtime hours
if someone work from 6 am to 4 pm but the work duty is from(7:30 to 2:30) i
donot want to calculate the time between (7:30 to 2:30), he worked 3 hours
extra but how i can figure it do any one have code for it i can but it in

I'm quite new to microsoft access program especially access query. Could you
explain to me what type of query should i use to get my output table. At the
moment, I have no idea how to do this task.
These are my original table and output table.