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
Problem with Expression by Rene
Good afternoon, I have a parent form with 2 list boxes and 2 text boxes that supply information to an expression located within a calculated control in a...
November 10th, 2009 05:00 PM
by Rene Go to last post
2 151
Subquery help by FBxiii
Hi. I am trying to run a query, but am getting a 'At most one record can be returned by this subquery' error. I have used subqueries before but have never...
November 10th, 2009 03:45 PM
by Jerry Whittle Go to last post
7 170
select distinct fulladdress by lmv
I need to select distinct on the fulladdress and I can't remember how to do it. I only want 1 of each distinct address in my list. help PLEASE! ;} SELECT...
November 10th, 2009 03:41 PM
by John Spencer Go to last post
2 145
Query Service History/Future Dates by Coyote_Jackson
Trying to setup a query which takes into account a list of cars using reg numbers: 1 ---- 2 ---- 3 ---- 4 ---- 5------ up to 100+ cars
November 10th, 2009 09:47 AM
by Coyote_Jackson Go to last post
0 130
find who the driver is by Dale G[_2_]
Hi, I’m trying to identify a route driver based on the route number the location & the time the route was at the location. I have many routes with the same...
November 10th, 2009 06:48 AM
by John_G via AccessMonster.com Go to last post
1 186
Multiple IIF In Query by Mark Gregory
I'm sure there is a simple solution to this, I have tried some other solututions to no effect. I have a query field where the data will only be Gold, Silver...
November 10th, 2009 06:43 AM
by John W. Vinson Go to last post
3 136
SQL Server SQL to Access 2003 by Geossl
The following query is for SQL Server. How to convert this to Access 2003 SQL? SELECT Organization.Name, Organization.Id AS OrganizationID, Item.Id as...
November 10th, 2009 04:16 AM
by Geossl Go to last post
4 145
Create update query for remaining records by accesshacker
Need to create an update query that will add records to a table that when summarized equals the amounts in another table when compared. I know how many units...
(Multi-page thread 1 2)
November 10th, 2009 01:17 AM
by accesshacker Go to last post
11 316
Trying not to run multiple queries by Tamara
Hello, I have a query where I select the items in our property room on a specific day by using the criteria =Date AND =Date or Is Null. I then have...
November 10th, 2009 12:38 AM
by Tamara Go to last post
4 160
Select row by ID to nearest date, future (or past if no future dat by Trexner
Hello all, I have a table in a database named "tm_tasks" that contains records of tasks to be carried out on a case. The end user enters the tasks from a...
November 9th, 2009 10:44 PM
by Jason Hoag[_2_] Go to last post
4 161
Remove all characters after "hyphen" in field by sonofroy
I have field in a query that values are in two parts example location name 1 - material type location name 2 - material type location name 3 - material...
November 9th, 2009 10:35 PM
by Krzysztof Naworyta Go to last post
3 134
query result in text box by Jeannine
Hi, I am creating a database that is designed to perform calculations on data that is input daily. I have made a form on which to input the data and there...
November 9th, 2009 09:25 PM
by Dale Fye Go to last post
2 123
Append record with Yes/No by Nick
I have some records that occasionally need to have fields updated that change the field it is looking and also the clear another field. I am sure it is an...
November 9th, 2009 08:59 PM
by vanderghast Go to last post
1 121
separate field by Jennifer
I have a field which contains first and last name. I want to convert it to an email address. For example: Bob Jones I want to have
November 9th, 2009 08:30 PM
by kc-mass Go to last post
2 124
Inverted Query by thrusty
Can't seem to figure this one out...has to be simple though. I have a database of employee's training records. I need to find those employees who have not...
November 9th, 2009 08:03 PM
by Marshall Barton Go to last post
2 132
iif statement by jligue
I am new to access; trying to create a query for a report that has a subtotal, the field will only total if a portion of a word appears in a combo box...
November 9th, 2009 07:14 PM
by John Spencer Go to last post
1 117
Custom Counter Question (Repost) by AccessIM
Hello Everyone - I haven't received a response back to one of my posts so I am re-posting with the hope that someone will pick up the new post. I have...
November 9th, 2009 06:41 PM
by AccessIM Go to last post
4 178
Querying Numbers - Field Size = "Double" by Ken Valenti
I have a table that has the ID set as Number with field size Double (It's the Key, required no duplicates). I have two pieces of data 1492 (Some...
November 9th, 2009 06:14 PM
by John W. Vinson Go to last post
2 126
dcount by igg via AccessMonster.com
PatientTable contains thousands of patient records. subform current record selection should for a given clinic ID, update the parent totalpatients text box...
November 9th, 2009 10:36 AM
by Stefan Hoffmann Go to last post
9 164
where clause by Sam
I am trying to view records where the date value of one control equals that of another. The following clause causes an error: WHERE...
November 9th, 2009 04:44 AM
by Duane Hookom Go to last post
3 125
Post New Thread


Display Options
Showing threads 2381 to 2400 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 04:20 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.