|
|
|
|
1 |
299 |
|
|
CalcWorkDays error by
Sue Compelling
Hi (Access2007)
I'm trying to get Klaatu's CalcWorkDays function to work though something's
not quite right in the results. Would appreciate any help that...
|
|
2 |
301 |
|
|
Query for a report by
lettyg82
Good Morning. I am trying to figure out how to calculate the number of days
between two dates. I have a table callled events. That table has event
date,...
|
February 28th, 2010 04:44 PM
by Cesar
|
1 |
183 |
|
|
Setting Fieldname in query with a combobox by
Mafukufuku
I want to set the fieldname for columns in a query by having the user select
from a combobox.
- What is the right expression to be put in the fieldname in...
|
|
6 |
181 |
|
|
Multiple IIf by
quinto via AccessMonster.com
Needs some help
If code =1,Action Date,+365, if code =2,Action Date, +730, If code=3,Action
Date+30
Can someone help with this and how many If can I use?
If...
|
|
2 |
172 |
|
|
|
|
2 |
180 |
|
|
|
|
1 |
212 |
|
|
Multiple Values in a Query Criteria by
Deo
Hello,
I have a combo box on a form that allows a user to select a location code
that is used by a query. I want to run the query for two location - 73 and...
|
|
1 |
202 |
|
|
Erratic results from query criteria by
Owl
I am getting different results from running the same query with the same
selections. One moment it is all behaving as expected, the next it has gone...
|
|
3 |
196 |
|
|
Trim Time off Date by
GMC -LSND
Access 2007 linked to SQL 2008 database
I have a query with a date field that has the time included on it. How do I
trim, truncate, remove the time part of...
|
|
4 |
182 |
|
|
Remove redundant text by
Rich Sullivan
How would I remove in a query the last or right most characters or a constant
value like:
New York, NY
Rochester, NY
Buffalo, NY
And I want to remove ",...
|
|
6 |
206 |
|
|
|
February 26th, 2010 09:26 PM
by AccessIM
|
2 |
195 |
|
|
Query Trouble by
Eoin McGlynn[_2_]
Hellow,
I'm using the filter below to filter a query. However when "All Grades" is
selected it will not display the "is not null" filtered query. It is...
|
|
4 |
201 |
|
|
|
|
2 |
230 |
|
|
Creating duplicate rows by
kevin
I need to set up a query that will look at a table and for each row that has
a field with a quantity 1 (eg. 10), will create a row for each quantity
instead...
|
|
3 |
173 |
|
|
|
February 26th, 2010 07:23 PM
by Kou Vang
|
0 |
192 |
|
|
Grand Total Time by
auujxa2 via AccessMonster.com
I've exhausted my research ability on this one. Please help!
I have StartTime1, EndTime1, TotalTime1. (through 7 for a full week)
The start and end times...
|
|
6 |
302 |
|
|
Crosstab Query For Fiscal Year Totals by
DevlinM
I want to write a crosstab query for FY totals that will show each month
regardless of wether there is data or not. Any help on this is greatly...
|
|
1 |
446 |
|
|
access query question using not " " by
access query question using not[_2_]
need to say not with about eight items
can get it to work with one item but not more than one
how do i do this?
|
February 26th, 2010 05:51 PM
by Kathy R.
|
2 |
312 |
|
|
View Most Current by
DevlinM
I have a table Personnel and a Table EmploymentStatus.
I want to write a query that will show all Personnel with most current
Employment Status Only. Any...
|
|
2 |
201 |