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
Delete Query Help by SITCFanTN
I'm running a delete query that removes the records from table tblAllRecords when the PolNo is also found in a table called tblTransfer. When I run the...
May 11th, 2010 07:51 PM
by KARL DEWEY Go to last post
2 142
minimize repeating query criteria & generating monthly YTD totals by Liv[_2_]
I have 5 queries. One for each month. There are # things I want to do here. Consolidate to a single query. currently the "Query is too complex" message...
May 11th, 2010 06:30 PM
by Liv[_2_] Go to last post
1 189
How can I refresh the master form from a subform? by Iram
Hello. On the After Update of the subform I am trying to refresh the Master form. I have tried things like Docmd.requery and Me.Refresh, but not sure what I...
May 11th, 2010 05:28 PM
by Marshall Barton Go to last post
1 336
address in one line by Pat
Hi all, I am trying to get query to return record like follow: name 123 mian st. houston, tx 77082 USA but the result i get is as followed:
May 11th, 2010 04:53 PM
by John W. Vinson Go to last post
4 130
Combine field entries in new field by cluckers
Is there a way in design view to run a query that will combine the entires of one field into another field? For instance, I have 1 field that is NAME and a...
May 11th, 2010 04:08 PM
by cluckers Go to last post
2 206
Access 2007 Will not accept wildcard by Rita Brasher[_2_]
I have a query and in the criteria for a text field (Route), I'm placing the following statement: Like "*433" When executed, the query will not return any...
May 11th, 2010 04:01 PM
by Rita Brasher[_2_] Go to last post
3 114
Delete Records from Table using Query Results by SITCFanTN
I have a table named "Records" that contains a field "Customer Number". I need to delete all the records in table "Records" if the "Customer Number" is also...
May 11th, 2010 01:46 PM
by John Spencer Go to last post
3 162
start date & end date - show all date in between by Nancy Tang
I have a date table & a leave table which leave table contains startdate & end_date. How i do show all date in between startdate & end date . For example :...
May 11th, 2010 04:03 AM
by PieterLinden via AccessMonster.com Go to last post
2 157
Cumulative Percent by JD
My intent is to add a field to my table that contains the cumulative percentage of the CumFreq field (cumulative frequency). Any help would be greatly...
May 11th, 2010 01:12 AM
by JD Go to last post
0 112
Output Query as an Excel file by accesshacker
I am trying to output a query as an excel file and save it to a specific location. Here is my code. DoCmd.OutputTo acOutputQuery, "Qry:SKU_ALL_2",...
May 10th, 2010 11:08 PM
by accesshacker Go to last post
2 361
crosstab parameterized query by gator
PARAMETERS FISCALMO IEEESingle; SELECT * FROM WHERE (((.TYPE)=3) AND ((.YRMODA) Like "10*")) ORDER BY .AMOUNT; There is my query where I finally got the...
May 10th, 2010 08:59 PM
by Jerry Whittle Go to last post
1 220
Join 2 tables by MrRJ
Hello, I am a very basic user of MS Access. I love the functionality of it and would love to learn more. Here is my situation. I have started up a query...
May 10th, 2010 06:57 PM
by MrRJ Go to last post
1 145
IIF STATEMENT by gambler
When i write the following IIF statement i get the error mesage WRONG # ARGUMENTS. What am i doing wrong? K:IIF(=1,2,0IIF(=2,1,0)) tHANKS ED
May 10th, 2010 06:07 PM
by Dirk Goldgar Go to last post
6 199
Format DATETIME to Date in query on linked table by cjon
Access 2007 hitting an Oracle Database with MS ODBC Drivers for Oracle V 10.x I am pulling data from a linked Oracle table that contains a datetime field, . ...
May 10th, 2010 02:34 PM
by cjon Go to last post
5 232
Multiple fields into one by AtleDreier via AccessMonster.com
Hello! This is concatenating with a twist. I have three tables: Tag: *tag Doc_ref:
May 10th, 2010 01:45 PM
by John Spencer Go to last post
5 169
Update - Microsoft Responds to the Evolution of Community by [email protected]
What is Happening? This message is to inform you that Microsoft will soon begin discontinuing newsgroups and transitioning users to Microsoft forums. Why? As...
May 10th, 2010 08:09 AM
by [email protected] Go to last post
0 127
Combobox Dropdown jump to selections starting with E's by Iram
Hello, I have a combobox field with selections starting from A through Z. When I click on the combobox I need the drop down to skip down to the E's - Z's. In...
May 9th, 2010 03:58 AM
by Marshall Barton Go to last post
1 233
two access table in one query by Ahmed Saleem
i design a report with access database i prepare a query with two table without joinning but the query return data more than one time Please solve my...
May 9th, 2010 01:03 AM
by John W. Vinson Go to last post
2 170
Criteria for select query. by Frank Martin
I have Access2003. I need a criteria expression to select certain data from a query QryLedgerTxns. When the ledger is reconciled with the bank statement,...
May 8th, 2010 03:53 AM
by Frank Martin Go to last post
2 166
Stacked vs Multiple Inner Joins by Jack Leach
Hi all, being a little slow when it comes to queries, I'm wondering if someone has any advice on which is the more efficient method to use. Consider three...
(Multi-page thread 1 2)
May 8th, 2010 01:18 AM
by david Go to last post
10 269
Post New Thread


Display Options
Showing threads 241 to 260 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 05:13 AM.


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