|
|
Isolating text in a field by
scubadiver
Hi folks!
The following text is an example:
"F002 Internal Audit Summary Report Form Rev B.doc"
How do I isolate "Rev B" considering that everything that...
|
|
1 |
161 |
|
|
|
February 27th, 2007 03:43 PM
by skigal
|
1 |
128 |
|
|
Subqueries by
cprav
I initially posted this question in the Reports forum as my subquery is
creating a filtered report. However, I just can't seem to get this subquery
down,...
|
February 27th, 2007 03:08 PM
by cprav
|
8 |
193 |
|
|
|
February 27th, 2007 02:43 PM
by hardik
|
9 |
142 |
|
|
Rolling query by
THE BIG O
I would like to create a Find Duplicate query that collects information from
a table using a rolling year. Essentially we are going to import shipments
into...
|
|
3 |
141 |
|
|
HELP! Error Message by
Novice2000
Hi,
I am trying to run a form base on a query and I am getting this message:
Reserved error (-1517); there is no message for this error.
It was working...
|
|
2 |
147 |
|
|
|
|
4 |
146 |
|
|
MDA to MDW conversion by
Albert
Could anyone tell me please if there is a utility out there which can
perform a satisfactory conversion from the .MDA format of Access V2 to the
..MDW format...
|
February 27th, 2007 08:58 AM
by Albert
|
0 |
159 |
|
|
Distinct data by
The Rook
Sorry if this is simple but I am very new to SQL. I currently have a link
into our MRP database and am wanting to set up a query to show how many
technical...
|
February 27th, 2007 08:31 AM
by The Rook
|
2 |
140 |
|
|
|
|
1 |
158 |
|
|
update query by
mccoy
anyone who can give me a sample database using update query
i want to update all records using calculated field from another table a sum
of TableA.fieldA to...
|
|
3 |
128 |
|
|
WHERE help needed by
Sophie
I have SQL that works fine, but I have a question about the WHERE conditions
SELECT ......
FROM ........
WHERE (((K.HardwareClass)=!.)
AND...
|
|
1 |
129 |
|
|
|
|
9 |
183 |
|
|
Query won't open in design view by
BBran
Hello,
I am using Access 2007 B2T2. I am trying to open a query in design view but get an error. The same query opens fine in design view in Access...
( 1 2)
|
|
17 |
277 |
|
|
Parameter query not working correct. by
Jim Moberg
Hi,
I have a query that joins table A to Table B via the loan number. Table A
contains a record for each loan and an associated load ID that it was...
|
|
1 |
203 |
|
|
|
|
3 |
141 |
|
|
newbie SQL question by
Victoria
i'm working at learning how to design queries using SQL. Based on what I've
seen in this group, the SQL is much easier to follow and understand when...
|
February 26th, 2007 11:49 PM
by Victoria
|
2 |
175 |
|
|
Change date to set month by
John
Hi,
I have a TestDue date which I want to change in some cases to a fixed month
PRIOR to the TestDue Date. One table contains a field holding the value of...
|
February 26th, 2007 10:40 PM
by John
|
2 |
159 |
|
|
Running query from a Command button by
tom sparks
i have a command buttons on a form which have been given the instructions
with an on click event to run a macro to open another form that has been
created...
|
|
1 |
160 |
|
|
Combo Box query for current record by
Mariano
I am sure this is a common issue, but I couldn't find it in my searches....
I have a form bound to a table called entry. The field 'speed' is a combo
list...
|
February 26th, 2007 09:46 PM
by Mariano
|
2 |
102 |