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
Not Selecting Field Name When Trying To Copy & Paste Cells by mcl[_2_]
If I try to copy more than one cell after running a query it always includes field names. I want to copy several cells in a line or the whole line and then...
May 14th, 2008 12:42 PM
by John Spencer Go to last post
1 150
formatting numbers after using the nz function by jlarson
i created an outer join in access 2003. The results work fine, and I get the expected null fields. I can format the resulting numbers in the query and in...
May 14th, 2008 12:38 PM
by John Spencer Go to last post
4 128
Syntax error in UPDATE statement. by MJ
I am puzzled by this syntax error. I am using the same code over and over again (with minor modifications to field names) and this error seems to pop up. ...
May 14th, 2008 12:36 PM
by John Spencer Go to last post
2 141
Using Multiple Fields to Find Unmatched Records by Chris
Hi, I have two tables, where the child table has two primary keys to link it to the parent table. I'm trying to create an unmatched query where it will find...
May 14th, 2008 12:30 PM
by John Spencer Go to last post
5 136
How to replace "Blank" With "0" by Syphonics via AccessMonster.com
I am creating a report base on the filtered results from the query. Sometimes there is no results after filtering. The query is total blank. As my report is...
May 14th, 2008 11:14 AM
by Evi Go to last post
9 201
enter a count function to count records? by Kimberly
I am desperate I don't know vb, yet I want to enter a count function to count records in a table or query. Any help is greatly appreciated. I need as soon...
(Multi-page thread 1 2)
May 14th, 2008 07:39 AM
by Evi Go to last post
11 223
Enter multiple Parameters for a Field by Hannah
Hi All, I'm trying to create a parameter that allows you to enter two values. For example, in my query I created a parameter to enter the brand so that the...
May 14th, 2008 03:13 AM
by John W. Vinson Go to last post
1 120
Leading 0 won't count as duplicate by Ardy
Hello All. I am using MS Access 2007. my problem is that I have table with over 177,000 records and for some reason in data transfers one of my...
May 14th, 2008 01:20 AM
by Ardy Go to last post
2 145
Finding records in one DB that are not in another by Cindy
I have two tables, a product master file and a price list which is a subset of the product master file. I need to find all records that are in the product...
May 14th, 2008 01:03 AM
by Cindy Go to last post
2 125
rounding in update query by j9
I have a table with a Chronological Age column, defined as Single, fixed, with auto decimal places. I have an update query that does a DateDiff function to...
May 14th, 2008 12:57 AM
by fredg Go to last post
1 109
sort field in ascending order and get the value of the 2nd row? by dicox
For example if the values a 1,1,2,3,4 then return 1 1,2,2,3,4 then return 2 1,2,3,4,5 then return 2 Appreciate any help.
May 14th, 2008 12:31 AM
by KARL DEWEY Go to last post
6 123
Can I get a drop down menu of options in a query search? by Brian S
Is it possible to get a drop down menu of options when doing a query search?
May 14th, 2008 12:17 AM
by fredg Go to last post
5 124
$ Complex Access Query by [email protected]
I would be happy to pay $50 via Paypal to the first person to successfully answer my question. I am using Access 2003 and Excel 2003 (I'm hoping to be able to...
May 13th, 2008 11:55 PM
by [email protected] Go to last post
4 196
Updatable passthrough queries by Jake
Is it possible to make a passthroguh query updatable? I think that it normally isn't because it doesn't know the primary key, but is there a way to specify...
May 13th, 2008 11:52 PM
by Rick Brandt Go to last post
9 143
Need Mid Function by Dataman
I have a ClientSampID that looks like this: T2/LA-10-(0-6) I am looking for a statement that will pull the text after the "/" and before the first "-"....
May 13th, 2008 11:46 PM
by fredg Go to last post
2 112
Run all queries in a group by CFitz
Is there any way to run all of the queries that are in a group? I could always make a macro that runs each query but it'd be easier if there was just one...
May 13th, 2008 11:32 PM
by fredg Go to last post
1 115
Accepting between criteria from text box in access 2007 by H0MELY
I have prepared a tool in Access 2003 that allows me to pull data based upon the data between two set dates and that are established from a form. In...
May 13th, 2008 09:58 PM
by H0MELY Go to last post
1 117
Count items over 30 days old by lmossolle
I have a date field "daterecieved" i would like to query for items over 30 days old where a completed field is null. Please assist. Thanks
May 13th, 2008 09:34 PM
by Jerry Whittle Go to last post
1 109
INT conversion by Rich[_14_]
Hi, I'm running an update query on tblInv that, among other things, extracts an important number from within a string in the text field . In it's original...
May 13th, 2008 08:42 PM
by Rich[_14_] Go to last post
7 120
finding non-duplicated records by Confused about Access
Help! I have two tables, one is a "master list" and the other table has most of the files that is in the master list. Is there anyway to extract those files...
May 13th, 2008 08:10 PM
by Confused about Access[_2_] Go to last post
8 142
Post New Thread


Display Options
Showing threads 11001 to 11020 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 07:31 AM.


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