I just set up a database (relationships and all) and I wanted to test it.  I
set up a very basic query using the employee table.  All the fields I used in
my query have data in the table.  I used EmployeeID, Last Name & First Name.  
When I run my report, there's no data.  Why ...

I am trying to fix the following query so that if there is no value
exists then a 0 is returned. The original SQL string is:
SELECT Sheet.Drawing, Max(IIf([ADCN.ADCN] Is Null,0,[ADCN.ADCN])) AS
ADCN FROM ADCN INNER JOIN Sheet ON ADCN.RecordID = Sheet.RecordID WHERE

I have a table called students which shows information about students on a
database for a student housing company. I am trying to figure out which
students have been allocated to the same room at the same time.
Every student has a [students].[RoomRef] which says where they are ...

Is there a way to establish the size of the window that results when a
query runs.
I have a query that when it runs, even if there is only one record in
the result, the window is larger than the screen and I have to scroll

I have records that contain pieces of data along with the time (in hours) it
was recorded. the time interval that accompanies my data is not consistant.
I would like to be able to write a query that "fills in the gaps" of the
time intervals. It would list all hours within my ...

I have a form that is used to enter the parameters for a query. I have it set
up with 3 unbound text boxes to enter the starting month number, the ending
month number, and the year. When I enter a month number greater than 9 it
won't show any data on the report. But when I enter ...

What criteria do I need to enter to run a query using wildcards to find a
name within a field but only have a partial name to enter e.g. entering
'health' when the output required is 'Health and Social Care'
As the naming field has more than one entry, the criteria for entry in ...

I am running a series of queries that measure weekly sales for various
products.  Some of them do not have any sales for the week and bring back no
results.  I then create make tables out of these and import them into another
Access database and do a combined sales report.  I ...

I use Office 97 which meets all my modest needs but I'm receiving more
and more files in Works formats because it is being so widely shipped
with new pcs.
Are there any downloads available so that I can read Works files, such

I have a table Invoices with columns Date1, Account and Amount, e.g.
Date1       Account   Amount
3.3.2004     3       100
5.3.2004     2        20

I have several queries in Access that I have to run to populate a some tables
and I don't want the users to see the result of each query that is run.  I
would like the user to click a button to run the queries and just get the
final results not the results to the previous 4 ...

I am trying to make a query where I add a new field that returns the record
position (which does not exist in the orinal table).
For example, the table is:
apples

I have a query where I am counting the number of items each group has...for
instance it would return the following:
Group A  20
Group B

A form-driven query currently generates a report in USD,  I've been asked to
create a similar report using local currency.  (access 03;  created by former
empl)
Seemingly simple,  for an unknown reason,  if I change the fields in the

Hi, As the subject suggests I have an SQL Union Query which runs fine and
produces the results I needed.
I now need to alter this code to change / add / remove fields but when I go
to design the SQL Code - there is no code visible and nothing to highlight