|
|
|
March 19th, 2008 01:26 AM
by klf
|
3 |
111 |
|
|
|
|
0 |
135 |
|
|
Transpose Rows to Columns in Access Query by
Compiling and Confused
Hello,
I am trying to transpose multiple columns into a specified column as shown
below.
What it looks like:
1(Q1_A_1) 1(Q1_1-2) 1(Q1_A_3) 1(Q1_B_1) ...
|
|
7 |
105 |
|
|
Date Range by
citloner
I have created a query based on one table to search for dates in a certain
range, for example May, by searching the date field with the criteria Between
And...
|
|
3 |
83 |
|
|
Find Duplicates Query by
Matt
I have a years worth of data where I'm trying to find records with duplicate
values in the "IndividualName" field. I am using the find duplicates query
in...
|
|
2 |
92 |
|
|
Query that retuns nothing - HELP :-) by
Bob
I am having a very difficult time with a query.. It work before and I have
taken out any changes that I made and now it does not work. HELP please
This is...
|
|
1 |
96 |
|
|
|
|
2 |
69 |
|
|
acess employee database by
Help My job depends on it
Name employer 1 employer 2 employer 3 employer 4 emloyer 5
I have a sheet in access with these headings ...
1 Can I construct a...
|
|
2 |
84 |
|
|
Convert Date YYYYMMDD by
mattc66 via AccessMonster.com
Hi All,
I need to convert using a query the date format from MM/DD/YYYY to YYYYMMDD.
How do I do this?
Thanks
Matt
--
|
March 18th, 2008 10:37 PM
by fredg
|
2 |
108 |
|
|
View that returns a range of numbers by
mar[_2_]
I'd like to create a view that returns numbers 1 through 364. Ex:
NUMBER
1
2
3
.....
The only way that I know how to do this is by using UNION:
(SELECT 1 AS...
|
|
4 |
89 |
|
|
|
|
7 |
108 |
|
|
update query by
Karen
I am trying to update a field but get an error message that some of the
records were not updated due to key violations. However, some records are
updated....
|
|
1 |
72 |
|
|
i think my brain stopped working by
DanG
I have a database that tracks estimator usage by dispatcher. It also tracks
the date the info was entered.
I want to have a report that shows % of each...
|
March 18th, 2008 07:48 PM
by DanG
|
1 |
88 |
|
|
Invalid Object Name - ODBC SQL by
Jani
I've searched and searched and can not find out how what's wrong with this
query or table. Perhaps this should be posted to a SQL forum but I'm not
sure....
|
March 18th, 2008 05:14 PM
by Jani
|
0 |
85 |
|
|
Finding all queries which use a table by
ChuckW
Hi,
Does anyone know of a tool that can scan all queries in a database and find
if a certain table is used? I have a table called tblCustomerRollup which is...
|
March 18th, 2008 05:07 PM
by Glint
|
7 |
85 |
|
|
Group By, Max and Min by
Aino
I am struggling with a query, and need help
I have (from a previous saved query) these fields:
Field1, Field2, Field3, Time, Info
What I want to return is...
|
March 18th, 2008 04:35 PM
by Aino
|
2 |
80 |
|
|
Stuck- Urgent by
[email protected]
I need help - I have a crosstab query showing activity by territory,
with totals and averages that looks like this:
Terr1 Terr2 Terr3 ...
|
|
1 |
81 |
|
|
New Database design by
KarenK
I am trying to create a new database using existing information. I currently
have a table called "TBL_Members". This has SS#, name, address one, address
two,...
|
|
3 |
96 |
|
|
Using counts in queries by
Wiley
Hi,
I have the following scenario for which I cannot get the count to work
right. I know just enough Access to be dangerous, and have inherited this...
|
March 18th, 2008 04:07 PM
by Wiley
|
2 |
80 |
|
|
Creating a new field based on conditions by
ksto
I have a database that tracks insurance information for our various vendors.
Each insurance type has 2 fields - a requirement field (yes/no), and an...
|
March 18th, 2008 02:25 PM
by ksto
|
4 |
84 |