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
Query modification by CurtH
I have the current query which works: Dental Status: IIf( ="9","90 Days or Before DentalDue Notification",IIf(="12","Annual Dental Exam...
February 13th, 2007 06:28 PM
by Jason Lepack Go to last post
3 218
Query to look up value from other field by Diggsy
Hello, I am currently working on a query that looks up a specific field based on my hardcoded input. I have 52 fields in a table named Forecasts The fields...
February 13th, 2007 06:22 PM
by Duane Hookom Go to last post
1 124
Nested IIF by scubadiver
Hi folks! I have a currency field in a query (called "ave1") and I want to create a classification field based on the following so the new field should...
February 13th, 2007 06:11 PM
by Jerry Whittle Go to last post
6 173
Embedded Image (sizing) by stephanie
Hello. I have a form with an embedded picture. All is well. But I'm curious how to best size the embedded picture frame so that downloads from a digital...
February 13th, 2007 05:43 PM
by stephanie Go to last post
1 120
Attaching picture (sizing) by stephanie
Hello. I have a form with an embedded picture. All is well. But I'm curious how to best size the picture so that downloads from a digital camera will fit. ...
February 13th, 2007 05:40 PM
by stephanie Go to last post
1 150
Showing a query output after form text box update by Iowa Joe
I have a form which is used to release specific items from hold in a manufacturing setting. I have a table for the holds and a table for the releases. The...
February 13th, 2007 05:21 PM
by Iowa Joe Go to last post
1 142
UTC Time zone and Now() function by Tech Geek 1234
I have a database in which all date and time fields will be entered in UTC time. I need a query to give me records from the past 30 days. I am currently...
February 13th, 2007 04:26 PM
by raskew via AccessMonster.com Go to last post
1 147
Crosstab Query by MPM1100
I would like to enhance a crosstab query I am working with. First, I have a tabe of transactions. Each transaction has a date, a trans type, and an amount....
February 13th, 2007 04:07 PM
by MPM1100 Go to last post
0 176
Insert Into syntax help by XP
Using Office 2003 and Windows XP; Can someone please help me clear the syntax error I'm getting from this SQL?: INSERT INTO Table1 AS A SELECT...
February 13th, 2007 02:50 PM
by XP Go to last post
2 156
Delete Query by CoachBarkerOJPW
Let's try this. I have a registration data base for a youth sport program (thanks to a lot of useful advice from the people in here). A youth can be enrolled...
February 13th, 2007 02:37 PM
by John Spencer Go to last post
5 165
Relationships by Matt Dawson
Is it possible to create a like relationship? I have two tables but one contains variations on the other ie setup per machine and are called different...
(Multi-page thread 1 2)
February 13th, 2007 01:46 PM
by John Spencer Go to last post
11 213
Broken Query (can't open or edit) by Engels
I have a Select query which is acting realy strange. it'll run through a form and it'll print straight from the Database Window It wont however either open...
February 13th, 2007 01:06 PM
by Engels Go to last post
1 151
criteria from form not working by franklinbukoski
The following is a sql view of my query: SELECT Subtopics.Subtopics FROM INNER JOIN Subtopics ON . = Subtopics. WHERE (((.Topic)=!!)); when I click on an...
February 13th, 2007 11:55 AM
by franklinbukoski Go to last post
3 147
Access to access via Net by Matti Koski
Hi, I would like to study of how to make an easy user interface via Net to Access database. Please give your recommendation. Matti
February 13th, 2007 11:00 AM
by Matti Koski Go to last post
0 115
Make Crosstab Query Display All Event Types even if Event Type not chosen by any participant by Kay
Hello - I have my database all worked out and I am totally excited....just one more thing. My crosstab query sums up the number of event types (eventtypeID)...
February 13th, 2007 10:26 AM
by Gary Walter Go to last post
4 175
GETTING THE MOST RECENT DATE by bifteki via AccessMonster.com
There's a table called tbl_contacts and each contact is related to a company from the table tbl_companies. I want to get the most recent contact from...
February 13th, 2007 08:30 AM
by bifteki via AccessMonster.com Go to last post
6 179
Showing Crosstab Totals Column in Chart by ALEX
I have the following crosstab query. I'd like to be able to put the Total Of Amount on the secondary axis, but I can't figure out how. I appreciate your...
February 13th, 2007 04:51 AM
by Duane Hookom Go to last post
1 116
Sum on totals by date with 1's and 0's by efandango
My table looks like this: TestDate Tempscore 23/01/2007 1 23/01/2007 0 26/01/2007 1 26/01/2007 1 29/01/2007 1 29/01/2007 1 01/02/2007 0
February 13th, 2007 02:18 AM
by efandango Go to last post
4 122
grouping by Joel Allen
Hello, I have a table with fields like this: Store location, quanity of red apples, quantity of green apples. e.g. Redmond,26,40
February 13th, 2007 01:51 AM
by Jeff Boyce Go to last post
3 149
Updating Fields with one charachter to another by Craig
I have 75 fields in a database that are all marked with either 'A', 'B' or 'C' or blank. I want to change all populated fields to a 'Y' so that I can see...
February 13th, 2007 12:14 AM
by John W. Vinson Go to last post
1 172
Post New Thread


Display Options
Showing threads 20181 to 20200 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 03:22 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.