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
Why does Access 2007 save query changes w/o prompting? by Dave M
In some of my databases, when I edit a query in design mode Access saves the changes I made without prompting me if I wish to save changes. Additionally in...
March 1st, 2010 12:28 AM
by Mark Hennig Go to last post
1 298
CalcWorkDays error by Sue Compelling
Hi (Access2007) I'm trying to get Klaatu's CalcWorkDays function to work though something's not quite right in the results. Would appreciate any help that...
February 28th, 2010 10:50 PM
by Sue Compelling Go to last post
2 301
Query for a report by lettyg82
Good Morning. I am trying to figure out how to calculate the number of days between two dates. I have a table callled events. That table has event date,...
February 28th, 2010 05:44 PM
by Cesar Go to last post
1 183
Setting Fieldname in query with a combobox by Mafukufuku
I want to set the fieldname for columns in a query by having the user select from a combobox. - What is the right expression to be put in the fieldname in...
February 27th, 2010 11:49 PM
by John W. Vinson Go to last post
6 181
Multiple IIf by quinto via AccessMonster.com
Needs some help If code =1,Action Date,+365, if code =2,Action Date, +730, If code=3,Action Date+30 Can someone help with this and how many If can I use? If...
February 27th, 2010 07:06 PM
by quinto via AccessMonster.com Go to last post
2 172
help please with creating a Query with different by Helping People Ros
Hello: I have a database of resources to use with clients with depression, anxiety, stress etc. I have the symptons (depression anxiety etc) as yes / no...
February 27th, 2010 01:16 PM
by Allen Browne Go to last post
2 180
Is this Possible - Dynamic Field Selection within a QBE grid? by Zoomiest
I have a combo box that looks up a the feilds in a table. Then, in my QBE grid, (that a report is based on), in the FIELD row, I say !. so it will pick up...
February 27th, 2010 01:53 AM
by John W. Vinson Go to last post
1 212
Multiple Values in a Query Criteria by Deo
Hello, I have a combo box on a form that allows a user to select a location code that is used by a query. I want to run the query for two location - 73 and...
February 27th, 2010 01:51 AM
by John W. Vinson Go to last post
1 202
Erratic results from query criteria by Owl
I am getting different results from running the same query with the same selections. One moment it is all behaving as expected, the next it has gone...
February 27th, 2010 01:18 AM
by John W. Vinson Go to last post
3 196
Trim Time off Date by GMC -LSND
Access 2007 linked to SQL 2008 database I have a query with a date field that has the time included on it. How do I trim, truncate, remove the time part of...
February 27th, 2010 12:20 AM
by David W. Fenton Go to last post
4 182
Remove redundant text by Rich Sullivan
How would I remove in a query the last or right most characters or a constant value like: New York, NY Rochester, NY Buffalo, NY And I want to remove ",...
February 26th, 2010 11:43 PM
by John W. Vinson Go to last post
6 206
AutoNumber Field Not Populating with Append Query by AccessIM
Hello - I have the following append query: INSERT INTO tblDiscipline ( DISCIPLINEDATE, EMPLOYEEID, SSN, NAME, DATEOFINCIDENTCAUSINGDISCIPLINE,...
February 26th, 2010 10:26 PM
by AccessIM Go to last post
2 179
Query Trouble by Eoin McGlynn[_2_]
Hellow, I'm using the filter below to filter a query. However when "All Grades" is selected it will not display the "is not null" filtered query. It is...
February 26th, 2010 08:56 PM
by Eoin McGlynn[_2_] Go to last post
4 184
Sorting does not distinguish between Œ and OE or Æ and AE by Karen Ahmad
Hi - I have a database in Microsoft Access 2002 - 2003 file format. It is being accessed by a VB6 program using ADODB. One of the fields in the database...
February 26th, 2010 08:41 PM
by Jerry Whittle Go to last post
2 213
Creating duplicate rows by kevin
I need to set up a query that will look at a table and for each row that has a field with a quantity 1 (eg. 10), will create a row for each quantity instead...
February 26th, 2010 08:37 PM
by John W. Vinson Go to last post
3 173
Unable to join 3rd subquery in nested query by Kou Vang
I am able to correctly nest 2 queries into one, but am unable to successfully get the third query to work. I do this all the time in Pass-Through, but this...
February 26th, 2010 08:23 PM
by Kou Vang Go to last post
0 192
Grand Total Time by auujxa2 via AccessMonster.com
I've exhausted my research ability on this one. Please help! I have StartTime1, EndTime1, TotalTime1. (through 7 for a full week) The start and end times...
February 26th, 2010 08:01 PM
by John W. Vinson Go to last post
6 302
Crosstab Query For Fiscal Year Totals by DevlinM
I want to write a crosstab query for FY totals that will show each month regardless of wether there is data or not. Any help on this is greatly...
February 26th, 2010 08:00 PM
by Jerry Whittle Go to last post
1 446
access query question using not " " by access query question using not[_2_]
need to say not with about eight items can get it to work with one item but not more than one how do i do this?
February 26th, 2010 06:51 PM
by Kathy R. Go to last post
2 312
View Most Current by DevlinM
I have a table Personnel and a Table EmploymentStatus. I want to write a query that will show all Personnel with most current Employment Status Only. Any...
February 26th, 2010 04:49 PM
by Daryl S[_2_] Go to last post
2 184
Post New Thread


Display Options
Showing threads 1061 to 1080 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 08:42 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.