Hi. I have a query named Query1. Let's say it looks like this:
Select * from Table1 where Field1=[Enter Value]
So whenever you run the query, it prompts for "Enter Value".
So now, I have Report1, whose RecordSource is Query1.

I am trying to construct a semi duplicate query. I want it to match 2
fields and check a range for the 3rd match as follows
date = date, title = title, and start time between start time and end
time???

I have a form that displays general information about an alarm permit
location.  There's a subform that shows detailed information about
burglar alarms that have gone off at the location.  When a new alarm is
entered on the subform, I want to print a report that shows the general

Hi, I'm having a bit of trouble editing an old database that was
created quite a while ago by someone else.
There is a form that lets the user select a member of staff and show
details about the training they have had.

     I am not so good in queries. here is my problem
2 tables to store the received items (fabric)-- inwardmaster,
inwarddetails
and after some processing (Dyeing)

I have a form based on a table. The table has a
Yes/No field. Its an A97 table. The form has a button
that updates the value in the control from No to Yes
for the record currently being edited.

I am new to Access. I want to know how to build a query that will
display an occurrence count of each distinct entry in a column?
Example
SNo   State

i  have a table the fields are
company   contact       phone num
on a form i have a combo box that selects from the  list of companies,
i also have a several text boxes.

Is there any way to change the default search to "Any Part Of Field"
instead of whole field?  The first thing I ever do when searching for
something in a field is change the default setting from "Whole Field"
to "Any part of field" because that way I don't have to key in the

I have a "form" and "subform" where I would like a calculated control
on the form which sums the values of a datasheet column of the subform.
(datasheet on subform may have a variable number of entries)
I can't seem to get the calculated control on main form to do what I

Hope someone can help me with this - I've been staring at it stupidly
for hours now, convinced there must be an easy way to achieve the
results I want:
I have a very large table recording every sale made by one of 90

I currently use the MS-Access automatic report converter to throw some
of my reports out as HTML.  That works OK but often the report's layout
is distorted and I would like to improve this.
Ideally, I would like to output the reports as PDF, but my client has

My table has an autonumber field and a text field named
[RawData]. Many records have unnecessary spaces padding
the front and end of [RawData] - at least, I think they're spaces.
The look like spaces to me.

Strange one this.  If i double click on a control or right-click and click
Properties nothing comes up.  Even View, Properties doesn't work.
Have done a detect and repair to no affect and the database works fine on
the laptop.

just wondering if anyone could offer a bit of advice to me.i have a
database with a list of contacts on it with a checkbox beside each one.i
was wondering if it was possible to place a command button on the form so
that when you click it it opens an email to send to all those with ...