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
How do I combine all datarecords in one field into another field by Mariana
Is there a way (running a query, macro etc) to combine all data from one field (different records) into one different field. Example we have 500 records. ...
September 7th, 2005 02:47 AM
by John Vinson Go to last post
6 134
Help with query criteria by Randy
I have a query that Ken Snell helped me with. It detects missing dates in my employee timesheet db. My query has a field of form tbl "Q", a field of where...
September 7th, 2005 04:24 AM
by David S via AccessMonster.com Go to last post
3 90
DMax and more!! by David#
We have a table that saves meter readings and dates. We need to calculate latest useage ( MINUS ). Dmax function will return the latest reading, but how can...
September 7th, 2005 04:26 AM
by David S via AccessMonster.com Go to last post
1 79
Use Transaction property by rKp
I have a db that I make several data manipulations on (delete, insert, updates, etc). The database is large ( 1GB) and I constantly make updates to tables...
September 7th, 2005 05:44 AM
by rKp Go to last post
2 124
The Recordset is Not Updateable by Paul
Help! For some reason one of my forms has stopped working in that I can't change any values in the fields The status bar says "The recordset is...
September 7th, 2005 11:38 AM
by Paul Go to last post
0 110
Datatype error by XP
I am using Office 2003 on Windows XP. I am trying to run a make table query against an Oracle DB into Access. The following line is causing the...
September 7th, 2005 01:05 PM
by XP Go to last post
2 91
Can Someone Help Me Fix My Querry by Aamer
need help to fix the SQL querry. this querry shows perticular inventory of a specified month and year. the result it shows is also correct. but the problem...
September 7th, 2005 01:32 PM
by Michel Walsh Go to last post
1 122
Query and count by Minnow
Bellow is my query. It gives me the result it is supposed to give me which is each customer has 7 records because I have 7 months in the system. But when...
September 7th, 2005 01:57 PM
by Jeff Boyce Go to last post
6 108
Help - Query must have at least one destination field by Suraj
Hello, I have a table with 181 fields and I have the following select query: "Select * from Table1 where = and =;" This query works fine for sometime and then...
September 7th, 2005 02:36 PM
by Suraj Go to last post
2 105
How do I not carry over parameters from query to query? by Karin S
I have a parameter query "Cost by Style" that works wonderfully ..... I have another query I have based off of the one above "Total Cost by Piece" (because...
September 7th, 2005 03:19 PM
by Karin S Go to last post
2 235
How do I NOT carry over parameters from query to query? by Karin S
Hello all :) I have read thru almost ALL of these postings and I can't find my answer though many have been helpful anyway. Thank you. I am developing one...
September 7th, 2005 03:23 PM
by Rick B Go to last post
3 98
Literal Columnheaders in crosstable query by Allen Browne
That is correct. JET (the data engine in Access) is case insensitive. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users -...
September 7th, 2005 03:43 PM
by Allen Browne Go to last post
1 102
Use of Distinct? by wgoldfarb
I have a Query created with the Access Query designer. What I am trying to do is the following: I have a table of 'leads', consisting of information including...
September 7th, 2005 03:54 PM
by wgoldfarb Go to last post
3 140
update query from command button on form by Mike
Hi all, I have an update query that runs fine when I go to queries and select it but when I reference it from the form that provides the criteria, it...
September 7th, 2005 04:35 PM
by Mike Go to last post
7 130
Summing a sum2:David S by Stephanie
Hi, David! Hope you found this continuation post and have time to play... I'm still loving the PrimaryFamilyMember method. So, I think the next step (big...
September 7th, 2005 04:40 PM
by Stephanie Go to last post
9 184
major query issues by Jason
Hi everyone, I am having quite a time trying to create a query that returns what I am looking for. Here’s the set up Employee Table Skill 1 Skill 2 Skill...
September 7th, 2005 05:02 PM
by Jason Go to last post
3 138
Need to write a query by tamxwell
I have two tables, one the main table "AR Details" has all invoice records with all the dollar amount, the second table "Nameaddress" has just customer names,...
September 7th, 2005 05:13 PM
by Chaim Go to last post
5 141
pro-rata figures don't equal original total by Dave
I am trying to create a query that allocates values on a pro-rata basis. However the results never add up to the original value. For instance, 85MM is...
September 7th, 2005 05:23 PM
by John Vinson Go to last post
1 129
Crosstab Query / Column Headers by Jeff Schneider
I have a database that logs issues. The crosstab query shows the volume of issues by age (in days). Sample result looks like this: IssueType 1 2 4 6...
September 7th, 2005 05:30 PM
by Jeff Schneider Go to last post
2 132
Listing birthdays - best method? by Aaron G
Hi all, Access 2003 - I'm trying to get a list of birthdays grouped by month. My db has "Clients" and "Spouses". I create a query for each of them filtering...
September 7th, 2005 06:35 PM
by Aaron G Go to last post
2 122
Post New Thread


Display Options
Showing threads 9821 to 9840 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 06:54 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.