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
Adding the value of two fields when value is null by Laura
I am working in a query. I would like to add the value of two fields (OT and DT) together in a third field. However, sometimes the value of one field is...
December 23rd, 2009 03:58 PM
by Laura Go to last post
4 248
Question about query optimization by Sunil Somani[_2_]
Hi All, i have one query in ms access Database 2002. which is like: select distinct ( Field1) from table1 where Field1 not in ( select Field1 from table2)...
December 23rd, 2009 03:53 PM
by Jerry Whittle Go to last post
3 297
how to get last records out of 4 records per customer? by mls via AccessMonster.com
I am having 4 records for each customer with different dates, so how can I get the last records for this customer. I also want to see 4 other fields in my...
(Multi-page thread 1 2)
December 23rd, 2009 03:50 PM
by mls via AccessMonster.com Go to last post
17 411
Access Query by Tim Arrington
Hello... I have a database with data that looks like this: ID_NUM STATUS 12345 O 12345 O 54321 C 54321 O 54321 O 67891 ...
December 23rd, 2009 03:48 PM
by Marshall Barton Go to last post
3 196
subquery by Kou Vang
How can I write a subquery within a query from: Lake, Site, PersonID 01, 101, 0001 01, 101, 0001 01, 101, 0001 01, 101, 0002 01, 101, 0002 01, 101, 0003 01,...
December 23rd, 2009 03:22 PM
by John Spencer Go to last post
2 178
One Query as datasource?? by hshepardjr
I have three different tables that cannot be combined using a Union query due to efficiency. I would like to use a form to select the table or query to use...
December 23rd, 2009 11:44 AM
by vanderghast Go to last post
7 175
Joining IIF statements together by Sue Compelling
Hi I have the following two IIF statements which give the right results when used separately but I need to join them together so Access is assessing all...
December 23rd, 2009 05:58 AM
by Sue Compelling Go to last post
2 168
Looking up across date ranges in Access by Pete
I am mapping financial data from one system to another and need to look up in a query a dept based on a date range. tblDeptMap reads Dept FromDate To...
December 23rd, 2009 12:13 AM
by Pete Go to last post
2 411
Group by Range in Crosstab Query by Chris
I have created a crosstab query which displays the number of days from referral to consult. I want to groups the days into ranges (0-14 days); (15-21...
December 22nd, 2009 07:17 PM
by KARL DEWEY Go to last post
5 289
Summing multiple fields by gator
I need to SUM multiple field values in a row. I know how to set it up in the Query design using a calculated field and I realize Excel does this. The...
December 22nd, 2009 06:10 PM
by Jerry Whittle Go to last post
2 189
Does not include the specified expression as part of an aggregatefunction by Beejer
Running Access 2003 on Windows XP I'm starting a new structure parallel to a current database. The table are fully linked (no local tables) and I'm trying to...
December 22nd, 2009 04:38 PM
by Jerry Whittle Go to last post
2 244
Sorting Xtab Column Headings by croy
For this SQL: TRANSFORM Sum(Final.SumOfMonthlySppeffort) AS SumOfEffort SELECT Final.Months FROM Final GROUP BY Final.Months, Final.Years, Final.Months ORDER...
December 22nd, 2009 04:11 PM
by croy Go to last post
4 221
passing a parameter based on multiple selections by javablood
Hi, I have a form in which several choices are selected, one of which is a list box in which the user can make multiple selections. I followed the various...
December 22nd, 2009 03:57 PM
by vanderghast Go to last post
7 195
Passing criteria to queries from forms by Neil Beddell
I am putting together a database to record telephone surveys for a number of companies within a parent group. Each survey is allocated to the specific group...
December 22nd, 2009 12:51 PM
by Neil Beddell Go to last post
2 210
Query criteria in a memo field by Gamefewel
I have a notes field that is a memo field type. I am needing to do a query of the field and can't figure out how to do it. The field is a multivalued...
December 22nd, 2009 05:34 AM
by Gina Whipp Go to last post
1 179
date selections from one table to another by Schon
Is there a way I can have table1 with only 2 fields (Begin Date) and (End Date) and have a query that asks for all the records from table2 where field (Date...
December 22nd, 2009 01:00 AM
by Duane Hookom Go to last post
1 184
Adding Fields together.. by Breecy via AccessMonster.com
Guys this is probably really simple, but I can't see what I am doing wrong. This is all done in the query view in MS Access '02. I am trying to add together...
(Multi-page thread 1 2)
December 22nd, 2009 12:30 AM
by Breecy via AccessMonster.com Go to last post
12 318
Next in alphabet by accesskastle
Hi. I would like to create a loop to update some fields in a table. What I'd like is update one field in a table based on another. I want it to happen like...
December 22nd, 2009 12:26 AM
by accesskastle Go to last post
4 205
Removing empty space character in cell by Booth
I've got empty space in my records (ie "abcd ', "efgh " etc) I have tried to use the find and replace but this is not working I have also attempted to run an...
December 21st, 2009 09:13 PM
by John Spencer Go to last post
5 294
Between dates by Chi
Hi Would you please show me how to make a query that would list all the dates occurring between two days, including Beginning Date and Eding Date? Ex:...
December 21st, 2009 08:46 PM
by Chi Go to last post
7 214
Post New Thread


Display Options
Showing threads 1861 to 1880 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 10:10 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.