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
SQL help needed please by cinnie
greetings gurus I am having trouble with the syntax of a query I'm trying to write. Here is the situation, simpified to its essence: C:/DB/A.mdb has...
February 15th, 2010 11:04 PM
by John Spencer Go to last post
5 241
Modiify Records by Carl_B[_2_]
I recall reading about limitations in Access regarding modifying records in a form which is based upon a query of more than two tables. I have searched for...
February 15th, 2010 10:57 PM
by John W. Vinson Go to last post
2 279
Tabbed Pages Not Refreshing by PA
Access 2007, with two tables. Table A has field1 as the primary key field Table B has field1(same as field1 in table A) and field2 as a dual primary key. ...
February 15th, 2010 09:24 PM
by Jeanette Cunningham Go to last post
1 208
Update Link Tables from Excel by BlairH
I recently got an update from Office 97 to Office 2003. We're just slightly behind the times. Anyway, I had an access database in 97 that would link to an...
February 15th, 2010 07:57 PM
by BlairH Go to last post
1 206
Sort across a table by The Viking
I have a table with theese...
February 15th, 2010 07:36 PM
by KARL DEWEY Go to last post
2 226
Year(Date()) not working by johnlute
Access 2003 Win 2000. SELECT tblCustomerComplaints.DateReceived FROM tblCustomerComplaints WHERE (((tblCustomerComplaints.DateReceived)=Year(Date()))); The...
February 15th, 2010 04:49 PM
by johnlute Go to last post
9 280
February 15th, 2010 04:04 PM
by lmiller Go to last post
0 189
Referencing a control on subform 1 from subform 3 causes access to crash by Ceebaby via AccessMonster.com
Hi Folks Using Access 2003 SP3, I have a main form with 3 linked subforms to a propertyID and fundID on the main form. On the AfterUpdate Event of a field...
February 15th, 2010 03:42 PM
by Tom van Stiphout[_2_] Go to last post
1 233
COMBINING QUERIES INTO 1 by lmiller
I have posted a similar question earlier today, I am trying to combine a couple of queries into one. I keep getting a syntax error in the joined...
February 15th, 2010 03:07 PM
by lmiller Go to last post
3 198
3 queries into 1 by lmiller
Hello, I am going to try this again starting fresh from my other posts. I am trying to develop an all inclusive query on our inventory. Each fical term we...
February 15th, 2010 02:25 PM
by lmiller Go to last post
8 248
combining queries into 1 by lmiller
Daryl S, Here is the query, I believe you suggested: SELECT ., ., ., ., nz(.,0)+nz(.,0) AS FROM ( LEFT JOIN ON . & .) LEFT JOIN ON .=.;
February 15th, 2010 01:58 PM
by lmiller Go to last post
8 171
Counting multiple field values in a single query/report by KatK
I am creating a database for a community program that includes a number of fields with drop down choices, such a race, school, abuse history, family...
February 15th, 2010 04:59 AM
by KARL DEWEY Go to last post
2 217
UNION question by terry w
lets say there is a union query like this; SELECT tblP.* FROM tblP WHERE ...etc. UNION SELECT tblQ.* FROM tblQ WHERE ...etc. UNION SELECT tblR.* ...
February 15th, 2010 02:49 AM
by John W. Vinson Go to last post
3 244
'NOT IN' vs ' ALL' by Sarah
greetings to all An SQL fragment I use is... WHERE tblValues NOT IN (SELECT ... The query runs properly. I have noticed that I can get the very same output...
February 14th, 2010 11:00 PM
by Sarah Go to last post
4 167
Split address field by Sandspur
I have an field that has one (1) or two (2) lines. i need to split current field into two (2) fields and Thank you
February 14th, 2010 10:30 PM
by John W. Vinson Go to last post
3 181
Want to use Group By in union Query - solution by Irshad Alam
I have made query from 2 different table which works fine : SELECT , "Address:- " & & " Telephone:- " & & " Fax.:- " & AS CustomerDetails FROM...
February 14th, 2010 02:40 PM
by John Spencer Go to last post
1 174
getting max value by John Spencer
SELECT TrainDetails.ch_TrainDetailsID_pk , TrainDetails.ch_TrainDetailsID_fk , TrainDetails.ch_CurrentYrNo , TrainDetails.ch_CurrentWkNo ,...
February 14th, 2010 08:17 AM
by John W. Vinson Go to last post
2 173
Search for records with no matching foreign key by Little Penny[_3_]
I have two tables that are linked by primary and foreign keys which are tblClubs (Primary) and tblmembers (Foreign) and a One to Many relationship. I also have...
February 14th, 2010 06:21 AM
by KARL DEWEY Go to last post
4 175
External db in sql FROM by Becky
I need help with some sql. What is the proper syntax for the following? I'm in one database, but trying to get data from an external another one. FROM...
February 14th, 2010 12:33 AM
by David W. Fenton Go to last post
4 214
Using a parameter by PeterM
I have a form (FormA) which has a subform(FormB). One of the listboxes on FormB uses a query using a field from FormB as part of the where statement. I've...
February 14th, 2010 12:09 AM
by KenSheridan via AccessMonster.com Go to last post
2 154
Post New Thread


Display Options
Showing threads 1201 to 1220 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 02:41 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.