Here is the requirement: Ability to enter start time and end time to produce
a report/query that displays only transactions that fall within that time
frame. And also a query to return the number(count) of transaction within
that time frame.

i want to create a query that deletes all data from a table and then imports
new data from a text file. can i achieve that?
i want to avoid running the table delete-query and then importing the text
file and setting the import specifications since i have to follow this

I have a table with ID and DtH fields.  There may be more than one of the
same ID. I want to have a query just show me only the first occurance of each
ID and I want to be able to update the DtH field for the first occurance.
ID             DTH

I need an expression that will give me the earliest date that is after
[res_date] and
which falls on a day of the week that is specified at runtime.
So given [res_date] values of:

I am not sure if this can be done but...
I need to get the difference from dates in the same column.  The dates
represent when something has been updated.
Ticket    UpdatedTime

I want to only select tickets based on Max Update date and if it is equal to
a specific assignment.
Max Update date = Assignments needed =  fib, fbsi, ibg, ibgnf
Ticket    Update date        Problem Status      Assignments

SELECT tPtData.ingPtID, tPtData.strLastName, tPtData.strFirstName,
tPtData.strFrstSeen, tVisit.dtmVisitDate, tVisit.[sng#MissFng],
tVisit.[sng#MissToe], tVisit.ysnLimbLoss
FROM tPtData INNER JOIN tVisit ON tPtData.ingPtID = tVisit.ingPtID

I need some assistance with this query that I am using. % retained: [sumofX]/
([sumofX]+[sumofrtc]). The problem with this query is that if only
transactions entered are X transactions I never show % retained until RTC
(roll to competitor) transactions are entered. I would like to ...

In a query is it possible to not input any data into a field wich is the link
to another table. For example. In my query i have adn employee ref (Ee) and
by inputing a reference into this cell is pcks up the employee name from
another table. There are 10 employee ref's on the ...

I've created an access query of which I'm trying to "summarize" by part by
customer.  Example of query "raw data" and what I'm attempting to summarize,
below:
"Raw Query Data"

I have mutiple tables that are linked to an Excel file.  I would like to be
able to create a query that will combine all of the tables into one.  My data
is as follows:
Table 1

I am trying to write a query where the select's where clause is "WHERE [Name]
like 'access.' or [Name] like '\[access\].'" but it does not work.  If i
remove the '.' it works fine, but i need look for records that include that
period.

I have an Access Database with a 'full name' field. Unfortunately, the
actual name (the data) is sometimes, also appended with a ten digit phone
number. Thus I have, in the name field, "full name phone". Phone is always a
number. There is also another field called "phone" where ...

I have a table called Vessels.  In that Table the ID is used to track vessels
through out my database.  Normally I would link the drop down box and use the
ID on forms to show the vessel name.  This I understand how to do.  But I
want a text box to display the same information. ...

Greetings all.  I have a query containing fields of numbers of households
engineered which come from one table.  For example, there is a field for
single family units (SFU), multiple dwelling untits (MDU), and commercial
units (CU).  For one record there might be 100 SFU, 50 MDU, ...