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
2 independent criteria by Rubem
Hi, I have a query with the following fields: Date, Part Number, description, etc.. I need a 2 criteria.. 1 for Date and 1 for Part Number and I want them to...
May 4th, 2010 05:11 AM
by Allen Browne Go to last post
1 338
Printing crosstab query by Afsaneh
Dear All, I would like to print a cross tab query directly.I need to change the date and title of it.but don't know How.since my cross tab query is not...
May 4th, 2010 05:00 AM
by Duane Hookom[_4_] Go to last post
5 438
ACCESS ADDITION by gambler
I have a number of fields in my query that i would like to add up and put that total in my report. My friend said i would first have to write IIF statements...
May 4th, 2010 12:52 AM
by gambler Go to last post
3 318
Append Query Not Working by HelpMe!
My Append query is not working and i am not sure why... Here is my SQL INSERT INTO tblContractPOTracking ( TrackingID ) SELECT tblDocTracking.TrackingID FROM...
May 3rd, 2010 10:01 PM
by PieterLinden via AccessMonster.com Go to last post
3 334
Multiple Fields Query Question by Ann
Hi - I need to query multiple fields to find out how many times a specific horse was used for the purpose of a group or private lesson. My query is...
May 3rd, 2010 09:06 PM
by Jeff Boyce Go to last post
2 241
Select Min Query by Joel_123
Hello, I first off want to say thank you to all those who post on this site. I am not very experienced in Access and the advice and direction offered here...
May 3rd, 2010 08:46 PM
by KARL DEWEY Go to last post
5 311
Rolling Average Calculation by toby131
I have a query (FIR) with 4 fields: Month, Incidents, Opportunities, and %Incidents. % Incidents is being calculated as Incidents/Opportunities. I want to...
May 3rd, 2010 02:08 PM
by vanderghast Go to last post
4 275
Finding a value in several different columns by Nick Xylas
Sorry if this is a really easy question, but I'm still learning when it comes to Access 2003's capabilities. I have a table from which I want to create either...
(Multi-page thread 1 2)
May 3rd, 2010 01:42 PM
by KenSheridan via AccessMonster.com Go to last post
14 471
Query Delete and append by quinto via AccessMonster.com
I am trying to add information to a table with an append query and that works fine since I duplicated the table. The information comes from a linked XLS sheet,...
May 2nd, 2010 02:03 PM
by quinto via AccessMonster.com Go to last post
0 301
Query Delete and append by quinto via AccessMonster.com
I am trying to add information to a table with an append query and that works fine since I duplicated the table. The information comes from a linked XLS sheet,...
May 2nd, 2010 02:03 PM
by quinto via AccessMonster.com Go to last post
0 248
Access query duplicates the table records by El Cajon Liberty[_2_]
Everytime I run my query it adds another set of the table records. Help!!
May 1st, 2010 10:55 PM
by John W. Vinson Go to last post
1 230
Query question by Jeffrey Marks
I'm having difficulty with a query for a report. I want to report all the volunteer records (by name) in the volunteer and when they most recently participated...
May 1st, 2010 02:29 PM
by KenSheridan via AccessMonster.com Go to last post
2 257
Dave Ashish method of updating from previous record by Leo
I need to enter the Height of the patient every time the form opens. The name of the control is . Yes I will name it better next time! I used Dave Ashish...
(Multi-page thread 1 2)
May 1st, 2010 05:10 AM
by Leo Go to last post
10 378
Access Query - returns 5 and 7 day information by Beeyen
Good Day Situation: I have a query in which I am trying to create to address the following data in my table. The coding is created in two parts Changes...
May 1st, 2010 03:46 AM
by Beeyen Go to last post
0 212
MS Access - Five and Seven day queries by Beeyen
Good Day Experts Situation: I have a query in which I am trying to create to address the following data in my table. The coding is created in two parts...
May 1st, 2010 02:46 AM
by Beeyen Go to last post
0 276
Access Query - "Duplicate Records Selected" by Brent
Any help would be appreciated. When viewing records resulting from a multiple table query, I discovered "Duplicate" records being selected. However, all...
May 1st, 2010 02:14 AM
by John W. Vinson Go to last post
5 254
Can't see what is wrong with this Union query... by AndyK
Can you? SELECT "Fred" AS Name FROM tblMonths UNION ALL SELECT "Joe" AS Name FROM tblMonths;
April 30th, 2010 11:31 PM
by AndyK Go to last post
5 235
Using Between...And with General Date by mewins
I am trying to query all records created between given dates. The field, DtRecCrt, is a general date field that is set to =Now() whenever the records are...
April 30th, 2010 10:14 PM
by Marshall Barton Go to last post
3 238
View Null Results in Query by StuJol
i have an access 2003 query SELECT ., .State, DateSerial(Year(),Month(),Day()) AS , TimeSerial(Hour(),Minute(),0) AS TimePeriod, Count(*) AS Total FROM...
April 30th, 2010 10:01 PM
by Marshall Barton Go to last post
1 268
ODBCTimeout by MMach via AccessMonster.com
Accee2003FE with SQL2005BE. How do I reset the ODBCTimeout (in VB code) from the default of 60 to 0 ? I do not want to edit Registry values. My code starts...
April 30th, 2010 09:35 PM
by MMach via AccessMonster.com Go to last post
0 260
Post New Thread


Display Options
Showing threads 321 to 340 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 09:40 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.