I have a table containing a date/time field.  I have a summary query based
on this table which was set up using the wizard.  I stipulated to group by
month when asked. (i.e. All records in April 2005)
The query works fine.  However when I try and sort on the month field it

I was told that you shouldn't store information in a linking table (many to
many) except keys, Is this true?
tom

Acess 2000.
We have a database that has been used to enter patients, room, treatments
they are on etc...This is a flat database even though patients can have
multiple treatments.  Suffice it to say it works well for what it's used for

i have a combo box  that let you select 1 of 4 categories.  Now I would like
the fee to populate based on the selection.
Example
if cat=1 then me.fee=40

I haven't used Access in some time and am creating a simple PIM
I have Office XP (2002).  However when I create the new database it shows as
Acesss 2000 Format.  Is this correct?
Thanks much.

None of us can figure out how to actually print a page from the MS support
site.  Any page we go to cuts of 30% on the right side, even after selecting
"Print this page" option.
How does anyone actually print out this valuable information??

 i developed a database named TFGGQualityDB.Its working fine on my desktop
system. when i tried to open the same mdb file on Laptop i am getting error
like your database points missing or broken owc10.dll file. on both systems i
am using office professional 2003 edition.

I keep trying to add an email account, but I can not get access. I keep
getting error has occured on script page it say access denied, but I have
tried multiple accounts and my info is correct. any advice I have newer
version of internet explorer too.

We are looking to link an Access database to Great Plains, SQL based
accounting software.
To assist with testing of the link I have been creating tables to provide
discrete sub-sets of data for controlled import to G Plains.

I set compact on close in my program. It works normally when used for
stanalone, After that I put this program in server, When extit program it
create new file eveytime. why?. How can compact database on network

I am doing a self tutorial on Microsoft access and i was wondering what the
primary function of access is.. Can someone help me?

I have this code on my form since my Lender ID is not autonumber, I had
problems (before) updating my records..
Private Sub Form_Current()
    If Me.NewRecord Then

how to add items in the field to chosse from it for example i have field it's
name "name" and i want to inter louii or dani or dina to chosse one from them
thank you so much for your help
louis

In most Windows Applications with combobox-like dialogs, you can start
typing in the box and after a few letters use the keyboard up and down
arrows to select the specific entry you want from the list.  With my Access
(2003) combo boxes, I have to reach for the mouse and hit the ...

I have a user here in the office that is getting an error when he clicks on a
command button I set up to close the form and it points to the code I wrote
for the button.  I went in and pulled up the same form and it works fine.  I
even tried it in another user with the same ...