|
|
Calculation in a query by
Robert
I have a table that contains job assignments. I want to, for a given date
range, calculate the percentage of job completion. So I want to take the
number...
|
|
2 |
120 |
|
|
Changing query criteria to supply a form by
Rob M[_3_]
Hi all,
I have what's certainly a newbie question.
I have a query that supplies data to a form. Is there a way to filter
the data shown on the form...
|
|
3 |
124 |
|
|
|
|
1 |
149 |
|
|
search criteria in query by
Todd
I've got an access dbase that has a link to an sql dbase table. I didn't
create the sql table and I'm just linked to it so I can run a couple custom
reports...
|
|
7 |
160 |
|
|
Pie Chart by
Etaylor83
I want to create a pie chart from an Access table.
I have a number of queries which are allocated to certain people under a
field called "Allocated to" and...
|
|
1 |
146 |
|
|
Use of Max is quite working by
Ben[_14_]
Hi all,
I have Access 2003 on WinXP. I have a table with:
PartID
TransactionID (runs in incremental order by 1)
DateOfSales
TotalCost
NumOfUnit
UnitPrice...
|
|
4 |
146 |
|
|
IIF statement with DCount crashes A2007 by
Brad P
Hoping someone can help me.
I have Access 2007 and a query with a field using this expression:
IIf(DCount("*","Deductions")30,5,10)
Access crashes every...
|
|
2 |
149 |
|
|
combobox in query by
MAANI
My DB has 8 fields (wo #/Date Inspected/Inspection Type/Group/
Group Items/Fault/Fault Description/Comments) fields 3,4,5,6 are
comboboxes,field 4 and 5 are...
|
|
2 |
125 |
|
|
Query Weekly Data by
Scott
I have a date field called "transactiondate". How do I query all the data
for the previous two full weeks? How do I query the data for the previous 52
full...
|
|
2 |
122 |
|
|
Custom Counter by
AccessIM
I have a table that tracks employee attendance records. In the table, I am
calculating an accumulative total column for points. This took me quite some...
|
|
6 |
173 |
|
|
Determine position in query recordset by
Gert[_3_]
Hi,
I am creating a function that I want to use in a query.
I need to test in the function whether the recordset is BOF.
How do I refer to the recordset from...
|
|
1 |
110 |
|
|
changing parameters on a stored procedure by
bp17
I have a stored procedure that does not return records but needs two
parameters to run
@ SAP_code & @Source
@SAP_code = interger @source = varchar
I can...
|
|
5 |
141 |
|
|
#Error in query by
rookie
I created an IIf statement in my query and it somewhat works. When I ran it,
the "False" showed up as "False". However, the "True" showed up as "#Error".
Why...
|
|
5 |
158 |
|
|
|
|
8 |
293 |
|
|
|
November 5th, 2009 12:39 AM
by text
|
3 |
138 |
|
|
Count of Groups by
angellijah
I have a database that lists clients, the case # related to that client, etc.
multiple clients may have the same case #. I want to count the number of...
|
|
5 |
134 |
|
|
IIf statement in query criteria by
Access WannaBe[_2_]
I have a query that returns sales history for a range of inventory items. I
have a form that allows me to enter a range of items, and a date range as
well. ...
|
|
3 |
160 |
|
|
IIF statement and multiple items by
rookie
I have 3 fields (see below) and each of them contains True or False. I was
trying to write a query that combined all of them and output only 1 of the 3...
|
|
4 |
139 |
|
|
Query to return only one value. by
Gwenk
Hi, I need help please
Trying to do a select query where I only want one row returned if a field
has two values
Example: Joe Bloggs can have two records...
|
November 4th, 2009 08:31 PM
by Silva
|
5 |
141 |
|
|
|
|
1 |
137 |