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 Replies Reverse Sort Order Views
help in calculation by sheela
Hi I need help in some calculation. It is easy in Excel, which I used to do. I have a table with multiple fields including stimulation (text), replication...
January 19th, 2006 10:47 PM
by sheela Go to last post
4 342
Update Query changing text to number by shark1966
I am running an update query that is updating text to CLng. I receive a message that all the records weren't updated due to a type conversion failure. All of...
January 17th, 2006 12:27 AM
by Van T. Dinh Go to last post
4 87
Ouerie Year(Now())-1 Or Year(Now()) by [email protected]
Hej! Har en fråga, har en querie där jag skrivit i criteria Year(Now())-1 Or Year(Now()). När jag kör frågan får jag upp info om en medlem för året 2006 och...
January 19th, 2006 09:00 PM
by [email protected] Go to last post
4 100
Multiple parameters by LizJ
Can someone help. I need to retrieve peolple's addresses from a table. The only criteria I can use to identify these people is their ID number (an auto number...
January 18th, 2006 04:26 PM
by Duane Hookom Go to last post
4 116
Altering fields in a query by Mark Olsen
Hi, I have a question that I really have no idea how to resolve. I am working on a database that I have read-only access to. The problem is is that I...
January 19th, 2006 02:05 PM
by Mark Olsen Go to last post
4 112
Table or Query information by James McDowell
I would like to know of a query that will tell me the type of each query within a database, AND what tables/fileds it updates/makes. OR query each table within...
January 19th, 2006 09:49 AM
by Mike Go to last post
4 157
Exporting Delimited Files by Stryker22150
When exporting a query in delimited format with null values the data is pushed to the left. I need to be able to maintain consistency. I have discovered I can...
January 19th, 2006 01:44 AM
by Stryker22150 Go to last post
4 136
How To Write Query by Martin
FieldX in some records in TblData contains a value while in other records it is null. How can the query be written which gets the criteria for FieldX...
January 19th, 2006 04:09 AM
by Martin Go to last post
4 124
Help with time difference query by red skelton via AccessMonster.com
Hi everyone, Can anyone help me? I have a query that is giving me a problem and I cant figure out why. I am using the same DateDiff format three times in the...
January 20th, 2006 12:54 PM
by red skelton via AccessMonster.com Go to last post
4 207
Need an Access Programmer to complete database queries (simple). Will compensate accordingly. by [email protected]
I have been working on an Access project but I don't have the experience to be able to create the functionality I need in such a short amount of time (by...
January 17th, 2006 11:00 AM
by Arno R Go to last post
4 104
QUERY DATE RANGE by hotrod1952
I AM A NEWBIE: I am writing a query in Access97 to pull data in between two dates. The expression I am using is: Between And in the critera field. The...
January 14th, 2006 10:50 PM
by hotrod1952 via AccessMonster.com Go to last post
4 108
Querying by Primary Key SSN with Count by Wendy Lee
I have created a form keeping track of "Clients", primary keyed by SSN. Another form was created to keep track of "Client Cases" each time a client comes in...
January 19th, 2006 06:36 PM
by Wendy Lee Go to last post
4 169
Ranking by DDR
How do you write an expression or SQL statement that will rank data. I have employees that make calls that I log in your database. I have a rank number that...
January 15th, 2006 04:44 AM
by Tom Ellison Go to last post
4 91
Using Access Query in similar fashion of a vlookup function by Scott
I have tried to used the IIF then statement to do this but too many nests have forced me to rethink. Is there another function I should look at for this...
January 13th, 2006 05:00 PM
by LeAnne Go to last post
4 147
Multiple IIF Statements by Susan
I have several checkbox fields in a query. I want the checkboxes, "if= -1" to show in another field on the query, the checkbox fields will not show. I have...
January 13th, 2006 08:38 PM
by John Spencer Go to last post
4 126
Group By, Count, and Like by LFNFan
Hi I have a table containing a Voucher_Number field and a Status field. The Status field data type is text, and records contain values: Used, Expired, Void,...
January 13th, 2006 08:41 PM
by John Spencer Go to last post
4 71
Date Querry by jb ellis
My db has a birthday field in short date format (mm/dd/yyyy). How do I querry for all birthdays in say Jan, regardless of day or year?
January 13th, 2006 11:00 PM
by jb ellis Go to last post
4 140
Make Table Query is converting currency field to a number in the t by Curt Johnson
I have a make table query that is performing many cost currency calculations. When you run the query as a SELECT query all of the calculations come out...
January 16th, 2006 06:40 PM
by OfficeDev18 via AccessMonster.com Go to last post
4 130
Append Query by Chey
I have three tables Provider info Provider Monthly Info Months I need to take all 12 months and append them to every provider in provider info, but I need the...
January 17th, 2006 07:04 PM
by Vincent Johns Go to last post
4 101
Select Case in Query? by Sandra Grawunder
I have a rather complex series of calculations I have to do on a field in a query for a silent auction. For instance: To calc the new field StartBid: If is 0...
January 20th, 2006 03:27 PM
by Sandra Grawunder Go to last post
4 178
Post New Thread


Display Options
Showing threads 10001 to 10020 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:57 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.