During Form Open, I'm filling a combo box with a list of file names from a
directory: tmp = Dir("*.txt"), RowSource, etc.
What's the best way to sort ASC/DESC this list as it comes in, so they're
all sorted correctly in the drop down. Or do I have to store data in a tmp

I have a database for which each record can have any number of 21 checkboxes
selected.  I have created a query to pull the values from the form unless the
value on the form Is Null.  To do this I used the following statement in the
Criteria field of my Query in design view:

It's a Bed and Breakfast. There are two Access Tables in the query. No
spreadsheet. The Reservations table has room numbers (some of which repeat
because different customers rent the room during different time periods),
customer numbers, check-in and check-out dates. The Rooms ...

I have a report based on a query that returns employees holiday dates in
descending order.
This works well but new boss only wants to see the last holiday that
staff had. I have tried various methods of trying to return the LAST

I have a query that I am subtracting Feild1 from Field 2 I would like for
the difference to be a Whole some of my amount are negative number like -2
I would like to remove the minus sign can I do this?
Thanks

I am working on a YTD Sales report. I would like to know if I can create a
cell in a query that will be a squential number. Starting with 1 on up. If so
how would I do this?
Report would look something like:

My query searches my table of employee records based on three possible
selections from a list box - "Active" - "Retired" - "All".  When I select
Active or Retired it works ok - how can I get the query to show all records
when "All" is selected in the List Box since none of the ...

I have a check box on table:  FLW
You are to check as many services as was provided with this client on this
contact.
List of services:

Two tables--Rooms and Reservations. The Rooms table has a room number field
with repeating numbers. How do I consolidate those in the query, and
determine the income generated based upon the check-in and check-out dates?

Cost:                Proceeds:         G/L St                    G/L LT
30,000              31,000              $1,000
25,100              24,095                                           ($905)
4,000                5,000                 $500                      $500

I want to create an update query that takes the value of one field
(INSCRIPTION) and updates the value of another field (LANDOWNER) in such a
way that whatever is in the INSCRIPTION field is stored in LANDOWNER field as
ALL UPPER CASE LETTERS. I know how to format the field in ...

I am trying to remove the leading zeros from a 16 character text field.  I
have tried using the val () funtion as well as the right () function.  Each
time I run the query it asks for me to enter the "Parameter Value" and lists
the field name.  I think I am querying an Oracle ...

I have the following query:
UPDATE tblMyQuestions SET tblMyQuestions.StudentName =
tblStudentCodes.StudentCode;
When it is run, it says "Enter Parameter Value" and then displays

SQL WHERE clause usually asks you to enter each field you want to search.  I
would like to know if there's a quick short hand for indicating I want a
search on the entire table without entering every field!
SELECT

I have two tables who have a relationship based on ID.
I want to make a query where the parameters for the criteria are asked and
then according to the selection, all of the ID's and Name's are in the
resulting query with the listed paramter (field) that was chosen.