|
|
|
|
| Numerical query criteria and quotation marks |
| I have a query that uses a criteria of >"269.9". I realized it was not
working because the format of the field being queried was text. I
successfully altered the format of the source field to doubl... on 20-Nov-09 |
| |
|
| Identify missing numbers |
| I have a table that uses a text field to store receipt numbers. Currently I
use VAL to sort the numbers numerically. Is there a way to identify which
numbers are missing out of the sequence? For i... on 20-Nov-09 |
| |
|
| Access Query |
| I have a table with approx 270K records. One colum contains an ID codes i.e. WATUA1, WAXUB0 etc.
I need to change the last to letters to AA, i.e. WATUAA, WAXUAA etc.
How would you write an upd... on 20-Nov-09 |
| |
|
| Combining Tables |
| Hello,
I have 5 files in excel. These files will have the same fields, but the
information will change in them every week. I am then going to import the
the excel files into access into my five ta... on 20-Nov-09 |
| |
|
| Convert datatype using query |
| I have create a query which combines two tables; ASSETS and UNITINFO. The
UNITINFO table is linked from another database and the ASSETS table has a
field that looks up a field called UNIT # from the... on 20-Nov-09 |
| |
|
| Sorting in Queries |
| Hi,
I am trying to write a query that assigns contributions for each account
considered to either East or West depending on which territory has the larger
contribution.
I am wrote a queryStep1:
SE... on 20-Nov-09 |
| |
|
|
|