I posted earlier and was able to pull a query using Unrelated Records but now
I need further assistance.
I have three tables:
One has 15,000 records of account numbers and names in two different fields

There is a field in a table that give a date time stamp.  I want to be able
to do a query on just the date part of the field.  Is there a way to extract
just the date and not the time.  Or can you separte the two by using a query
into two seprate fields.

Hi, All
I have a question,
How can i specify the size of the dialog box with "Enter Parameter Value"
it has two buttons "OK" and "CANCEL"?

I feel like I'm posting something every day here.. In any case here is my
problem;
I'm importing table from Excel into Access and that works fine but I need to
do some cleaning up before I start comparing imported cases with currently

I have a table with 7 columns of team member names.  I need a count of all
team members, but need to eliminate duplicate names.  How do I query seven
different columns in a table and eliminate the dups?

How to write an access querry to select 12 most digits in a field

I have a raw_data table (originating from an external source and pasted
regularly into Access).
I have a normalised_query query based on raw_data and doing 'stuff'
including converting a text column to a number column.  Where this

I have two queries built into one. From my [clock_table] the other from my
[time table].
This data base I have inherited. The [clock_table] which I created dervies
work time from

Can you combine multiple functions into one with Access 2002 connected to SQL
Server? If so, how?
Please let me know if this is the wrong group for this type of query.
I have 3 functions, they all take in the same parameter BETWEEN @Start AND

Please help!!!
I have entered this innocuous expression in a query in my database:
Days lapsed: Now()-[Last contact]
and am picking up this error message:

I have a data list in 1 of my tables and I would like to look for a specific
record in that list for example, by entering an unique field (Employee ID) in
the table; instead of using the navigation buttons in the form or select the
data using combo box.

Hi
I wish to append a new record to a separate table (before clearing the field
contents for re-entry) using a command box. There are no other unique fields
(the record entry form is a subform).

Hi,
This is a sample of the data i am working on:
2012088552    300    04/27/2007 16:53:14
2012091284    300    04/28/2007 19:41:34

Hello
I created a database to generate grants received.  I would like to know how
to tracks with reports are due.  The reports due dates varies per item such
as, bimonthly, monthly, annually, no reports.  Please help

I have three tables with the same unique identifier - Account Number
One table has all the records
One table has Cars
One table has Trucks