Hello everyone...I'm new to this discussion group, so please be gentle.
I have a huge Access database that will likely have more than a million
records. This data is actually an extract from another database that I pull
from using Brio. This is transaction data (so lots of ...

Hi, I hope you can help.
I have table0 that holds information such as [procedure], [itemNumber],
[qty].  Another table, table1 that has [oldItemNumber], [newItemNumber].  I
need to change the [itemNumber] in table0, that matches with [oldItemNumber]

in using access 2003, i have successfully created a pivot chart. please
advise how this chart can be exported to a microsoft program like powerpoint.
thanks
max

Haha, of course the computer is only doing exactly what I tell it to do.  But
for some reason I can't tell it to do the right thing!  I mean, it looks fine
to me...
I've got a whole mess of tables & relationships, but only a few matter for

Here is what I am trying to do.  I would like to create a combo box in a form
that drops down with a list of states.  I have created a table that has both
state name and state abbreviation (Illinois in one column, IL in the second
column).  I would like to have the dropdown box ...

I am using the query:
TRANSFORM Count(NZ(Count([Itemized Records].Subject),0)) AS Calls
SELECT Format([Date],"yyyy-mm-dd") AS SortDate, [Itemized
Records].Subject

In a query I would like a field that would show the lower of two fields,
similar to the MINA function in Excel

I need to sort my query by group.
Table created from electronic feed. User filed is made up of Division (320)
/ Person / Group
examples:

i have a field GenericDrugId from tbl dbo_DPhaDrugData
if this value is null,
i want to select  field GenericName from tbl dbo_DPhaDrugData3
would i put an IIf statment in the criteria ?

HI i wonder if anyone could possible help me, im trying to create a query
that shows a list of addresses, for e. i have company name, address, zip,
country etc. but i only want it to show me those records where i have data in
the company name field if itss empty i dont wan to see ...

Sorry for bringing up an old topic but I've been searching the web for
a way to insert a blank line into a report after individual systems and
I found a very similar question posted awhile back and I believe the
answer posted will work for what I need to do. I have included the

The database we use at work (and hence I can't change basic table structure)
is driving me mad.  I have a list of patient appointments and want to create
a query that will create a field to allow me to text message everyone in the
family in one message (I have the texting bit ...

I have a database that I have 2 tables using a One-Many relationship.  I have
these in a form and subform, linked by the Primary Key.
What I need to be able to do is on the first of every month is to
automatically create a record for the 1st day of the previous month for each

How do I do a query to find out, How many times colum A (Reception Hall) has
been used in one month.  colum A (Reception hall ) is a YES/NO field.  Date
field is called (Event Date).
Example:

Greetings.  I have a query in which other queries are joined together.  These
other queries are pulling into the main query a comment field from a table
that are of different topics.  The table datatype is memo.  On the report the
long comments are cut off.  The report field is ...