Hello.  I have a query that I want to sort on multiple levles at the same
time.  Fields that I want to sort on include include: Container, Warehouse,
Aisle, Section, Shelf, and Position.  Query records may contain the same
Container value but different location infomation.  I ...

I have a query which has parameters from the
Form.(Forms!Products!Poduct_Name) with the number of Products. The numbers of
Products are count of number of IDs.
That is

I'm new to ACCESS 2002 and I have a question on a string.   I have a password box that requests the user to enter a password.  If they enter a password the process works but if the password box is left empty it fails.    I have the code below.  Thanks for your help
This is in a ...

I need to calculate the financial years from a table with over 10 years worth
of data for comparison, cannot use IIF as too many variables, anybody got a
funky shorthand way of doing this?

I have a city column and I would like to be able to type the differenct
cities in a prompt that comes on the screen instead of having to keep
changing it in the query design.
Is this possible?

I need to multiply records according to the [QNTY] field.
HOW!?

I need to duplicate the last entry in a table (except one field).
For example if my table is (my key is a combination of ID and Version)
ID       Version      Name     Salary
2           1             Bob        100

I have a table (tbl_employees) with the following fields
ID
[F]irstName
[S]urname

I have a form in which users can select one or many managers from a listbox.  
I got some help on creating code that generates a criteria line for the query
based on what managers are selected.  What I'm trying to do now is pass the
criteria line to a text box so that in the ...

For subject matter covered in my book collection, I have a field which in
table design view shows as type MEMO, into which in form view I copy/paste
keywords from a combo list of all the keywords I have in use, to ensure I
use the exact same spelling etc each time. I separate them ...

I know how to use a form to prompt for user parameters for a report that is
executed from a command button on the main screen (executable). However can
I, and how, us a form, or a prompt of some sort to have the user enter two
dates, that then feed to the query and execute it? ...

I want to do an unmatched Query, If the Employee appears in the first
Query I don't want it in the second Query.
QueryUnPaid
SELECT tblChecks.ChkServer, [EmpFirstName] & " " & [EmpLastName] AS EMP,

i have data in a table as below, am displaying 4 columns only, the table has
20 columns. i.e. for each phone number i have a corresponding date in columns
but is in a separate record so i have 5 time record entries as that of total
number of phone numbers :(

In earlier versions of Access there was a query, which I cannot remember now,
that changed all caps data into upper and lower case.  It would leave the
first letter upper and change the others to lower case.  Does anyone know how
to do that in Access 2007?

I use the sample Listbox with Multiselect used in query from Duane's sample
database found on Roger's library, and it works great - I almost understand
the logic behind it. However, I need to select from two different listboxes
for the same query. One is txtMultiEvent and the ...