I am running a query that displays in access as:
1.00000000154924E+18
When exported to Excel it displays as:
     1000000001549240000.00

I want a parameter query that prompts the user with a drop-down list to enter
the data, rather than the user typing a string.  This way, I can limit which
data the user can search for.  Is this possible?
If not, how can I prevent Access from displaying a blank record when the

I have a table containing meter info and another table that is supposed to
contain a row for each month for each meter in the main table.  I need to run
a query to identify the meters that are missing data for a particular month.
Using the data below I want to be able to run a ...

Is it possible to take a specific column and specific row, in an access
database (Access 2003), and convert that positive number into a negative
number?
Please let me know if you have any information.

I'm probably doing something stupid here but here goes...
I'm running some append queries...if there is no value in some of the fields
I get a validation error and it says Access can't append all of the records.
The table that its appending to does not have the "Required" field ...

I have multiple records that can have a grand total of 100 in field a.  I
only want the records starting with record 1 (being the most current date)
that will equal around 50 (what is my cap) and delete the other records.  How
can I do this in a query not in reports?

hi, i would like to know whether some one can give me a criteria for a
parameter query which wil fulfill the following: basically i have a form
consisting of two fields i want the parameter query top use both these
feilds. field 1 is minimum price range and field 2 is maximum ...

I'm pretty sure this can be done but I'm tripping over it. Isn't it
possible to perform a StDev calculation on 2 column value of 1 row?
For example:
ID     | Column1 | Column2 | StDev

I loaded a file with participant ssn numbers, but there are duplicates.  How
do I get rid of the duplicates to get a record count of pariticipants?  I can
do basic queries in Access and need help.

We have a form with a combo box and that combo box executes a query to find
all of the records matching the user's name. The query derives that value
from a form based parameter called vName.
This is how the process works.

We have approximately 4,500 students in tblStudents, and as you would
imagine, there are numerous students with the same last name.
I have a Find a Record combo box on a form where the user types in the
student's last name, hits the Enter key, and Access displays that student's

Microsoft Access 2003.
I would like my Main Menu form to open when a user opens my database.  So
far I am in no way networked or web based, I'll probably get there but right
now I have a file (Inventoryv4.mdb) that resides on the user's hard drive.  

I am using Access 2003
I want to create a billing statement report from a query that will give me
all invoices due by a specific client, and I would like to have fields for
amounts that are 30, 60, 90 days etc....

Within the db I have a performance table where user input their ID, date,
part#, side, startseq & stopseq daily. Then on another reference table with
field: part#, side, seq, time (min).
What I would like to calculate in the query is look at the start & stop seq

I have a table where the users are supposed to input a row each month for
each account.  I need some way to audit the table to make sure I have an
entry for each month in the current 12 months.  The table as a field called
BillDate but if it's an account that bills near the ...