|
|
Most recent revision query by
Delboy
Hi All
I have a table which stores drawing types and their revisions along with the date completed.
I want to do a query which will only show the most recent...
|
|
2 |
290 |
|
|
|
October 30th, 2008 12:58 PM
by Max
|
2 |
128 |
|
|
Convert text field to date field by
Dimitris
Hello,
In a table there is a text field, in which dates are entered. For example
the date December 3rd 1975 is entered: 03121975 (dd/mm/yyyy) What I need is...
|
|
1 |
63 |
|
|
Expression Error in a Parameter Query by
mivan002
All I am trying to do is add a parameter into the schedule_to field that
says: Between And
If in my query I delete the expressions that I have put in prior...
|
|
9 |
218 |
|
|
query runs very very slow by
cliff
My data in tballnumcount query is something like this.. this query runs fast
and there are about 11462 records
sr numvalue numcount latest
1 14 ...
|
October 30th, 2008 08:10 AM
by cliff
|
4 |
81 |
|
|
Removing dashes from a number by
CH
I'm trying to update a number field with numbers that have dashes in them.
For example: I'd like to change 620-46-3 to 620463. I know this can be done
with...
|
|
5 |
147 |
|
|
|
|
1 |
58 |
|
|
LIKE function match values by
dorionsmom
I'm trying to use a data field in the LIKE Function...
This is my data..first line is thefiled names ...each additional line is a
sample record..
Flight # ...
|
|
2 |
61 |
|
|
Same data - different criteria by
Jay974 via AccessMonster.com
Hi Guys,
I am trying to produce a query based on balances of accounts with my company.
The data in the table contains the following information: Week...
|
|
1 |
55 |
|
|
SQL Pivot in Access by
Amanda Kelly
I have a table in access that is laid out like the following:
Mo Year Sold Price Mdl_line Mdl_yr Orig_resl_amt Gap VIN
(unique)
aug 2007 ...
|
|
2 |
64 |
|
|
Is this type of Join Possible? by
nafflerbach
I have a need to match records from two separate tables and the like fields
are not identical. One table contains 6 unique digits of an account number
and...
|
|
3 |
64 |
|
|
Help with building basic select statement by
Logitech
Also posted in : microsoft.public.sqlserver.programming
Hi,
I'm not very experienced with creating queries and am having some difficulty
creating what I...
|
|
3 |
185 |
|
|
Less than 1 Year by
Compiling and Confused
I am writing an update query that calculates Years of Service (YOS) based off
of the start date. My current expression...
|
October 29th, 2008 05:59 PM
by DK412
|
3 |
51 |
|
|
|
|
3 |
91 |
|
|
help with Group By query by
Ted
Hi all, I could really use some help here. I'm trying to run a query to pull
the last commission used by all of our brokers. I know this isn't that...
|
October 29th, 2008 05:17 PM
by Ted
|
6 |
84 |
|
|
Update Function by
Sol
I know that to change the price in a query I have to use the Update function.
However, I don’t know the exact syntax for it.
Example: I need to change the...
|
|
8 |
145 |
|
|
decimal places in results by
klp via AccessMonster.com
I have a query that sums a field Quantity with criteria 0. When the results
are displayed on the screen shows correctly. However, if you go to the
quantity...
|
|
2 |
69 |
|
|
Report problem re. amt. column by
BCS
Hi - I've generated a 'report' and one column is an amount field. I notice
that some of the amounts have the $ sign and some do not. Is this an easy
fix? ...
|
October 29th, 2008 03:54 PM
by BCS
|
2 |
80 |
|
|
|
October 29th, 2008 03:29 PM
by emc
|
5 |
137 |
|
|
% sign in access by
Dodzie99
Does access accepts the "%" sign for missing values in a query?
|
|
2 |
72 |