Hi, I have a table with non-unique identifiers.  I need to take all
the values with the same ID's and combine them into one field with a
semicolon as a seperator.  These values may exceed 255 characters.  I
then need to count the values in the cell and see if it adds up to 240

I would like to share (vent?) some of my frustrations with regard to
Access07. I do like Access and think it is a great program but think
there is much more potential in the program that I can not enjoy
because of general policy of the Access team and the direction they

i have a report with LeaseName and Total with Grand total in the Report
Footer. I need an Average of the Grand Total also. How would I do this? it
would have to be something like Grand total/number of LeaseNames......?
Thanks

Hello and Thanks in advance for any help.
I have been tasked with rewriting a christmas assistance database
using Access 2003.  The old system used pre-assigned case numbers to
identify applicants applying for assistance (with a specific date and

I have a A2003 Application.In one of the module I export a text file
using the Transfer Text method.I have a saved specification and
actually export a query.
While exporting few fields are automatically rounded off to a single

Hi.  I have an MDB that I have been working on using Access 2003.  The
db utilizes A2000 format.  There are enough forms to require that when
'Forms' is selected from the list of Objects (in the Database Window)
the scroll bar is displayed at the bottom.  

I have an XP database where my users are locked out of the database
window.  One of my processes creates/drops tables on the fly.  My
problem is trying to assign one of the new tables to a report.  When
the report is called, it says that the table doesn't exist.  How can I

I have created a query which returns a single record.  I then display the
four fields returned by the record on my form.  I would like to display the
same record three times with only the record number changing.  Can this be
done with Access 2000?  I'm thinking that I would need ...

I know this isn't exactly the forum for this, but there are no Wise forums,
at least that I could find.
I have a 65MB install for an Access 2007 program. The install is using Wise
Installation System v9 and the Sagekey scripts. What is very strange is when

I would like to know if there is a quick query someone can help me
write for the following scenario. I think I can do this with VBA but
since this is suppose to be a temp. solution, I really do not want to
spend too much time on it.

I'm using access 2002. I have a switch board set up. How can I put a
button on it to open a different database from the one that I am
using. Is there some macro I can run. Thanks

I have a database that someone altered a query and for the last several months it has duplicated entries each time the update process was run.  I
need to delete the duplicates but in the last month update added an addition 3 million lines of data and really don't want to manually ...

I have the following example code. I'm using CDO as I need to specify the
sender.
Set objMessage = CreateObject("CDO.Message")
objMessage.Subject = "Example CDO Message"

I'm using access 2002. I have a switch board set up. How can I put a
button on it to open a different database from the one that I am
using. Is there some macro I can run.
Thanks

Excellent resource has been found on SQL Server exam 070-229.
http://technical-talk.com/mc/mcsd/mcsdqa01.asp