I have a query that has 3 fields.  The first is [Job Description], the second
is [Min] which calculates the minimum salary of each Job Description, and the
second is [Max] which calculates the maximum salary of each Job Description.
How can I get a calcuated field in this query to ...

Windows network, Access 2003 database - not an MDB.
Whne I compact the development version of the database it doesn't compact
nearly as much as it does on my collegues computer.  Has anyone ever
encountered this or have an idea why the compact/repair feature would not

I am having difficult where some of my data is exporting as text and others
as numbers. Can anyone help?

WinXP, Access2003 and Access 2007
There are two ver of Access i.e ver 2003 and 2007 in a set of PC's running a
database. The master copy of the DB is on ver 2007 and replicas on A2007 /
A2003. The problem that I am facing is that when I change the structure of

I am curious to know if I can create variables in access, similar to
the way the autonumber is generated. I have 3 types of hardware items,
Panel, Loose and Field. I have values P1-P76, L1-L76, and F1-F76 that
belong to each HW type.  when a user goes to order Panel HW, I would

I have created a database for personal info, with about 10,000 entires to
add, and about 8000 more to go. I am currently around 1600 personal entries
and I have noticed that several of the GENERATED numbers are skipped. When
you create a new entry, you can hit the "new," button ...

I'm in the process of creating a new data base and using email to gather
purchase orders.
Now what I wonder about is if this idea is even possible.
Ok so I have a master key list with all available products and have a list

Sorry for the newb question but I am trying to figure out what Function to
use when looking for a specific character or string within a String... please
respond if you know!  Thanks!

I am using access 2003. I placed all of my fields using design mode of my
form, when I close the form out and renter the form it is blank. I can select
design mode again and the fields return only to diappear again upon exit and
re-entry. I cannot figure out what is happening, I ...

I have a consumables database running via SQL05, the front end uses the 02
runtime environment to operate.  The sw is provided by intellitrack.  I also
have access 07 and users who use access 07 front ends to do various things I
have designed.  On the machines that have the IT SW ...

Hello,
This one is in need of some serious detail - PLEASE HELP.
Well, I am quite fluent in Excel, as after university, it is what I have
focused on.  However, I recently started working for a company as office

how to do this...
there are 2 number fields in my form, how to set up that "field B" number
must be greater or equal than "field A", ex: if "field B" is 11111, then
"Field A" must be 11111 or 11110, many thanks.

suddenly my access files start to show an error message when i use pictures
with the extension JPG, But before a while they view pictures trully i
reinstall The access but the same problem appears (access XP) so can any one
help me

Hey guys,
I have an access 2007 frontend interfacing with an access 2003 database.
Both the front-end and the backend are in 2003 format, but I split it
originally with 2007. Anywho, everything is fine with the data

I would like for my most current transaction on a table to be coded as 0 for
faster queries but not sure how to go by it.
Example
Transaction ID    Transaction Date    Tnumber