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
How do this tricky query? by Dorian
I have 2 tables, a CASE table and an INVESTIGATOR table. This is a one-to many relationship. Each Investigator has an Assign Date and a Completion Date. There...
December 14th, 2009 11:28 PM
by Dorian Go to last post
4 299
syntax error in JOIN operation by javablood
Hi, I am not even sure if this can be done. I am trying to reference a table in a query. The table is defined in a form. Here is the query I am working...
December 14th, 2009 03:28 PM
by javablood Go to last post
4 225
Pass-Through Query Error by jutlaux
I am trying to setup a pass-through query with the below SQL SELECT FIN_CUR_CURE_CYCLE_SIDE_DATA.MOLD_REV_NUM FROM FIN_CUR_CURE_CYCLE_SIDE_DATA; When I run...
December 14th, 2009 02:25 PM
by Bob Barrows Go to last post
1 186
Printing Porblem by Leo
I have a master form that includes a sub form. After designing this I stored it as report. I have a print command (Command29) in the master form with onclick...
December 14th, 2009 12:35 AM
by Leo Go to last post
0 164
Total number of days by Leo
I have a query that has fields called training days1 through 12. They are all date fields. The user will enter various dates that will not be contiguous...
December 13th, 2009 07:56 PM
by Duane Hookom Go to last post
1 153
Problem With CDec Function by John Lane
I have a query with one column containing "Expr1: CDec()". When I try to run or store the query, I get a message saying the function has the wrong number of...
December 13th, 2009 01:25 AM
by Jerry Whittle Go to last post
1 213
Difficultyentereing/editing fields on the Query Grid by Phil Smith
This has been ticking me off for about two weeks now. If I have a formula in the Query grid, and I go to edit it, whether directly in the query grid or by...
December 12th, 2009 10:22 PM
by Tony Toews [MVP] Go to last post
4 233
queries written inside MS-Access are getting deleted by Harish
Some of the queries I have written inside MS-Access are getting deleted automatically. And while I run the queries through code, I get this error 'Query...
December 12th, 2009 10:21 PM
by Tony Toews [MVP] Go to last post
8 527
Update joined tables with info that is currently in Excel? by BobC[_6_]
I have about 9000 records in an Excel spreadsheet. Each Record contains 8 fields. 3 of the fields will uniquely reference the specific Location,Site and Item...
December 12th, 2009 04:26 AM
by BobC[_6_] Go to last post
5 202
Combo Box Not in List function by Leo
I have a combo box called RECC. It does not look up any table for the values. I typed in the values (string statements). How do I add to the list if the...
December 12th, 2009 03:58 AM
by Leo Go to last post
1 146
Use of Wildcard in String Expression by NEWER USER
I am trying to get the wildcard syntax "*" correct on the query grid in the following and have struggled. Any help appreciated. InStr(,) Criteria is...
December 11th, 2009 11:33 PM
by NEWER USER Go to last post
4 186
Formatting Concatenated Fields by hobbit2612 via AccessMonster.com
Hi I wonder whether someone may be able to help please. I'm using Duane Hookom Concatenate coding which is superb but I would like to go a little further with...
December 11th, 2009 10:20 PM
by hobbit2612 via AccessMonster.com Go to last post
2 195
Query to add 2 different record values by Bob H[_4_]
I am trying to build a query which will add together 2 values from 2 different record going along rather than going down. Something like this in Excel: Add...
(Multi-page thread 1 2)
December 11th, 2009 09:02 PM
by Bob H[_4_] Go to last post
12 284
Help with a Monthly Summary Report by Dennis
Hi, Since this question involves both a query summary and a report, I tried to cross post to microsoft.public.access.queries. I am working of a volunteer...
December 11th, 2009 04:49 PM
by Duane Hookom Go to last post
3 186
Access pass-through query to Oracle 10g stored procedure - results by Blue and Silver
I am able to create an Access 2003 pass-through query to Oracle 10g that uses a SELECT statement; it returns a resultset. But, I cannot get a resultset when...
December 11th, 2009 04:18 PM
by Jerry Whittle Go to last post
1 174
Need a query to get rid of duplicates using two tables by Susan
I have 2 tables - one -A - has 100 records - the other - B - has 150 records - they have a common field NAME - table B has the same 100 records as table...
December 11th, 2009 03:01 PM
by John Spencer Go to last post
1 150
last entry per record query.. by Sklyn
Hi and thanks for your time. My database is tracking the service histroy of vehicles. The main table has VIN as the PK which links to another table containing...
December 11th, 2009 10:47 AM
by Allen Browne Go to last post
3 280
IIf Statement in Query Criteria by AccessIM
I have the following code in a query: SELECT qryPointsWithDropOffDates.EMPLOYEEID, qryPointsWithDropOffDates.SSN, qryPointsWithDropOffDates.NAME,...
December 11th, 2009 06:48 AM
by Duane Hookom Go to last post
1 173
Assigning text response to a value by cowichandave
In quering a sales database, if the sales amount is positive how do I get the query to add "Sale" in another field or if the sales is negative have it add...
December 11th, 2009 05:55 AM
by cowichandave Go to last post
3 213
Problem with Dates in Query by TotallyConfused
I have a field with dates. However, I need to separate only the year in another column. This is what I have so far but it is not working. Year: IIF( =...
December 11th, 2009 02:01 AM
by Marshall Barton Go to last post
1 130
Post New Thread


Display Options
Showing threads 1941 to 1960 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:31 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.