A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Running & Setting Up Queries Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
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...
September 16th, 2009 10:31 PM
by Duane Hookom Go to last post
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,...
September 16th, 2009 10:02 PM
by Marshall Barton Go to last post
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...
September 16th, 2009 09:59 PM
by Duane Hookom Go to last post
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...
September 16th, 2009 09:06 PM
by Stacey Crowhurst[_2_] Go to last post
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,...
September 16th, 2009 08:45 PM
by John Spencer Go to last post
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...
September 16th, 2009 08:08 PM
by Brad Hodges Go to last post
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...
(Multi-page thread 1 2)
September 16th, 2009 07:39 PM
by Banana[_2_] Go to last post
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 Go to last post
3 146
not working correctly in query, unable to separate data by SCC
I have two tables. The Contact table contains has a single record for each employee: first name, last name, phone, etc. The SemesterWorked table has...
September 16th, 2009 07:29 PM
by SCC Go to last post
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...
September 16th, 2009 07:03 PM
by Daryl S[_2_] Go to last post
8 170
Calculated age field not populating after 1/1/09 by G.
I have a form with 3 subforms. On the form I have a "Date of Birth" field that is manually populated and then I have an "Age" field that calculates the age....
September 16th, 2009 07:02 PM
by KenSheridan via AccessMonster.com Go to last post
2 168
c program for assignment problem by ANUTHRA
i need a c program to solve an assignment problem by implementing OR
September 16th, 2009 06:02 PM
by John W. Vinson Go to last post
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 Go to last post
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...
September 16th, 2009 05:16 PM
by Jerry Whittle Go to last post
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...
September 16th, 2009 05:11 PM
by John Spencer Go to last post
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 Go to last post
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...
September 16th, 2009 07:29 AM
by Piet Linden[_2_] Go to last post
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(!)...
September 16th, 2009 07:11 AM
by IgorM[_2_] Go to last post
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 Go to last post
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...
September 15th, 2009 10:43 PM
by Please Help Me Go to last post
3 153
Post New Thread


Display Options
Showing threads 3101 to 3120 of 43289
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:57 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.