Hi there...
I'm having an issue with data I'm selecting from an Access table using
ASP-based SQL.
Background: I have a form where a user enters a value (called text1 where

Is there a way to set the format for a field in a query. I have built an
expression in a query field that combines the day, month, and year from 3
respective fields in a table so that my new "date" field in the query
combines all three. For reference it looks like this:

I have a contacts database with a drop down list for organizations. When a
person picks the organization I need to have the department drop down show a
list of all the departments. This is just giving me 3 different departments
with their organization. Any suggestions??

I have a database of maintenance orders and we want create a report for
follow up customer satisfaction surveys, based on randomly surveying a third
of the orders.
The order number is a numeric field (an integer).  The obvious way to select

Several months ago, I imported data (general demographic info) from an Excel
Spreadsheet into a simple Access database. Since then, I have added new data
(new customers, addresses, phone numbers, etc) to the same database. Upon
running a query, Access only pulls the old data and ...

I am creating a database, and the data entry will take place on a form. I
want users to be able to select an item in one field,and based on that
selection, the second field would populate, giving pertinent choices. The
problem I am having is that I cannot get the second field to ...

It's been a while, so maybe I just forgot how to do this ...
I have a report based on a query, and a subreport based on its own query.
The parameters for both queries are obtained from a form.
If the the query for the subreport returns no records, how do I refer to

The simple(?) problem is:
We have a Table 'Batch', with 2 columns: Batch and State, with this data:
Batch   State
A       3

I just started using Access this month and I am creating a database for the
company I am working for. I have created a query that searches for a job type
if you enter a job division #. Example-> "Enter a division number". You would
then enter a number like the following...01050. ...

I am using Access 2003 to gather accounting data and create a table that is
exported to a text file for transmission via the internet.  The web
application requires the date format to be MM/DD/YYYY.  The accounting data
and the Access Short Date Format use single digit month and ...

I am creating my first database.  I read through some postings and I THINK a
nested query would fix this problem but I'm not sure ... and, if it IS the
fix, I am not sure of the right syntax to use.
I have a query that is calculating overtime totals for employee time

Hi again
I have a field in query that is numeric. It calculates hours worke
for a day for hourly workers. I have one employee who is salary
How do I make my query show a BLANK in the field if the employee i

How do I pull all records in a database out that have a specific month in the
date format

I have a table that contains 30 check boxes in it. This table is only used
when someone removes a vehicle for work. The boxes are used to note if there
is a problem with the vehicle, i.e. Throttle does not work (Check Box).
I need to create a query that would look for any field ...

Ken you helped me last week with a query to find missing dates from my
employee db.  It works great except I have found that it returns all dates
from my employee database which contains approx 1000 employees.  This is a
statewide employee table.  I need it to return only ...