I have some backend tables in a SQL Server 2000 Database linked into
my MSACCESS database.  When I run the following query in Access I get
0 (zero) results.  If I run the same query in query analyzer, I get
the correct results.  Can someone please help?  I think the problem

I have a query that takes the dates that people have worked, counts the
ammount of work done each day, and then total all of that data.
Ideally (as I am exporting to excel), I would like to just show the total
once, or just at the end of the count (like an "=sum(a1:b20)" in excel)

I am creating a DB which tracks and atuorises Final accounts for a project i
am workiong on, and I need to be able to show the savings I am making after
challenging the initial request for monies. To this end I have used the find
duplicates wizard to crearte a query (SQL below) ...

Right, I have form with an unbound drop down list using a column in a table
for a row source.
I also have a query returning results from the same table.
I have setup the query to use critieria [Forms]![frmname]![dropdownlistname]

I trying to retrieve values from a table to calculate the 14days average
value of a stock closing price. However, i encounter problem when there is
13records left on the table, my code seems like can't get out the For Next
Loop.

My task is to query a table in a VBA function and then return the count to
the calling environment.
How do I do that inside the function?
The profile of the function is something like this:

I'd like to isolate patterns such as 2A3672, 3B3696 and 6T3930.  I can find
records with this pattern with the following query:
SELECT InventoryOct2006.Originator
FROM InventoryOct2006

Just wondering if anyone can help me with a problem I am having.
I have created 4 crosstab queries to create a report for the Board broken
into columns by department
1.  How many enquiries

My task is to query a table in a VBA function and then return the count to
the calling environment.
How do I do that inside the function?
The profile of the function is something like this:

Can anyone tell me what this expression is doing?  What I'm trying to
determine is if this is counting back 365 days from today's date or the
[Screen Date].
IIf(IsNull([DEN1 Screen Date]),0,IIf(DateDiff("d",[DEN1 Screen

Have looked for this but cannot find the answer.
I have a form called 'complaints', this form has a button on it that then
opens another form called 'improvement'.  the improvement form displays info
from the complaint form such as complaint number and persons name. the

I am working on getting my vacations tables to work better.
What I am trying to do is to get a query for the 'StartDate' of staff
vacations.
There can be between 3 - 7 weeks of vacation for staff, with each week having

Im trying to get all the files with any time posted 3 hours earlier
than the current time. I'm using the DateAdd but it does not return
files
DateAdd("h", -3, Date)

I have a field that contains banked time by employees. So some days the
employees bank time and some days employees use banked time. So days where
bank time is gained the value is positive and days when it is used the value
is negative. I have a query that calculates the sum of ...

I have 2 tables set up.
First one is called tblcustomers with primary key field called customer
account code.
Second one is called tbllookup also with primary key called customer account