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
Error upon exporting results of query to text file by Rita Brasher[_2_]
Using Access 2000 and Windows XP Professional I have a query that, when executed, returns a substantial number of rows. This is exported to a tab...
December 16th, 2009 08:41 PM
by Phil Smith Go to last post
1 195
Update Query Question by randlesc
I know this is a very basic question but I honestly don't know where to find the information specific to this question. I have a table of employees names and...
December 16th, 2009 08:27 PM
by KenSheridan via AccessMonster.com Go to last post
3 286
yes/no or both Error 3071 by javablood
I was following a thread on 11.19.09 by Owl and responded by Karl Dewey and John Spencer and thought I had my answer but do not. I have a form in which I...
December 16th, 2009 07:48 PM
by javablood Go to last post
2 185
Parameter Value in Crosstab Query by NEWER USER
I created a Select Query using a Parameter Value defined in my criteria . The records are retrieved when query runs. Now... I take that query and build a...
December 16th, 2009 06:51 PM
by NEWER USER Go to last post
4 204
Combine and Insert query by Ranjith Kurian[_2_]
I have linked three csv files to MS Access Table, the table names are as follows MON.csv, Tue.csv and Wed.csv I have combined all the three tables using...
December 16th, 2009 06:14 PM
by Ranjith Kurian[_2_] Go to last post
7 177
delete query using inner join by seeker
The following sql in access DELETE DETAIL2.ID, DETAIL2., DETAIL2., DETAIL2., DETAIL2., DETAIL2., DETAIL2., DETAIL2., DETAIL2., DETAIL2., DETAIL2.,...
December 16th, 2009 05:00 PM
by Daryl S[_2_] Go to last post
2 188
deleting duplicate records obtained from a duplicate query by Paul
I used the "Duplicate Query" wizard in Access to display duplicate records in a table. Is there a way to use that to create a Delete query that would remove...
December 16th, 2009 07:29 AM
by Paul Go to last post
4 215
How do i add the values of a column in a query in Access by THPCT
This is driving me mad can someone help please: How do i add the values of a column in a query in Access
December 16th, 2009 06:34 AM
by [email protected] Go to last post
3 205
Date Range query design by KarenO[_2_]
I am working on an expenses database for a small family business. For each expense I have a start date and end date. I have the database then “normalize”...
(Multi-page thread 1 2)
December 16th, 2009 03:24 AM
by KarenO via AccessMonster.com Go to last post
11 480
rst.findfirst not working with two conditions by chanu
i have a table with two date fields and i opened a dao recordset (based on a query) on it .Now i want to search whether a particular date group falls between...
December 16th, 2009 01:52 AM
by Allen Browne Go to last post
6 259
Carriage return grrrrrr by Sue Compelling
Hi All I've got myself horribly lost with my query - which potentially has 5 rows - I only want to have a new line if the field has a value - though I end...
December 16th, 2009 01:16 AM
by Sue Compelling Go to last post
6 216
Summing fields between two dates by RealGomer
I think I know how to do this but any extra help would be appreciated. I have a table with four fields - net sales, payin date, payin number, and payin...
December 15th, 2009 09:53 PM
by vanderghast Go to last post
1 187
query to filter by current record id? by Seddon Acaster
2 tables called customer and service customer table has unique numerical customer id field, this is the primary key. an example value for this field would be...
December 15th, 2009 09:19 PM
by Seddon Acaster[_2_] Go to last post
4 289
Join Question? by Dez
I have two tables that I'm pulling information from, one for the current year, one for last year. I am attempting to pull budget information for certain...
December 15th, 2009 05:28 PM
by Dez Go to last post
3 185
Using 'LastOf' function in queries by Candice
Hi, I have inherited some Access databases that are using 'LastOf' in queries to pull records to show on forms and reports. I have never used this function...
December 15th, 2009 05:23 PM
by Candice Go to last post
8 313
query to overcome field type problem? by Slushpump
I have a contacts table... let's say 2 fields- ID and email. I have a groups table... it has a number of fields that are linked back to the contacts field...
December 15th, 2009 04:10 PM
by Slushpump Go to last post
4 202
Call function from query 'Criteria' line. by Breecy via AccessMonster.com
I am trying to call a Public function from the criteria line in the design view of the query builder in Access 2003. I will try and recreate the look: Field:...
(Multi-page thread 1 2)
December 15th, 2009 04:07 PM
by Breecy via AccessMonster.com Go to last post
11 382
getting Tags ID used in queries by Kami
Hi, I have hundreds of queries using thousand of tags recorded by the access database. From all these queries, I need to create a list of all the Tags used...
December 15th, 2009 03:38 PM
by Kami Go to last post
3 219
parameter query by zezo
Hi, I need help to finish my Query, I want to let the user put a serial number to get it or put several serial numbers or collect it all so I did this ......
December 15th, 2009 03:09 PM
by John Spencer Go to last post
1 197
Why does query convert "Like" criteria to "ALike" by dishrag86
Sometimes queries seem to go corrupt and when I type "Like" (without quotes) into my criteria as soon as I click out of that criteria, it changes to "ALike"....
December 15th, 2009 10:29 AM
by Allen Browne Go to last post
1 193
Post New Thread


Display Options
Showing threads 1921 to 1940 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 03:50 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.