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
test by Jaimon Lukose[_2_]
Am unable to post queries, just testing
May 5th, 2010 06:49 AM
by Jaimon Lukose[_2_] Go to last post
0 194
Test message by Jaimon Lukose
May 5th, 2010 06:28 AM
by Jaimon Lukose Go to last post
0 148
Updating values from the previous record by Leo
I was using Allen Browne's module to update values from previous record. The entire code could be viewed at the following address: ...
May 5th, 2010 06:12 AM
by Leo Go to last post
0 135
Can you merge a "Count" Crosstab with a "Money Sum" Crosstab? by Iram
Hello, I have created two critical queries. One counts how many times we did something and the other sums the money amounts for the same "counted" records....
May 5th, 2010 12:04 AM
by Iram Go to last post
8 278
cdo or objmessage?? by auujxa2 via AccessMonster.com
I developed a 2007 database, in which i have dozens of runtime users. because of this, we ran into missing reference issues. All of them I corrected, but...
May 4th, 2010 09:12 PM
by auujxa2 via AccessMonster.com Go to last post
0 154
Filtering records by date by Sabu
Yea I'm trying to filter a table that has specific due dates, but I want to run a query that will show the results 7 days before the due date and not show...
May 4th, 2010 09:08 PM
by KARL DEWEY Go to last post
2 195
Numeric Field Overflow Error by Tracy
Hello, I have a table in my database that is liked to an excel file. The data type of every field of the linked table is 'text'. I have created another...
May 4th, 2010 08:49 PM
by John W. Vinson Go to last post
5 161
Left Join query not working in Access 2010 by Eric Heinold[_3_]
Hello, I have a query that works correctly in Access 2003, but not in Access 2010. Here is the SQL: SELECT qrySysSelectEeSS.EmployeeID,...
May 4th, 2010 08:07 PM
by Eric Heinold[_3_] Go to last post
0 157
Recieving Inventory Query by Ernst Guckel
Hello, I'm pretty sure we are approaching this correctly but not sure how to do this: We have a purchase order database where we enter all our inventory...
May 4th, 2010 07:04 PM
by KARL DEWEY Go to last post
3 284
May 4th, 2010 07:01 PM
by Jerry Whittle Go to last post
3 160
Min value & corresponding date by woods1119
I need to get the min value of FVC% and the corresponding date that goes along with this value. I've had no luck just trying to use min from the totals...
May 4th, 2010 06:55 PM
by Marshall Barton Go to last post
7 168
Using AND or Something? by gngsquared
Easy one for the pros but it has me scratching my head in frustration. So here goes. is indexed on autonumber field . The table includes a field that will...
May 4th, 2010 05:47 PM
by KARL DEWEY Go to last post
3 142
Check if a value is legal by atledreier[_2_]
I have some fields I need to check against another table. The scenario: My users have been inputting data in my tables through queries up until now. i've...
May 4th, 2010 04:53 PM
by Bruce Meneghin Go to last post
3 119
Duplicate prompts in crosstab query and subsequent report by Leath
I have a crosstab query in which I am prompting for a date range (Between and ). When I run this report it prompts me multiple times for the date range. ...
May 4th, 2010 04:43 PM
by KARL DEWEY Go to last post
1 348
Syntax error when using names with apostrophe by inbarik
i'm getting syntax error message for this button that tries to get name (of building) with apostrophe. Any idea how to solve this? Note that i must use name...
May 4th, 2010 04:27 PM
by Stefan Hoffmann Go to last post
1 242
Null or NOT in another table by atledreier[_2_]
Hello. I have a query that verifies that required fields in my records are populated and correct. Right now it returns the records that have required...
May 4th, 2010 02:01 PM
by vanderghast Go to last post
5 153
Query Inside an SQL statement by Mr. Bud
Hi and TIA. What I'm wondering is can you use aquery name in place of a table name when building an sql statement in code? Example below can I replace...
May 4th, 2010 11:22 AM
by Mr. Bud Go to last post
3 170
I require a query to count repairs by week by trevorC via AccessMonster.com
Hi, I have a query as shown, that gives me the number of repairs per week, but the output shows an entry for each day of the week with the total as well, can i...
May 4th, 2010 08:29 AM
by Bob Barrows Go to last post
4 157
Anyone who can help my fried mind with this solution? by NY
Dear all, I am writing code about custom sorting tecniques. This code will appear in my upcoming book. I explain two ways: one by using the switch...
May 4th, 2010 06:11 AM
by John W. Vinson Go to last post
2 143
Previous and Next from Criteria by Mark S
I am not sure what to even look for here so I wasn't able to do any real searches to see if this has been answered. Ok, this isn't exactly what I am doing...
May 4th, 2010 05:23 AM
by Jeanette Cunningham Go to last post
3 121
Post New Thread


Display Options
Showing threads 301 to 320 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:42 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.