I have a database that keeps track of credit applications.  I am trying to
setup a 2 forms to pull up existing apps and edit them.  The application
data
table is linked to an SQL Server 2000 table.  I have 2 forms, one tied to

I need to separate this data into two columns. What formula would I use to do
this in a query? I actually do not need the information to the right of the +
sign (including the +).
I could bring it into Excel and do a text to columns but since I am making

I am trying to create a query that groups data, but limits the query results
to the most recent record for each group.  I have tried using the Totals row
and then using Max and Last but I am not getting the correct results.  Thx.

According to Access 2003's help files, SQL Server partitioned views that are
updatable in SQL Server are supposed to be updatable in MS Access.
However...
I have two tables with Identity primary keys that are identical - except for

Hi - thanks in advance for help.
I have this query that will calcuate my positions on any day that
enter.
SELECT StockTransactions.DealCode, StockTransactions.Stock,

Please help.  I have an Orders table with Ord#, ReceivedDt, ShipDt and I need
a query that will summarize activity by date.  
Sample data:
Ord#    Recv      Ship

I have a query to return the 200 addresses shared by 226 people.  When I run
the query the first time, it returns duplicate addresses, so that there are
226 rows.  If I then sort on any field, the query resets to return 200 rows,
without modifying the SQL statement in any way, ...

I have a table of clients and all clients are duplicated (by company name &
postcode) once or more in the table. Each client record has a date created
field. Is there a way to extract from each group of duplicated clients the
one client that has the earliest data created?

I am new to creating Access queries.
I would like to change the Amount to -ve/+ve number if its a Credit/Dedit.
For example:
If DR_CR is C then Trans Amount should be formated as negative number.

hey everyone, I have a distribution table which lists company and name.  i
have a datasheet that shows all fields from this table.  the Company and Name
fields are setup as combo boxes, which contain all distinct entries from this
table.  what i want is, if someone selects a name ...

I make a crosstab on some country data:
           Total   val1  val2
Angola     7        4      3
Ghana     11       2      9

I'm trying to find a solution and I'm hoping that you can help. First
off, the formula is this:
Field A * 1.0925 = Field B
In a table there are about 14,500 numbers in Field A. I don't want to

Why , when accessing a table in the database , you can have greater than 127
fields for an insert and retreive but are limited to 127 fields for an update.

Hi. I use to use this criteria to make searches in my query. This allow me
put search records that has that criteria.
Search form "laptop" it will show:
"Asus Laptop" and "This is a HP Laptop"

How do I get a query to enter a zero value so I can calculate the difference.
I have a table with 200 items (Stock) and I want to deduct the items used
(TableUsedItems), some period of time no items are ure used but I want to
dispay all items but when I deduct from all itmes I do ...