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
Display parameter used for query by Pyrite
I have a query set up to search for people eligible to access a specified site. An unbound combo box on a form allows the user to select from a predefined...
July 18th, 2008 03:48 PM
by Pyrite Go to last post
2 149
Query Date criteria by Jasper Recto
I have a query that has a date criteria that is in a range. For example it runs from 1/01/08 to 03/31/08. Is it possible to change the criteria so it...
July 18th, 2008 02:08 PM
by [email protected] Go to last post
1 147
Left Join Query by Danu
This should be simple but I am having a problem. I have a table which I have set up in a left join query against a much larger table. The common field is the...
July 18th, 2008 01:34 PM
by Danu Go to last post
2 142
Update Query combine two functions by Darmahart
Is there a way to combine two functions in the Update To box for one field? I'm trying to use Replace() to get rid of two excess strings of duplicate...
July 18th, 2008 06:54 AM
by Darmahart Go to last post
2 117
Hard to explain - multiple update fields query... by David Mulholland
I'm starting to toss around ideas to see how I can accomplish this: I have a SQL table for awards that I connect thru ODBC. It has and ID field(PK) and 40...
(Multi-page thread 1 2)
July 18th, 2008 12:26 AM
by John Spencer Go to last post
11 254
Union Query by Royce Schnepp
Here is my dilema if you will. I am working on a database for foreclosure sales, in the process of appeding information from DBF files to tables, the primary...
July 17th, 2008 11:32 PM
by Royce Schnepp Go to last post
6 191
2 fields of different lenghts by Revis01
I am creating a queary of 2 tables. Common field is Account number. Table A, the filed is 15 characters. Table B, the field length is 25, and the 10...
July 17th, 2008 11:02 PM
by Jeff Boyce Go to last post
2 130
extract part of a text value into a date by sherriross81
I have a field that is a date but it is stored as a string. I am not allowed to change the field data type, but in my access report I would like to display...
July 17th, 2008 10:56 PM
by KARL DEWEY Go to last post
2 124
dateadd conditional formating to equal yes or no by Todd
I have a field called next monitor where I have another field called over due. In the overdue field, I am using the following code to make a yes/no...
July 17th, 2008 09:54 PM
by Todd Go to last post
1 104
query based on different devices by Nick A Carter
I work in a very large IT database that tracks serverfarm racks and the equipment on them. We just had a new field added to the database and I need to...
July 17th, 2008 09:26 PM
by KARL DEWEY Go to last post
2 162
append query question by PattiP
I'm keeping track of monthly meter readings with a sample of 6 accounts. I have created an append query that copies the previous month's accounts to the...
July 17th, 2008 08:44 PM
by PattiP Go to last post
6 157
Parameter Queries by alecgreen
I have a parameter query, using between and to which works fine, but I want to enhance the query to do the following. 1) I want to be able to select...
July 17th, 2008 08:16 PM
by bhicks11 via AccessMonster.com Go to last post
3 197
Need help with calculation by Gary F Shelton
SKU June08 NET LBS/CS July08 NET LBS/CS AUG08 NET LBS/CS 15010664 #error 24 ...
July 17th, 2008 07:57 PM
by Bob Barrows [MVP] Go to last post
5 179
IIF statement failing by Hank
I use the following in a query: PastDue: IIf(Date(),Format(25+-,"currency"),"") Something has changed. The code worked great for a while, but not it will...
July 17th, 2008 07:32 PM
by Hank Go to last post
3 117
Inconsistent query results by franky
Hello, I have a link to a vfp database table. I also have a local table with some of the items that exist in the vfp table. When I run a query with an...
July 17th, 2008 07:26 PM
by franky Go to last post
0 140
Update Query for Fiscal Date range by workweek
I have one table that contains Today's Date. I have a second table that contains fiscal month dates. For example July = 6/28/2008 - 8/01/2008. I need to...
July 17th, 2008 06:19 PM
by John W. Vinson/MVP Go to last post
2 141
Query an Asterisk in the description by Scott
Some of our product descriptions have an asterisk in the description to flag those products. How do I query all the products that have an asterisk in the...
July 17th, 2008 05:15 PM
by Scott Go to last post
3 165
Doesn't recognize Crosstab gen Fields by Bonnie A
Hi everyone! Using A02 on XP. I have a table with multiple records for 1-4 quarters. I have my first query (Query01) that pulls by (contract number) and ....
July 17th, 2008 05:09 PM
by Bonnie A Go to last post
5 196
Error when creating make tables by fgwiii
I have been using the same make table queries for months and when I ran two different queries yesterday, I am receiving errors on both queries after the...
July 17th, 2008 04:56 PM
by John Spencer Go to last post
1 125
Compound Select by JimS
I have a cool new form I'm having trouble with the rowsource property...primarily because I'm hard-headed... Here's the situation: I want to select as my row...
July 17th, 2008 04:44 PM
by KARL DEWEY Go to last post
1 103
Post New Thread


Display Options
Showing threads 9861 to 9880 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 10:11 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.