The information on my form is based on query results. I would like some of
the info to be based on calculations from a table instead. It would be the
same table every time no matter what the query results are, but the
calculation results would be different. How would I get ...

I have a report and there are entries that are identical and I want to
group them together so that every record that has identical information
in each column will be grouped together.  I've tried the sorting and
grouping option and nothing seems to be working.  Any help is

I've got a table with 9,000 records in 10 fields.  I need to convert all the
text to upper case.  I've read I that I need to run an update query. It's
easy to start an update query in design view. But what do I type in the
Update To column? And I don't know what to put in the ...

I am trying to build a client database, which has the info of new potential
clients (ie contact info, emails, etc)
I need to track when we send a letter of intro, send samples, etc
What is the best most efficient way to accomplish this?

As instructed by the book by Feddema and online, I went to Tools > Startup,
and under Display Form/Page I chose Switchboard.  It does open automatically,
but you don't see it until you uncover it; the top window is still another
form on startup.  I don't want users to have to ...

I have a database that tracks trade shows. I've set up 2 tables, one is
tblVenues, one is tblEventYear. Right now I have the two tables linked by the
field EventYear. EventYear is the primary key in tblEventYear and the foreign
key in tblVenues. I have a one to many relationship ...

<Database name> database contains a missing broken reference to the file
'MSado26tlb version 2.6"
I assume this is really msado26.tlb (note the dot).  The error message was
sent to me by the user.

I need to create a report for flight hours. I need the report to show detail
records for the week with totals in the footer. I have already created this
where you input the date parameters. It work fine. Here is where the problem
is. I also need another line with totals for the ...

I have posted this question before I would like to be clear so that I can
avoid getting rude posts as answers.
I have a form that I created from TBL_Vehicle_Incident_Report. Within this
table I have made a combo box for the Vehicle Unit No so instead of typing in

The above error message occurs when I try to build a query. The strange part
is that I have built several queries using the same two tables in the past
without this error occurring.
My database is used on a LAN with the tables residing on the server.When

I have two database files; exact same fields, etc. just with different data
that I need to merge together to form one database.  One is a small file on
disk that was worked on at home and the other is the main file which is
worked on at the office.  We need to update the work ...

I have a form that users can filter as they like.
How can I let the user make a table of his data when he has finished
filtering?
The application is on a LAN and is used by several people.

I have a data entry form for my database and want it to open up at a new
record each time I open it. I'm sure I had an example of this filed away on
my PC somewhere but I can't find it! Can someone remind me please?
Regards,

I would like to update the current table with a number contained in another
table, then add 1 to
The source table number so that the number will be unique for the next
record added.

PERCENT:
IIf(Now()<DateAdd("yyyy",+1,[HPDATE]),"4%",IIf(Now()<DateAdd("yyyy",+2,[HpDate]),"5%",Null))
2PERCENT:IIF(NOW()<DATEADD("YYYY"+7,
[HPDATE]),"7%",IIF(NOW()<DATEADD("YYYY",+15, [HPDATE]),"9%",NULL))