|
|
Report from query by
mrrherrera
About four years ago, I created a query that pulled records based on the
items selected. Sex, race, hair color, eye color were all combo boxes and the
user...
|
|
1 |
158 |
|
|
Group by Time by
Qaspec
I have a table (tblRecords) with specific times (long time) for each record.
From a query I need to group the resulting records by hour military time
(0600,...
|
|
2 |
127 |
|
|
Query DLookup Syntax error by
NoLegalMoves via AccessMonster.com
I have the following column in a query that returns a syntax error.
Any idea why?
Hours: DLookUp("",""," =" &
)
--
Message posted via...
|
|
3 |
247 |
|
|
Breakdown my budget codes by type. by
Stacey Crowhurst[_2_]
Hi. I have a database with about 20 budget codes. They are set up in
sequence like so...
105-xxx Construction
110-xxx Design
115-xxx Entitlement
120-xxx...
|
|
2 |
113 |
|
|
Interesting query requirement by
h2fcell
I have an interesting query requirement that I’ve seem to gone blank on.
I’m querying a table with fields OrderNum, OrderStatus, AgencyName,...
|
|
1 |
113 |
|
|
...OK, I'M STUPID, PLEASE HELP! by
Brad Hodges
I have a class of students who on graduation receive a title modification.
I'm trying to create an update query to my main table concatenating "MR" to
the...
|
|
9 |
134 |
|
|
Returning more data than requested by
Sun Communications
I have a query for a field in my SQL database and use this statement =. It prompts for the code that I would like the report for example
"NT", but when it...
( 1 2)
|
|
15 |
227 |
|
|
age rounding up or down by
Abe
I'm using this formula from the office help to calculate a birthdate:
=DateDiff("yyyy", , Now())+ Int( Format(now(), "mmdd") Format(
, "mmdd") )
My fields...
|
September 16th, 2009 07:36 PM
by Abe
|
3 |
146 |
|
|
|
September 16th, 2009 07:29 PM
by SCC
|
3 |
174 |
|
|
Union query by
hoachen
I have two cosstab query and i want to combine them together as well as merge
them with the same pubname. The structure of these two tables are same. Bothe...
|
|
8 |
170 |
|
|
|
|
2 |
168 |
|
|
|
|
1 |
208 |
|
|
SQL Delete Stored Procedure by
Sara
simple question... need help with sending criteria to basic Delete Stored
Procedure.
want to enter a variable or form input in Criteria column in design...
|
September 16th, 2009 05:52 PM
by Sara
|
2 |
177 |
|
|
append queries by
NAS
NONE of the append queries in any of my databases will work! When I try to
run them the progress bar stays at 2 green blocks and thats it. I have let
one of...
|
|
6 |
113 |
|
|
FindDuplicatesBetweenTables by
gh[_2_]
I am using Access 2007 and have 2 tables with client information. I
need to compare the Client ID' s in table 1 to the client id' s in table
2 and if they...
|
|
1 |
116 |
|
|
search missing numbers by
Todd
How can I make a query to search for missing sequential numbers. Say I have
a field called assetid and the assetid numbers start with 00001 and go
through...
|
September 16th, 2009 02:04 PM
by Todd
|
4 |
167 |
|
|
Create query against multiple date fields by
fgwiii
Hello,
I need to create a query that will identify about 10 individual date fields
to see if the dates a greater than 30 days prior to or 1 day after the...
|
|
8 |
168 |
|
|
Replace function by
IgorM[_2_]
Hi
I have a query that retreives data from a cartain column and converts it to
currency type.
The query in Access 2007 looked like this:
Select CCur(!)...
|
|
4 |
163 |
|
|
Compare and check date by
hoachen
Order# InputDate StartDate EndDate
1 20090914 20090812 20090831
2 20090914 20090915 20100302
3 20090701 20090701 20091031
I am not sure how to run a query...
|
September 15th, 2009 10:50 PM
by MGFoster
|
3 |
135 |
|
|
Ucase first character of string by
Steve S
I have imported a table of names, addresses, etc that are all upper case. I
have converted everything to lowercase but now need to change the first
letter...
|
|
3 |
153 |