|
|
Eliminate 1st 3 digits in query by
cjborntorun
In my query, I have a product code formatted as text, such as
"00013800055000". I want to eliminate the first 3 digits. Any suggestions
on a "MID" type...
|
|
2 |
75 |
|
|
Pass through query by
manolakshman
I have two queries A,B. Query B is a subset of Query A. Now I need a syntax
to get Query A- Query B i.e., Query A without data of Query B
Can anyone help me...
|
|
5 |
91 |
|
|
Why are values not seen as being the same? by
Kelvin[_2_]
I have a query with two tables.
They are linked through an ID field.
My query is looking for dollar amounts that don't match between the tables.
Odd think is,...
|
|
6 |
165 |
|
|
Query Command by
Anthony
How do I put in for a query to give me everything that starts with 'sut'
Thanks, Anthony
|
August 29th, 2008 05:25 PM
by Dennis
|
1 |
91 |
|
|
Sorting Top Three Values by
LV
I have a query that lists out data in numerical order...
I have a column called "Batch" and it contains over 4000 values (1-4000).
What criteria can I enter...
|
|
2 |
74 |
|
|
Totals Query Help by
JudyB
I have a query with the following fields:
EmployeeID
DepartmentName
WeeksService: (CalcWeeks(,))
I am trying to sum the total weeks that an employee has...
|
August 29th, 2008 04:33 PM
by Maarkr
|
2 |
75 |
|
|
Percentage of complete by
Toni
I need the formula to use for finding the percentage of work completed. I
need to divide (/)*100 in this
calculation I get the percentage answer of 41000.00%...
|
|
2 |
69 |
|
|
Error Message by
Jim
I have been working on a query, and everything works fine. I changed one of
the search parameters to include additional information, and now I get an
error...
|
|
1 |
119 |
|
|
Multiple Median Calculation by
MPgov
Hello,
I am a novice to Access. I have been reviewing some of the Q&A threads and I
am not sure if they apply to my question. I am trying to calculate the...
|
|
4 |
123 |
|
|
Date order in a crosstab query by
July 07
Hello all,
I am trying to create a crosstab query to look like the following:
Order# Total Hours Jan 07 Feb 07 Mar 07
1234 175 ...
|
|
2 |
84 |
|
|
Replacing Tables in a Query by
Access User
I analyze general New York state information and to do so I have a table for
that state. I also have thousands of queries dedicated to that state. Now I
want...
|
|
3 |
108 |
|
|
|
August 29th, 2008 09:04 AM
by gymphil
|
4 |
111 |
|
|
Can't access design view by
Don
I am using Access 2007 and I have a problem that I've never experienced any
any database I've ever constructed.
I have an existing database that I updated...
( 1 2)
|
August 29th, 2008 03:50 AM
by alanwf
|
10 |
155 |
|
|
Subquery Help by
Nick
Hello - I have a table that I want to write a subquery to return a value
froma previous record. I have the following data
ID ENDWRKTYPE ENDSTATCD ...
|
|
7 |
111 |
|
|
Query Impossible? by
Claudette Hennessy
I have hit a wall with this..The relevant table data is:
Dealer Year
Dealer1 2008
Dealer2
Dealer3 ...
|
|
6 |
80 |
|
|
|
August 28th, 2008 09:51 PM
by Ian
|
5 |
101 |
|
|
|
|
13 |
157 |
|
|
Setting program access and defaults by
fish0143
Windows XP Home Edition.
When I try to set the program access and defaults to "Microsoft Windows" it
refuses to do so and puts me back into "Custom".
I am...
|
|
1 |
73 |
|
|
duplicate query wizard by
subs
i am having real trouble with duplicate query wizards- as soon as i
run the query, the entire database gets closed and then opens up as a
back up. I tried...
|
|
3 |
95 |
|
|
Incorrect sort results within query by
KathyW
Is there a limit of the number of sort items one can have within a query. We
are using MS Access 2002. I am using the following query but getting...
( 1 2)
|
|
13 |
129 |