|
|
|
|
3 |
160 |
|
|
|
|
1 |
137 |
|
|
Query Question regarding IIf's by
Alberta Rose
In the query I'm trying to make, I have 7 fields. ContractNumber, CostCode,
CostType, EstimatedCost, ActualCost, EstimatedHours, ActualHours. I have...
|
|
5 |
232 |
|
|
|
|
8 |
154 |
|
|
Crystal Report SQL Conversion by
Terry
Does anyone know of instructions / utilities that would help me use a select
statement from a Crystal report in a MS Access Query?
We have several Crystal...
|
|
1 |
149 |
|
|
Record with longest entry by
QB
I know this may sound a little paculiar, but I need some help to write a
query that will list the record that has the longest entry (textual length -
Num...
|
|
1 |
151 |
|
|
Show a 0 if there is no record by
bassstuf via AccessMonster.com
I need to find a way to create a query that will show a "0" if there is no
matching record.
The details
I have 3 tables with part number & serial number with...
|
|
2 |
151 |
|
|
Query to select from list by
nbslarson
I have a table which contains one field "connector" which could contain one
name or more than one name.
Is there a way to build a query that will travel...
|
|
1 |
117 |
|
|
New field in a query by
Maracay
Hi Guys,
I have a query with a field call YNDATA(the one that is a check mark), what
I want is to create another field in the query that when YNDATA is true,...
|
|
3 |
144 |
|
|
Query two subforms from 3 combo boxes by
Raymond
I am having a problem quering two subforms from 3 combo boxesHi, Basically I
have a form that contains two sub forms and each sub form has its own
individual...
|
|
3 |
182 |
|
|
Access 2007 calculation help by
Ian Way
i have 2 fields in a table, 'qty on order' and 'qty rxd', In a query I
subtract 'qty rxd' from 'qty on order'
how can i store the result of this calculation,...
|
|
6 |
139 |
|
|
|
February 5th, 2010 12:06 PM
by cinnie
|
7 |
270 |
|
|
Nested Iif Formula Question by
Qaspec
I'm having problems with the following formula when I run a query:
Sco
IIf(=!!,5,IIf(=!!,10,IIf(=!!,20,0)))
I'm trying to rate the tickets count like...
|
|
3 |
125 |
|
|
Access 2007 - Set default sort by
Rita Brasher[_2_]
Just upgraded to Office 2007. Previous versions automatically sorted
queries by name. 2007 groups by query type, then sorts by name. Is
there any way to...
|
|
1 |
112 |
|
|
Compare (2) fields in (1) table by
ModernGIS
Grettings,
I am working on a database analysis and need some assistance on building
a specific query.
I have an input table that was formed at a...
|
|
4 |
145 |
|
|
quick question by
pat67
I have several saved exports in Access 2007. Is there a way to run the
exports at once without having to go into each one and click run?
|
February 4th, 2010 09:43 PM
by pat67
|
2 |
124 |
|
|
Criteria by
Liverlass3981
Hi,
I have an Access database and I'm creating a query in design view. I'd like
to bring up a list of all patients who take only aspirin - no other...
|
|
4 |
113 |
|
|
query syntax or design question ... by
dannie
PARAMETERS !! Text ( 255 );
SELECT InspectionsDI.ID,InspectionsDI.Area
FROM InspectionsDI
WHERE InspectionsDI.Area=Forms!!cmbArea;
This code works correctly...
|
|
3 |
151 |
|
|
Select Query by
margaret
So I have the following query ...
SELECT Code.CODE, year.yearend, .ACCOUNT, .MINOR, .minor1, .Supplemental, + AS lastytot, year.LYEAR,
year.Byear,...
|
|
3 |
137 |
|
|
How can i Secure my project by
naveen prasad[_2_]
Hi all, i have created a small project in access.
3 database tables. 8 forms, 6 queries.
in start up i put the main form to open.
and now i unchecked the...
|
|
4 |
175 |