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
IF statement by Florida Analyst
I'm not the best with SQL for Access however I want to create an IF THEN Scenario, this is how I would write it in the SQL I know (I mostly use SAS): (CASE...
July 8th, 2008 08:10 PM
by John Spencer Go to last post
7 176
Query one table against part of a cell of another by apex77
How do I create a query that matches the records in one (tblLocationsInFtWorth) table based on part of the City field in another (tblCities)? Example: table...
July 8th, 2008 07:58 PM
by Michel Walsh[_2_] Go to last post
3 175
Formulas by Devan
I need alot of help. I am new to the access software and I am trying to create a database. I need a formula from excel to work in access....
July 8th, 2008 07:56 PM
by Bob Barrows [MVP] Go to last post
8 212
Query as data source for form by News Boy
I have data in 3 tables called Carriers, Routes, and Subs. I can make a form display data from one table at a time. But, to access multiple tables, a query...
(Multi-page thread 1 2)
July 8th, 2008 07:29 PM
by Jeff Boyce Go to last post
11 374
using the Or criteria by Barbara
I have a query that in addition to the name and address fields has 4 fields named using iif statements. I need criteria to select names based on a "Yes"...
July 8th, 2008 07:28 PM
by Klatuu Go to last post
2 164
How do I build a countif expression in Access by Angela
I want to build a countif expression in a query. I basically want to count off another query but only if a field in another table is null.
July 8th, 2008 07:22 PM
by Ryan Go to last post
4 310
Stuck on a date issue by Sue
Hi all, and thanks in advance. I have dates entered in mm/dd/yyyy format but want to sort disregarding the year... in other words, the following fields would...
July 8th, 2008 07:17 PM
by Ryan Go to last post
7 208
Union Query to a Table by miss_mas
I created a union query. How do I get the output to go to a new table? Do I have to CREATE TABLE then use all the INSERT INTO functions or is there an easier...
July 8th, 2008 05:21 PM
by miss_mas Go to last post
3 173
Using DLOOKUP with totals (aggregate) queries? by Dominic Greco via AccessMonster.com
I have an totals/aggregate query that looks at a table and returns the total estimated structural engineering hours. I need to convert that SQL code to...
July 8th, 2008 04:10 PM
by Dominic Greco via AccessMonster.com Go to last post
2 454
Next item in line by OEB
I am not sure how to really explain this, but here is what I need. I have a list of items that are in chronological order listing the stages a project goes...
July 8th, 2008 03:20 PM
by Allen Browne Go to last post
3 267
Outer Join Question - "join expression not supported" by Raven[_3_]
Hi, I am trying to narrow down an outer join, the problem is when I add the condition (compares char field to fixed text) to the where clause I get no results...
July 8th, 2008 03:15 PM
by Michel Walsh[_2_] Go to last post
1 189
Duplicate values by Nuno Gomes
Hello, all I have a table that have +/- 40000 records of duplicate entries. I know i need the record more recent of the duplicates (i have the field DATA_V...
July 8th, 2008 03:05 PM
by Michel Walsh[_2_] Go to last post
2 150
Access: problem with outer join - "Join Expression not Supported" by Axel
Hi, I am trying to narrow down an outer join, the problem is when I add the condition (compares char field to fixed text) to the where clause I get no results...
July 8th, 2008 02:04 PM
by Michel Walsh Go to last post
1 207
filtering in queries by NES
I have a table with a field that is to be formatted as "99999-9999-999" where the N stands for a digit: 5 digits, dash, 4 digits, dash 3 digits. I have...
July 8th, 2008 01:24 PM
by bhicks11 via AccessMonster.com Go to last post
3 168
SQL WHERE = Query Results by auujxa2 via AccessMonster.com
This is in conjunction with my previous thread. I'll try and simplify my request. How do I write this SQL: " WHERE = .... The values from !? Thank you in...
July 8th, 2008 12:15 PM
by John Spencer Go to last post
6 175
Nested IIf: Define ranges, = And =? by CanonMaiden
I'm trying to create a commission rate by defining several ranges based on the Sale_Price field's value. I am creating a calculated field in a query with the...
July 8th, 2008 10:37 AM
by CanonMaiden Go to last post
2 132
* Free Library management & membership software * by B1SL[_2_]
We are offering our Microsoft Access Library management & membership database 'LIBRARY SOLUTIONS' FREE of charge. To download, please visit our website...
July 8th, 2008 10:30 AM
by B1SL[_2_] Go to last post
0 131
Left Join Question by Grace
I use Access 2003 and a database with the following tables Table named Employees with the following fields: Payroll ID (this is not an AutoNumber field),...
July 8th, 2008 03:26 AM
by Grace Go to last post
2 148
Limiting A Query by Using a text format by Brad[_6_]
All, I have a License_Text_ ID field with several different types of license formats. I would like to limit a query to only returning IDs with a format of...
July 8th, 2008 03:16 AM
by Brad[_6_] Go to last post
2 132
No Value returning from query by Brennan
I have a query that sums a particular field as part of the query. Sometimes there is not any data to sum and so no value is returned in the sum line. Is...
July 8th, 2008 12:23 AM
by John Spencer Go to last post
3 161
Post New Thread


Display Options
Showing threads 10041 to 10060 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:11 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.