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
Query to List Reports and their recordsource by Dave F
Is it possible to create a query that will list all the Access reports and their recordsource? The database documenter gives too much information. I'm trying...
May 26th, 2004 10:46 PM
by Joan Wild Go to last post
1 531
Update Query by James Stephens
I have used this similar construction to do update from text boxes to a table but this one doesn't seem to work right and I am not sure what exactly is...
May 26th, 2004 10:41 PM
by James Stephens Go to last post
2 333
Update Query by Leif
I'm trying to move information from a table to a set of normalized tables. To do this I'm trying to use an append query. The destination tables has one main...
May 26th, 2004 10:19 PM
by Leif Go to last post
2 632
Can't use memo field when using unique by Peter-Dave
Hi... I have a multi user database and one report they frequently use is based on a query that returns unique values with on of the fields being a memo...
May 26th, 2004 09:31 PM
by Peter-Dave Go to last post
3 390
Select Latest Records by dave
Didn't work for me. In addtion to returning the details for checking out on the latest date, it appears to return records that have a Checkout date that...
May 26th, 2004 09:27 PM
by dave Go to last post
1 581
Count Group By by Patrick
I have a table of transactions for multiple iterations of the same policy number. The Group By function works to LIST the distinct policy numbers, but how do...
May 26th, 2004 08:55 PM
by Michel Walsh Go to last post
2 628
Parameter query question by Gina
I have a report that is pulling a form, which is pulling two subforms all attached to two queries with a parameter to pull employee number. All the parameters...
May 26th, 2004 08:32 PM
by Lynn Trapp Go to last post
1 337
GROUP BY/ORDER BY Question by BobRoyAce
I inherited a database which had the following query: SELECT MonthData.FiscalMonthNumber, (100* (SumOfKits/SumOfHours)) AS KitsPerHour FROM MonthData INNER...
May 26th, 2004 08:29 PM
by Go to last post
2 531
Showing all subrows in crosstab query by Ragnar Midtskogen
Calling all query gurus! I have a crosstab query where I group on two fields, and I can get the query to show all the first field but not the second. By...
May 26th, 2004 08:16 PM
by Michel Walsh Go to last post
3 1,095
Return String from Boolean Field by Dragon
Hi, I have the following query collecting data from a table where 'Complete' field is a yes/no field. I am exporting this data for a PDF merge and what I need...
May 26th, 2004 08:08 PM
by Dragon Go to last post
2 397
Multiple Append Queries to One Table by wpshop
I have a table with 5 fields. Each field's value can be calculated by using a Query to run a count on existing information in the main table. I can change...
May 26th, 2004 07:51 PM
by wpshop Go to last post
2 630
crosstab query not showing all values by Michel Peeters
I have a crosstabquery. The 8 column headings are weeknr based on DateDif. The value is the sum of Kg (double) The rowheadings are fields from the customer...
May 26th, 2004 07:32 PM
by Michel Peeters Go to last post
0 526
Convert grouped records into a string by mmattson
I am trying to convert all the names I have listed in a grouped query into one string record. For example, I am 1) grouping my records by date, 2) each date...
May 26th, 2004 07:04 PM
by Duane Hookom Go to last post
1 417
Crosstab Query Help by Newbie
Hi, I have the following query PARAMETERS !frmMetalRequirements! DateTime; TRANSFORM Sum(tblMatlSchedule.OSQtyReqd) AS SumOfOSQtyReqd SELECT...
May 26th, 2004 06:22 PM
by Michel Walsh Go to last post
1 291
Please help me!!! by Ann
Hi to anyone who can help. I have a table with the following fields: Last Name First Name Course ID 1 Course date req 1 Course ID 2 Course date req 2
May 26th, 2004 06:17 PM
by Ann Go to last post
2 345
need to delete the first 4 numbers of each record by Jimmy
I have 45000 records. In one field about 80% of those records are in a format: 4numbers space and a word (any word). What I need is to delete those 4 first...
May 26th, 2004 05:15 PM
by Go to last post
2 463
Crosstab Report and query by Newbie
Hi, I have the following query - see below I want a report that is based on week number - the actual week number needs to be on the report. I have written a...
May 26th, 2004 05:11 PM
by Newbie Go to last post
4 714
Access query is renaming output fields - dreadfully inconvenient by JonR
Hello, I am running a select query with a lot of different output fields. These fields relate all information pertaining to a number of projects that may be...
May 26th, 2004 03:31 PM
by JonR Go to last post
3 689
Unmatched Query by
I have created an unmatched query using the wizard. However I wanted the query to check more than one field before returning the unmatched records? Any ideas?
May 26th, 2004 03:20 PM
by Allen Browne Go to last post
1 1,068
string by Allouche Patrick
Salut j'aimerai remplacer un carctere present plusieur fois dans une chaine ? 1-2-3-4-5-6 deviendrai 1 2 3 4 5 6 donc '-' par ' ' ou encor inser un espace ce...
May 26th, 2004 02:56 PM
by Cheryl Fischer Go to last post
1 334
Post New Thread


Display Options
Showing threads 43201 to 43220 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 02:50 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.