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
Translate if statement in query by KARL DEWEY
The query has table twice, with second instance having suffix _1 to appear as and they both check for nulls. The same could be accomplished like this -- New...
May 27th, 2010 09:48 PM
by KARL DEWEY Go to last post
2 189
Joins on NULL Date values by KARL DEWEY
You can use a LEFT JOIN from Table1 to Table2 if Table1 always has a date or the reverse if Table2 always has a date. -- Build a little, test a...
May 27th, 2010 09:40 PM
by KARL DEWEY Go to last post
0 259
unique records Access 2003 by Jerry Whittle
SELECT valveID, Max() FROM YourTable GROUP BY valveID ORDER BY valveID; If you have a duplicate valveID/Mas of Date combos, it will return all ties. You...
May 27th, 2010 09:34 PM
by Jerry Whittle Go to last post
1 271
How to Union Crosstabs... by dtoney
I've been reading many posts but still trying to comprehend the union of crosstab queries. I need to take the weekly count of estimates that take under 4...
May 27th, 2010 09:33 PM
by Jerry Whittle Go to last post
1 202
union query without "blank" recordsl by Mark Kubicki
I have a union query between 2 related tables, and where they may be records in one table with no value in the other . I've got this (below) query written,...
May 27th, 2010 09:19 PM
by KARL DEWEY Go to last post
4 562
Translate if statement in query by Jazz
Thank you for the feedback; I appreciate your help and the suggested modifications, they are much better. I still have some questions that I need help...
May 27th, 2010 09:06 PM
by Jazz Go to last post
0 223
Update Query not updating selected table by MKuria
Thanks Daryl, I changed the SQL and it works. -- mmk "Daryl S" wrote: MKuria -
May 27th, 2010 08:56 PM
by MKuria Go to last post
0 289
Retrieve all record if check box = 0 (Not checked) by KARL DEWEY
Try this -- SELECT tblSite.Site, tblSite.Lab FROM tblSite WHERE tblSite.Lab = IIF(!! = 0, Between -1 AND 0, -1); -- Build a little, test a little.
May 27th, 2010 08:53 PM
by KARL DEWEY Go to last post
0 249
Criteria to return all records if selection from form is null by Sue Pari
Hi, I'm trying to pass multiple query criteria from form controls. I'm using the following type of syntax for the criteria: Like Nz(!!,"*") And this works...
May 27th, 2010 08:51 PM
by Sue Pari Go to last post
4 792
Single Query for Top 10 of Multiple Items by Joe Murphy[_5_]
Greetings, I'm going to confess right up front that I'm an Access noob, so there is a great possibility that what I'm asking is basic and that I just don't...
May 27th, 2010 07:32 PM
by KenSheridan via AccessMonster.com Go to last post
2 246
The Microsoft Jet database engine does not recognise... by SamMexico via AccessMonster.com
Hi everyone, I've been helped out on here and managed to get a query working exactly how I wanted although now I can't seem to generate a chart from said...
May 27th, 2010 02:49 PM
by John Spencer Go to last post
4 289
Undefined function 'Left' in expression by The Joker via AccessMonster.com
Hello all, First off I want to say I read a lot of the previous posts about this issue and none seem to be similar to mine. I am working on a database...
(Multi-page thread 1 2)
May 26th, 2010 09:54 PM
by Bob Barrows Go to last post
11 795
Shift several columns in table by Hans[_7_]
Hi! Say you have a table A with fields field1, field2, field3 and field4 and I want to shift values so field1 receives the value from field2, field2...
May 26th, 2010 05:47 PM
by Bob Barrows Go to last post
4 389
Convert string value to numeric value by alhotch
I saw a post that showed how to convert from a number value to a string value. But how about the other way ? Convert a string value to a number...
May 26th, 2010 01:47 PM
by John Spencer Go to last post
3 227
Descision based on a query by poorboy13 via AccessMonster.com
Hello, I'm hoping this should be easy - I just can't seem to find the answer. I'm guessing my syntax is wrong but I can not figure it out. I am making a Db for...
May 26th, 2010 01:17 PM
by poorboy13 via AccessMonster.com Go to last post
4 269
adding a Carriage Return or Line Feed character to an update query by Paul
I'm building an update query that will concatenate two fields and update the first field with the combination of the two fields. However, I would like to...
May 26th, 2010 01:37 AM
by Paul Go to last post
3 310
Merging Query results into Word document by Used to Know Access[_2_]
I have Word forms to send tailor for each client I mail to. The forms are requesting specific information regarding employees. To that end, I am providing...
May 25th, 2010 09:20 PM
by PieterLinden via AccessMonster.com Go to last post
1 251
Parameter in Union Query by Jill
I inherited about ten databases, Year2001, Year2002, etc. These databases are not related, even though they have information about same ID's (For example, ID...
May 25th, 2010 08:08 PM
by John Spencer Go to last post
1 193
Union Query with two crosstabs by AccessKay
Hi…I attempted to do a Union Query with two crosstabs. I received an error “Characters found after end of SQL statement. I then read some posts but...
May 25th, 2010 07:19 PM
by AccessKay Go to last post
2 204
Merging query fields into Word document by Used to Know Access
I'm trying to fill out some forms with fields from a query. The forms are built in MS Word. So far all I get is inserted lists into the form but the fields...
May 25th, 2010 05:56 PM
by PieterLinden via AccessMonster.com Go to last post
1 316
Post New Thread


Display Options
Showing threads 101 to 120 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 08:28 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 OfficeFrustration.
The comments are property of their posters.