please can any body tell me if there is a speadsheet or template available
anywhere on a  web site, so i can keep track of my teams scores and transfers

Is it possible to use a form to input a field name and then sort records
based on that field?

I am using the wizard to create the query criteria on finding duplicates in
an invoice table, and selecting on 3 fields(customer number, invoice number,
period of coverage) that can have duplicate records.  My dilema now is that
there is a fourth field I would like to include in ...

I need to convert a text field that contains $ and decimal to a text field
with the dollars and two pennies but without the $ and decimal.  Such as  
$251.87  to  25187.
I tried the FIXED but that only takes out the $ sign.  

I have a table that looks like this:
Lon       Lat        Chan     RSSI     BSIC
82.1      40.1      333       -80        2
82.1      40.1      334       -96        43

I have a multi-table database with junction tables for many-to-many links.  
I use combo boxes for some ot the standard query data (to enable accurate
queries). Lately, I've been pull out my short hair. I go to a query (or a
form based on that query) and attempt to change combo ...

Access 2003
I am using a query to return a group of products.  in the criteria box I
have this
[Please enter product number]  Obvisouly when the query is run the user is

Suppose I have imported a table from
a log output with a sample like this:
fluxcapacitor        .80
widgit                   in stock

I'm going crazy.  I know there's a way to add criteria in a parameter query
that will return all records if the parameter box is left blank.  I've done
it before but I can't find it in the help system or in here (surely because
I'm typing my question incorrectly).

when I run a query on data base it's very slow; whe I run other query in the
same data base the speed is normal, what can i do?
thanks.

Hello to you all Access gurus out there,
I understand it's easy to list the name of all saved queries of a given
Access database via Msysobjects system table.  However, I have not seen any
posting over this NG or other similar ones that also include SQL

Is there a way to name a report so that the report, when spooled to the
printer is visible.
i.e.
Report page 1-500,

I have a table with fields  city and then sinlge room, doulbe room or suite.
What I am trying to accomplish is having the user input town name and then
choose only one of the other fields and return only the room that was entered
in the parameter. Another words if double room is ...

I have the following table.
Table: MyTable
IDPrimary    IDBook    IDPurchaser
1    1    1

Access 2003
I am using the following query and would like to know how I can sort the
output on the following fields.
ContId ASC, common_name ASC.