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
My criteria doesn't work. by Lydia
Hi, What is wrong with both of following criteria: This one, Access tells me "The expression is to complex..." iif(forms!frmProduct!cmbPL="Totals", Is Null ,...
July 1st, 2008 04:55 PM
by Lydia Go to last post
7 194
calculation of difference using different fields depending on prod by sverre
Hi I have a problem with calculating differences in queries. I need to use different fields in my calculation depending on what product I do the calculation...
July 1st, 2008 04:06 PM
by [email protected] Go to last post
1 161
parameter query by [email protected]
I know how to create a parameter query. What I'd like to do is run a parameter query that displays many child records of one parent record that permits...
(Multi-page thread 1 2)
July 1st, 2008 03:45 PM
by [email protected] Go to last post
13 293
Easy query criteria question by Bongard
For some reason I can't figure this out. I have two fields in my query (relevant for this question). (numeric field) and (text). I need my criteria to say...
July 1st, 2008 02:50 PM
by Bongard Go to last post
3 159
using query returns to create new columns by TaniaD
Hi, I'm working on a project that requires something I'm sure can be accomplished with SQL, but I can't figure it out myself. Basically I have a list of...
July 1st, 2008 02:45 PM
by John Spencer Go to last post
8 226
Print Query Expressions by Regi
I'd like to print the expressions I have set up in a query. I know I can do it via print screen and I can get the SQL view through Access Document veiwer but...
July 1st, 2008 01:43 PM
by Regi Go to last post
0 126
delete duplicates by Darren
I have one table (table 1) with a column A & B and another table (table 2) with columns C & D. Now there are duplicates in table 2 on the values in column C....
July 1st, 2008 01:35 PM
by Allen Browne Go to last post
1 148
Different results in SQL and Access by Pat Backowski
Hi Everyone, When I run the query Select a,b,c from mytable where trandate = #20/06/2008 00:00:01# and trandate = #20/06/2008 23:59:59# and (trantype =...
(Multi-page thread 1 2)
July 1st, 2008 12:57 PM
by Bob Barrows [MVP] Go to last post
17 515
Queries without duplicates by puppypaws
I'm working with a huge imported database from which I needa query with employee id, last name, first name, benefit name employee cost and employer cost. I...
July 1st, 2008 05:12 AM
by Christopher Robin Go to last post
5 182
Make table query combining records of two tables into a third tabl by carl jordan[_2_]
I thought I posted this yesterday, but somehow it did not get into the forum. I apologize if it is there and I just cannot find it, and this is ends up as a...
July 1st, 2008 04:03 AM
by carl jordan[_2_] Go to last post
2 169
Selecting and counting records in one query by Peter
Hi there. I have a table with relatively simple data. If I build a query where the criteria uses the Like "*" & & "*" expression, it works fine and...
July 1st, 2008 12:00 AM
by Bob Barrows [MVP] Go to last post
3 160
Query with IF statements and lookups by MichaelR
Hi, I'm trying to write a query and I'm not sure if it's even possible. I have two tables - one with sales data for the whole company and the other with...
June 30th, 2008 11:26 PM
by MichaelR Go to last post
2 155
One Command Button for different reports by Francis Cunningham, Jr.
I am not sure if I am in the right Discussion Group, so here it is... I have five different queries called ‘Cooling, Electric, Gas, Heat Pump and Oil’ I...
June 30th, 2008 10:58 PM
by [email protected] Go to last post
1 149
Group By Qtr by acss
I cant figure out how to group my records by quarters or months.Is there a special query to otain these results? My current SQL is pretty basic using two...
June 30th, 2008 09:54 PM
by KARL DEWEY Go to last post
2 153
DSUM Syntax Error by NeoFax
I am getting the following suntax error: "Syntax error in string in query expression '=6'""(second quote is not in the error screen). Here is my DSum...
June 30th, 2008 08:49 PM
by NeoFax Go to last post
1 137
Average Records between date range by Love Buzz
Hi all. I am trying to average the total records by date range. I am getting an error message with my AVG expression. Here is a snap shot of the SQL I have...
(Multi-page thread 1 2)
June 30th, 2008 08:17 PM
by Michel Walsh Go to last post
12 373
SQL Statement by Joe Gonzalez
I have a table of just months and years for example: 2008-01 2008-02 2008-03 2008-04 2008-05 2008-06 And I have another table that is storing data that...
June 30th, 2008 06:18 PM
by Joe Gonzalez Go to last post
2 165
Query for two fields in one record that do not match by Linda Lou
I am trying to create a query that will show me all of the records in a table where two fields in the record do not match, basically the opposite of a find...
June 30th, 2008 06:06 PM
by Linda Lou[_2_] Go to last post
3 133
Using SELECT DISTINCT by Leslie Isaacs[_2_]
Hello All I have a table , and 2 of the fields are 'practice' and 'month name'. This table contains typically between 10 and 50 records for each combination...
June 30th, 2008 05:24 PM
by John Spencer Go to last post
9 173
Duplicating values to empty field by DanBakerUSAF
I am new to SQL in queries. I can ussually get what I want with forms and the query wizard. This I cannot figure out and it seems like a SQL statement...
June 30th, 2008 05:07 PM
by John Spencer Go to last post
6 161
Post New Thread


Display Options
Showing threads 10141 to 10160 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 01:44 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.