I like to get result of net banlance from two tables opening balance and
Transfer.
What should be condition in query?
Opening Balance:                                     Transfer:

Good Evening, I have a existing records this:
Date                 Time
10/05/2008       10:30:28
10/05/2008       00:12:55

I want to do one query with function Dmin but is not work...
is possible to do this?
PF:5,44*[Activa_P]/(576*[POTdec])*DMín([POTdec];[Activa_P]/(24*[n_dias_mes]))
where POTdec,Activa_P, and n_dias_mes are fields to diferents tables

I have a database that is designed for an estate agent.
For part of my database i need a form that will let the user input the first
3 letters/numbers of a postcode eg: CH4 and the database will search for all
properties that start with those characters. Im so stuck, really need ...

I want to get the Total from the purchase table as bellow:
Purchase :                                             Total:
 MName        Qty          Date                    MName        Qty      
Date Range

I have one Union Query which contain only customer Names, when i link this
query to Month Query and Current Query it should give me correct amounts of
that particular months...
Example:

I have the following query.  I have formated [Prod Date] as "ww" to give me a
week number.  I then want to get the sum of [Shop Hrs] for every particulare
"ww".  Attached is the sql view.  Any help is appreciated.
SELECT [Zee's Schedule + Capacity Known QUERY Query The Real Deal] ...

I'm writing a VBA routine within AutoCAD to query a Table which has a name of ALL LAYERS.
I believe it's have trouble coping with the space in the name.
Dim SqlStr As String
    Set MyDB = OpenDataBase("c:\dwgs\docs\BH-Data.mdb", False, True, "MS Access;PWD=sbpl123")

I have a query that returns a range of vehicle numbers, it possible for it
to give me count of vehicles that fall between: 0 to 100, 101 to 200, 201 to
300 and so on. Is this possible? I ytied using a crosstab query but I have
too many records (about 10,000) Yes I work for large ...

I have the following query with the Top Values property set to 10.  I am not
getting the expected results.  The query is resulting in only the top 6
instead of the top 10.  I have duplicates, but I don't think that should
matter???  Any ideas why?  Thanks.

I am trying to rank using the following query:
SELECT Emp1.DFWeek, (Select Count (*) from  qry_Defects_by_Oper_Shift_Chart
Where [DFWeek] < [Emp1].[DFWeek])+1 AS Seniority
FROM qry_Defects_by_Oper_Shift_Chart AS Emp1

I have a Table called [Data] with 3 Id’s fields that track changes made by
the users.  
[Data].[LoginAdmin]
[Data].[LoginCallback]

I have a text field for college names.  Unfortunately, our data entry people
have been inconsistent in how they enter school names, making select queries
a bit problematic.  For instance, "George Fox University" may have been
entered as

I am trying to calculate the difference for a record over time.  
So far I know the following:
I don't know how much of a resource is used over time, but at the end of
each month, I do know how much has been used from the beginning of the year

I have a database with a "main" table that is linked to several
"history" tables, in one-to-many relationships. The history tables all
have an auto-number primary key, a personalID field (for employee
number), a date field, and one or two other fields (that stores