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 Reverse Sort Order / Thread Starter Last Post Replies Views
"#Deleted" Error by nagesh
Hi guys, when i am able to inserting the master data in master table and detail data in detail table. after selecting the data from detail table it is giving...
October 1st, 2005 07:41 PM
by RuralGuy Go to last post
1 553
"...ADD COLUMN...DEFAULT YES" leaves existing rows as FALSE? by Santiago
Hi all, I'm adding a new column via this statement: ALTER TABLE myTable ADD COLUMN myColumn YESNO DEFAULT YES And it works great except that existing rows...
July 3rd, 2005 07:30 AM
by Santiago Go to last post
2 673
"...ADD COLUMN...DEFAULT YES" leaves existing rows as FALSE? by Santiago
Hi all, I'm adding a new column via this statement: ALTER TABLE myTable ADD COLUMN myColumn YESNO DEFAULT YES And it works great except that existing rows...
July 2nd, 2005 11:59 PM
by Santiago Go to last post
0 589
"000" Not working by Gina Whipp
Hi Guys, I am not getting why I can't 3 0's to display. I get an error message "Expecting End of Statement" while to trying to compile this code AND if...
June 10th, 2005 06:33 PM
by Gina Whipp Go to last post
4 585
"any part of field" query by Roger in Diego
Novice needs help. I am wondering if you can design a query that will 'hit' on a partial field match like the "Find" feature does. Thanks
October 4th, 2004 01:44 AM
by John Vinson Go to last post
4 803
"Best Fit" table windows? by Mark
Using ACC2000. The more I think about this, the more I think it can't be done, but I'll ask anyway. I have a bunch of queries that need to be updated, which...
September 27th, 2005 11:34 PM
by [MVP] S.Clark Go to last post
1 523
"Between" operation on dates by Nick in Tokyo
I'm trying to return all the records between two dates that are entered in text boxes. here's what I have in there.... Between !! And !! The form exists and...
August 18th, 2004 03:00 PM
by Joan Wild Go to last post
7 671
"Corrupted" query by Jeff J
Using Access from Office XP I have written a query as part of a Query by Form operation. I have an unbound form with 7 text boxes and the query has 7 "columns"...
August 12th, 2004 07:51 PM
by Jeff J Go to last post
8 1,207
"Could not delete from specified table" by Tina
Can anyone help me. Im' trying to deleting records in a table called "linkbase" where the "NUMBERS" field matches the "Numbers" field in another table called...
October 1st, 2004 12:10 AM
by Ken Snell [MVP] Go to last post
9 753
"Data Type Mismatch In Criteria Expression" Error by LB
Please see query statement below: String$(1,40) & Left$(!,3) & String$(1,41) & Space$(1) & Mid(!,4,3) & String$(1,45) & Right(!,4)
November 9th, 2004 04:02 PM
by JL Go to last post
1 892
"Delete" issue by PattyD
Performing a Delete query, I link 2 tables that have the same unique information; example record 123 and record 123. I want to delete matching data from ONE...
November 10th, 2004 07:54 PM
by JL Go to last post
1 570
"dynamic" column lookup by xopher
I need to use the value in one field to determine which column in another table needs to be used to retrieve the corresponding value. In detail, I have a...
April 8th, 2005 12:30 AM
by John Vinson Go to last post
3 563
"Effective Date" Criteria for Rates by Jason V
I have been stuck on this for some time now. I will try to make it as clear as I can. I need to create a Report of “transactions” (days worked of...
(Multi-page thread 1 2)
October 25th, 2005 11:00 PM
by Jason V Go to last post
13 1,179
"Find Matched" Wizard by Amanda Payton
Hello! I have been finding recently that as I go to build queries, and the query wizard pops up, that none of the options REALLY match what I want to do. ...
October 16th, 2004 10:17 AM
by Brian Go to last post
2 603
"Find Unmatched Query" help for Football pool by Lucky Louie
Quick background...2 tables. 1 with all user information including Week1, week2, week3 etc. (up to week 17). Every week, i have to enter a value into that...
September 12th, 2005 08:05 PM
by Michel Walsh Go to last post
1 603
"First" function returning garbage - even after sorting previous q by mrselfdestruct
Hi, I'm running a database with some medical information in it where I need to identify the first malignant diagnoses for each patient. I used a query...
February 9th, 2005 08:45 PM
by mrselfdestruct Go to last post
2 573
"Fuzzy" Query by Andy
Hi, I have two large tables that need to be combined, Original and 01_16. The two fields in question are Original.Company.Name and 01_16.BusinessName. 01_16...
June 24th, 2005 02:59 AM
by Linda Burnside Go to last post
2 592
"Group By" problem by JMCS
We have a query that has been working quite happily for over ayear, but has suddenly decided to play up, giving a "No current record" message box. The query...
October 7th, 2005 04:29 PM
by '69 Camaro Go to last post
3 802
"Hold" values? by cottage6
If possible I need to create a query with data from all 4 or 5 weeks in a period, layed out in columns like a spreadsheet. Example: W/E 2/5/05 ...
May 25th, 2005 05:28 PM
by cottage6 Go to last post
3 636
"Horizontal" output from many-to-many tables by Tony Maddox
Hi I have a table which has 6 fields:SpecID, GroupID, then Value 1, Value 2, Value 3 and Value 4. Each specimen can have one or more associated groups and...
July 16th, 2004 02:13 AM
by Dale Fye Go to last post
1 706
Post New Thread


Display Options
Showing threads 1 to 20 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 01:02 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.