I have month long log that has hundreds of entries logged.  I have the form
auto generate the time and date the record is entered using general time. Is
it possible to set up a search criteria to search the entire month but only
display records between the times of 23:00 till 07 ...

I am using ASP.NET to insert records into a Microsoft Access Database. My
primary keys are of type Autonumber. However, because some of the tables
have relationships I need to know the value of the Autonumber field when I
use the Insert command so that I can put it in the foreign ...

Okay,
Age old problem... Looking for the latest date in a table.
Our team has come up with 2 methods... Both work, but there is debate on
which is more efficient/preferable.  

I am using the between dates in a DCount.  I noticed last night that the
data it gets is only the one that are between that date and not the ones that
fall on that day of the criteria.  Is this the case?  If so, what is the best
way to make it include it?  

I am a new user to Access and am trying to set up queries and perform
calculatons. I have one big list of postal codes, state names and country
names that we have taken from visitors as they come into our centre. I've
been asked to develop a database to determine say what ...

when opening a query that has a set criteria a window opens with text box. Is
it possible to change the text box into a combo box so that the proper query
criteria can be selected rather than typed?

How do I convert a date from 6/28/2005 to 20050628?

I have created three frames on my form that consist of radio buttons (range
from 3 to 5 on each). I have gone into properties and mached the Name to the
Control Source. Do I need to list each radio button in Properties for the
Frame? And, if so, what field do I list them in?

Sorry that this is a bit involved, but any help would be appreciated.
I have an application that requires a checklist for salesmen.  The list of
checklist items is specific to a territory, so several salesmen will have the
same checklist items.  As a salesman accomplishes an item, ...

I have two tables with the same fields and I want to run a query that stacks
the information on top of the other. Sort of like an append, but I do not
want to create a table.  Ex:
T1 has ID, EmplID

I have a table of dates.  The year, month and day are three separate fields.
When I make my table, I'm including three extra fields, one for each, empty
text.
Next I want to make a pass to fix the years.  I'm trying to use:

The following query fails in Access 2003 with the error:
"Undefined function 'GetReplaceFactor' in expression"
GetReplaceFactor is a User defined Function in the SQL
server database. What is the correct syntax in Access

I have a table column defined as text data, formatted as dates in the
form "MM/DD/YYYY". I need to query this table for records of date range.
The results I get do not match my criteria. For instance if I ask for >
01/01/2005 I get back records from 2002.

How can I restart my running sum when I enter a new date range? It appears
that I'm getting all of the previous months prior to the date range that I
have selected in my query.
RunTotItemsComp: (SELECT Sum([Items Completed]) FROM [qryItems Completed by

The error message I get is that my IIf statement is too complicated.  I am
trying to calculate leadtime demand.  I want it to find a specific number in
one field and then return a value from another.  
LT_Tot_Dmd: