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
A calculated field in access by Candy Pierce
I need an Expression to extend the purchase date to a warranty expiration date based on a product type -- Thanks !Candy
December 10th, 2009 04:41 AM
by Joe N Go to last post
8 295
Minimum date difficult situation by tcek
i have two tables with multiple rows pertaining to various customers. Each row has a multitude of information including a date field. The other table has...
December 10th, 2009 04:16 AM
by KARL DEWEY Go to last post
3 157
Please help us to help those in need this christmas show them thatsomeone out there cared and love is still out there give them a reason to by members
Please help us to help those in need this christmas show them that someone out there cared and love is still out there give them a reason to believe and have...
December 10th, 2009 03:19 AM
by members Go to last post
0 206
Query is too complex by JP
I am running Access 2007. I have data in about 20 tables that I want to combine together. This is groundwater sample data from a myriad of sample...
December 10th, 2009 12:30 AM
by Jeff Boyce Go to last post
5 182
access 2007 criteria in query by cutthroatjess
Greetings, This has been an odd issue for this query with the given criteria in the WHERE statement: SELECT Parameters.ShortName, Parameters.LongName,...
December 9th, 2009 11:33 PM
by cutthroatjess Go to last post
2 144
Update query with date criteria by gillah11
Hi all. I have an update query that should only update a record if today falls between the 1st of it's month and the 7th of the following month. For...
December 9th, 2009 09:06 PM
by Jerry Whittle Go to last post
3 121
make query from to 64 bit system by Jennifer
I have a application need to be compile for 64 bit system. how can i read data from vb.net 2005.
December 9th, 2009 06:36 PM
by Stefan Hoffmann Go to last post
1 135
Simple Query by cowichandave
I am quering a database with 10000 records and the end result of the query should be about 1500 records. It worked once and now it hangs for a bit and...
December 9th, 2009 05:52 PM
by cowichandave Go to last post
3 96
December 9th, 2009 05:52 PM
by hshepardjr Go to last post
3 155
Prevent query from changing number values to text values by Renraf
I have three queries, each building off the previous, and by the final query, some of my number data has been converted to text data, and I need to prevent...
December 9th, 2009 05:21 PM
by Jerry Whittle Go to last post
6 170
Query from 3 tables by vanderghast
Note that it could be FAR EASIER to have the junction table minimumQty already filled with all the possible articleID, storeID, with NULLs under the qty if...
December 9th, 2009 04:52 PM
by vanderghast Go to last post
0 174
BKF-Display Results (a number) on form from a query by BKF
Example: I have a query that will count all Active Customers based off Account Numbers (unique). The query when run will obviouslly give me a count but can...
December 9th, 2009 04:49 PM
by BKF Go to last post
0 143
Export Query To Excel Problem by Pam
Hi, I have the following code to export a query to excel using a command button. It was working well. Now user tells me he can't get it to work. If I log...
December 9th, 2009 04:09 PM
by Pam Go to last post
2 161
no criteria by seeker
the following iif IIf(!!='wholesale',"N",IIf(!!='retail',"Y",IIf(!!='all',NULL))) attempts to place no criteria filter in the query when 'all' is found. ...
December 9th, 2009 04:05 PM
by KARL DEWEY Go to last post
3 174
Cannot see fields in query design view on laptop; Access 2003 by macroed
When in query design view on desktop (large screen), I can see the fields and criteria pane in the bottom half of the window, but when in query design view...
December 9th, 2009 04:02 PM
by KARL DEWEY Go to last post
1 280
nested if in criteria by seeker
i have the following in criteria of a query. IIf (forms!frmarchiveinvoicesoptions!txtacceptedarchivetype = 'wholesale', "N",...
December 9th, 2009 04:00 PM
by KARL DEWEY Go to last post
4 123
Append Rows based on field value by Bernie
I would like to have the append query create a fixed number of rows based on the value from a field value. For example, field value = 10. I would like my...
December 9th, 2009 03:56 PM
by KARL DEWEY Go to last post
2 126
Append Query w/ 'next number' by sunil707 via AccessMonster.com
Hello Gurus, Scenario: I have an oracle database connected thru ODBC. I want to append data to Table- A that has following in it: Col1 (Integer), Col2...
December 9th, 2009 03:16 PM
by sunil707 via AccessMonster.com Go to last post
0 157
how to count specific values only not total count by steven
I am using Access 2000 - I have one column of numbers (probably 1000 numbers in total) ranging from 1 to 9 - Does anyone know how I can count the times that...
December 9th, 2009 12:09 PM
by Brian Go to last post
3 181
combining fields by blindman
I have a report that groups three fields together, 'conveyor type', 'conveyor name' and 'maint. records'. There are multiple 'conveyor names' and 'maint....
December 9th, 2009 04:28 AM
by Marshall Barton Go to last post
7 341
Post New Thread


Display Options
Showing threads 1981 to 2000 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 11:55 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.