I am new to this forum.
@ I have a mdb and i linked many sql server tables in it. (TABLE_SQL)
The number of recrods in this table are in 9 figures
@ I have a table in MS access (same in which i linked MS SQL Tables

HELP!!
I have two queries and I want to join the information to make one report,
when I do so, the report only shows information from one of the queries.  
What do I do?

I have a query which is calculating "quantities" from information in a table.
The calculation includes a private function given to me by George Nicholson
and Nikos Yannacopoulous on 05/11/05 ( Access Database General Questions).  
This part works well.

I have a listbox in a form which has the following rowsource:
SELECT DISTINCT [Program].[Obligation], [Estimates].[Program],
[Estimates].[FY] FROM Program LEFT JOIN Estimates ON
[Program].[Obligation]=[Estimates].[Program] WHERE

I have an access database which is linking through as a front end to sql.  
The queries etc., I have done work fine all apart from one.
I have created a form and the query needs to be populated from whatever the
user selects from combo boxes on the form.  There are 2 boxes.

I am building a database with 2 forms. One form is called residents which
contains 2 fields called name and accountnumber. The other form called
invoice contains 2 fields called invoicenumber and accountnumber.
I want to be able to click a command button in the residents form ...

How can I select rs with times criteria. I would like to sort only night
times (21:00 - 06:00). I tried so:
vr1=21:00
vr2=06:00

I have an Access database from which I occasionally need to completely
delete data. The data relates to various projects and I usually make up a
list of the projects whose data I wish to delete in Excel. I then import
that spreadsheet into Access as a table. I then use a query like ...

I want to run an inventory where I have a running balance I want to have to
columns one for Issues and the other for Recieved. I also want it to be bale
to run with null values
Ex.

I have an address book database with a field titled "DOB".  I would like to
be able to create a report (but assume I must do a query first) to get a
listing in order by date - month and day.  I want the list to list January
1st bdays before January 2 bdays, etc - regardless of ...

i build some crosstab queries in my code, it takes about 15 seconds t
get query result when running in my application system.
could it be speed up in software way?
thank

I have a several columns in a single table, one of which ("FTE") will be
storing totals for a grouped item ("GRADE") and there will be another column
("TARGET") I want to add a 3rd column which will be a running total of the
"FTE" column to compare against the target and select a ...

I am using Access 2002 and I have a query that I want to count what is
populated in the fields.  I use the total button on the query design bar and
I get the desire total count in my text fields, but in my Yes/No fields I
get the total row count of my database.  I want  the total ...

I am using Access 2000.
I created a crosstab query.  The sql is below in case that helps you.
TRANSFORM Max(qryrptTherapistAuditNumbers.CountOfEmpAuditID) AS
MaxOfCountOfEmpAuditID

I am using an expression in a query that runs a few IIF statements. I would
like to add one more IIF statement to it. below is the orignial expression
from the query.
EstCost: