I am new to this and this is the next step in my learning process.
Thanks for any help you may offer.
David

I use an append query to add a record from my master file table to a current
job file table. It works from a command button on my input form that prompts
for an ID number. Unfortunately the imported record never shows as the active
record (it sorts alphabetically by default into ...

I have a query with one field that calls a function.  The function performs a
time difference calculation and converts it to time in days (i.e. 0.0125).  I
checked to make sure the output was numeric by "isnumeric(Calculation)" and
it always comes back as "True".  So the function ...

I need a field in a query that calculates the number of business days between
two dates (that are existing in a table) in a query.
Thanks so much for your help.

I have a report that includes [test_results] which are subcategorized by
client [location].  I'd like the report to show the [location], even if there
are no [test_results] recorded for that [location].  The query supporting the
report is based on a date range in which the test ...

I am supporting a dept. where there are a number of databases and a host of
queries written to those databases.  For some unknown reason, most, but not
all, of the queries appear to everyone who has access to that set of queries.
I can't find anything regarding sharing or rights ...

I have a problem in that I want to create a query with two tables that have
exactly the same fields in them.  The fields in each table are based upon an
Admit Date.  One table is called the Encounter table and the other is the
Encounter History table.  None of the dates in the ...

Why am I getting the following prompt when running a make table query. I am
at a loss and am not a novice.
"The existing query 'query name' will be deleted before you run the query."

Trying to total a field on a report. example:
_Field_
$44
$58

I need to create a query which only shows records where a field called L2 is
blank.  This field was set up as a text field.  I tried using the criteria
="" and I know that there are records where this field is blank, but I get no
results.  What should I be putting in the ...

I have a query that for some reason will not show only the top 5 records.
Where this comes from is a report and within that report I have another
report and only wish to show the top 5 records.  But the results are very
crazy and sometimes I get nothing.

I get this when trying to create a table (one time, then I will delete
and populate) from a query.
I have seen good answer to this if my query includes autonumber fields
but my query does not contain ANY autonumber fields. I can't understand

I have a simple table at the moment that records the date and time, e.g.
01/08/2005 13:33:00 for a particular person.
Here is the table schema:
ID :: Autonumber,    4

I have a combo box with 4 columns that is bound by the first column, and
stores the selection in the underlying table - the combo box works fine, but
after the user makes their selection, all that remains in view is the item
selected from the first column.

I'm trying to write a MakeTable query that will bring together data from a
number of tables and export it as a single table to another database.
Unfortunately when I run this query I get the following error "Resultant
Table not allowed to have more than one AutoNumber field."