I have a report that is linked to a query that searches for the letter
"A" or "B" in a field called CompanyType.  I created a function of
Variant type that holds a variable of Variant type.  The variable is
called MySelection.  MySelection has 1 of 3 options, it can be "A"

I have a table with equip# column. The data in the equip# column looks
similiar to the following.
001
002...

Dear NG - Brand new to Access so I thought it would be best to try to
learn the right way right from the start.
I've used the following two queries to generate a list of names.  My
instinct tells me that there is probably a more efficient and elegant

Please help.  
I import a weekly text file and need to bump it up against a Main table.
How would I set a query up to:  
Check the Main table....if PO # exists, then update the qty and date fields...

I have a query that stores dates inputted into the long date format
automatically (time stamp).  I have created a table with short date
format matching particular days with "A", "B", or "C".  Obviously they
will not link together because the query dates have the time included

I am trying to use the value in a combo box to filter a form.  However,
I have not been able to find the right syntax to make my code work
properly.
Private Sub Combo60_AfterUpdate()

I have an Oracle table that I am trying to query off of, and it takes
way too long. There are no indexes or primary keys in this table, with
millions of rows. I have a local table with an "INVOICE" number as it's
primary and indexed field. What kind of SQL statement can I use to

I am trying to create and unpaid aging invoice report.  I have used to forum
to obtain several hints and have been able to create a basic aging inventory
report that looks as follows:
SELECT tblOrders.AcctNumber, tblOrders.ItemNumber, tblOrders.InvoiceDate, IIf

Don't be fooled into beleaveing this is just like any other site online
it can make you money and thats no joke.
Hi my name is john and I can show you how to sell the top rated game
systems you make the cash!!.

I have a query I use to identify the age of certain records, and then
group them in corresponding age buckets.  I am using the following
statement:
Expr1: IIf(Date()-[RequestDate]<="3","1-3

I have a simple query that uses the Between [Start Date] and [End Date]
criteria.  I have been asked by the users to incorporate a calendar.
I tried this without success.  Can anyone help?
Between [forms]![CheckHoursName].[CmdCalendar1] And

I have Access Application that the data is on sql server connected by link
tables.
After i transfered to another databse on sql server by link table, Suddenly
some of the quries, which has many joins, become read only.

I have a database (access) of vehicles, where each vehicle can have many
transactions in any month. how do I access only the last record of a month
for eachj vehicle?  I am seriously stuck on this one

This has me stumped, I want to try and do the following, but am unsure
if it is possible.
A query that goes like
SELECT FIELDS

I'm designing a "site information" database and I'm hoping someone can help
me with the following questions/issues I've come up against, please ?
I've created a form based on a table to display site information on a
one-at-a-time basis.  I want to be able to search and display the ...