I used to know how to do this :( I have a query that shows sales for our
accounts. I'd like to be able to group the accounts in tiers e.g. all
accounts that sold between 0 and 5 dollars grouped together, followed by 5.1
to 10, 10.1 to 15 etc. My fields are AccountID, Sales. Any ...

I cannot see "create query in design view" when I click "Queries" button in
Access 2003.  Please advise!!!!
Thank you,
Sindy

I would like to import specific data from Excel through a query, but am
having difficulty figuring this out on my own.
What I would like to do is Import cells CURRENT EMPL!A7:A180, CURRENT
EMPL!C7:C180, CURRENT EMPL!H7:H180 from an existing excel Datasheet

It's been awhile since I've worked with one particluar database of mine and I
have forgotten the distinction betwen last and max  - could some one help?

I am trying to filter data that is dated less than the current month last year.
Would appreciate any help with this.
Thank you

I have 4 colums I need to display all data it looks like this
itemcode     description    ordernumber   cost
however I may have the same item code over and over but I only want to show
it once what do I need to do.. Thanks for help

I want to know how to perform a "Shrink to Fit" function in Access in the
same way that you can shrink text to fit within a cell in Excel.
Thanks

Is there an SQL query that will return  a list of all indexes on a
particular table?
In addition will it list the fields involved if it is a compound index?
Thanks,

Is it possible to have font colors or background colors change in a query.
I have a simple select query that selects 2 fields from 2 tables.  I then
have a IIF statement that if the records match, display "PASS", if not match
display "FAIL".

Dim MyDate, MyWeekDay
MyDate = #February 12, 1969#    ' Assign a date.
MyWeekDay = Weekday(MyDate)    ' MyWeekDay contains 4 because
   ' MyDate represents a Wednesday.

Hi Group,
I'm trying desparetly to remove duplicates from the query listed below.
The query returns 39 records but I know that there are exactly 38
unique records (ApplicationRefNo is the primary field).

I have a query in Access 2000 which uses the value of a form control in an
expression to add a fixed value onto the contents of a field. The query is
run from within a procedure called in response to clicking a button on the
form after some other calculations have loaded the ...

I am usingtwo tables
table1 tracks companies and there company codes. PK is company code
table2 tracks the companies transactions. PK is autonumber
when I run

Ok so here's my problem:
i have 2 tables: Jeff, SD
there are 5 fields in each: ID (primary key) and 4 others
First I have to make a query that finds matching records in the 2 tables

i want to find all the records that are like "xxx*" but i want xxx to be
entered on promt.  how would i do that?