I am linking to tables from an Oracle db and I need to convert the data/time
fields to date fields but just using Cdate does not work.
I have to take the field convert it to text then use Cdate to covert it to a
date.

I have a database template, I use a new copy every time I start a new
project. In this database there is a query that pulls from 6 tables using 11
fields from those 6 tables.  UniqueValues is set to yes under properties.  
This query works most of the time, but sometimes it ...

I have two tables, Offender and Address, that are related based on the field
ID.  The Address table contains multiple addresses for a given ID and an
AddrerssDate field.  I need my query to select information from the Offender
table and the most recent address from the Address ...

I am needing to update a table with field name custNumber. I have 11,000
records and need to update this field with a number each updated by 1
Can anyone tell me how I create the query to run that routine
TIA

I am trying to incorporate an excel formula into Access.  The formula looks
like this:
'=IF(AND(Ab4=Ab5,Ad4=Ad5),"Piggyback","Standalone")
How can I make a query in Access to check the data in consecutive rows.

I have a form that I use as a sort of GUI for running queries.  My
dropdowns work great.  Now I want to add three radiobuttons to dictate
what criteria will be used in another field.
My three radio button options will be:

Hello, I need to group data based on a field (name).  If another
field(status) includes all "F"s then group and sum, if not I don't want to
see it included in query results.
ex.

I try to set up the following query but get "Undefined Function" erorr
 SELECT Left(ImportEd.Country,3) AS CountryCode,            
 ImportEd.Country, ImportEd.City
 FROM ImportEd

How do I get a parameter query to allow me to use a combo box to select my
search criterai rather than have the user type the info. If they type the
info incorrectly it either does not provide all the records or provides to
many records.

I have 3 queries: qrySingleFactors, qryTeamFactors, qryBothFactors. These
queries contain calculations that differ, but mostly contain similar fields.
qrySingleFactors:
[FullName]

I have a simple contact management database. I'm working with two tables,
[tblAgencyLocations] and [tblContactLogsub]. I sent out 300 direct mail
pieces and I want to record that in tblContactLogsub. The two tables are
linked with a one to many relationship using the Field ...

Add the ability to use a combobox dropdown for query parameters when it
executes.   The current query parameter window only has "parameter" and "Data
Type"  Adding "Row Source Type", "Row Source", "Bound Column", "Column
Count", "Column Heads", and "Column Widths" will allow a ...

I have a query that has a sum total of the entire colomn in a field. Ho
do I create a query that subtracts that sum total from a field in
different table?
What I am working with is:

I have a linked table from a secured database. I have a form based on a RWOP
query to the linked table.
With 1, to say, 50 records the performance is as you would expect, but with
more records it becomes progressively slower to open, with several seconds

hi everyone
festive greetings to you all
im working on a client contact database, and im trying to count how many
contacts i have in postal regions