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
locating same text in multiple fields by Mike Vet
I have a drug database that has 8 fields for indications. I need to search for the same indication in all 8 fields. Example: Search for "inflammation" in...
January 4th, 2010 09:15 PM
by vanderghast Go to last post
2 192
Query Needed by carl
A sample of my data table looks as so: Underlying ID ...
January 4th, 2010 07:13 PM
by Marshall Barton Go to last post
5 176
MS Access Query by Bawa
Hi I need help with this: COnsider this Data: Description // SW Version // Asset Tag // Machine Name // Name Acrobat Standard// 4 // 12345 // abcde //...
January 4th, 2010 07:08 PM
by B Lynn B Go to last post
4 208
Error in IIf Expression by Pamela
I have an expression in my query to create a concatenated text depending upon the value of control Measurements. If the control is skipped - meaning that...
January 4th, 2010 06:58 PM
by John W. Vinson Go to last post
5 148
Creating an index in a query by michelle
Hello, I'm a beginner, so I don't know if this is possible. I have a query that is pulling data from a read-only table. The two fields that I'm using are a...
January 4th, 2010 05:39 PM
by Jeff Boyce Go to last post
9 226
Group by month by n09
Hey guys, I have a table Table Children which records different vaccinations received (children are identified by a unique ID). I want to create a query that...
January 4th, 2010 05:26 PM
by Duane Hookom Go to last post
2 164
Convert to text by Prohock
I have a query that has one field that combines two other fields. Date Length Combined 12/2/2009 3 Day 12/2/2009 - 3 day I need the...
(Multi-page thread 1 2)
January 4th, 2010 08:18 AM
by Prohock Go to last post
13 266
Converting check box data into useable narrative by Sue Compelling
Hi (Access 2007) I have the following union query (full sql at bottom of question) where the fields Seven, Eight, Nine etc are derived from check boxes in a...
(Multi-page thread 1 2)
January 3rd, 2010 04:30 PM
by KenSheridan via AccessMonster.com Go to last post
11 440
Pivot Table Questions by Jay CFA
In my access pivot table some of the data in the sheet is not visible without scrolling. This is when I am in show detail view. When the row has 10-12 lines...
January 3rd, 2010 05:50 AM
by Jay CFA Go to last post
0 120
Query needed by subs
Table I consignee dcity dstate dzip ocity ostate ozip A d ak 560 b c 789 B e ck 869...
January 3rd, 2010 03:50 AM
by Ram Go to last post
4 169
Week, monthly, quarterly by Ranjith Kurian[_2_]
I have a table called as Task; this table has four columns Name, Task, Frequency and Week. Name: employee name Task: Assigned work to each employee Frequency...
January 3rd, 2010 12:11 AM
by kc-mass Go to last post
2 197
How do I use varibale field names by Greg
I have a table which has a current month info and carries a 12 month rolling history. At the end of each month i must copy the current month's data to the...
January 2nd, 2010 08:25 PM
by John W. Vinson Go to last post
2 129
GANE DINERO VIENDO PUBLICIDAD by robertcaceres6
Hola.. Os voy a contar una forma de ganar fácilmente un dinerillo extra para cualquier capricho o para llegar a fin de mes. Hablo de ganar dinero por Internet...
January 2nd, 2010 05:26 PM
by robertcaceres6 Go to last post
0 119
Using " in a string expresion by Biss
hi... Would like to use " a sting expression.. I have tried """ but doe not work.. This is what I have html: "option value=" & & "" & &...
January 2nd, 2010 03:04 PM
by Biss Go to last post
4 154
How do I count text fields? by TonyWilliams via AccessMonster.com
I have a table which contains a text field where the value can be "PureABL" or "HYBRID" I want to be able to count how many records where the value of the text...
(Multi-page thread 1 2)
January 2nd, 2010 11:03 AM
by TonyWilliams via AccessMonster.com Go to last post
14 216
Switch by shank
Not getting the results I expect from the below Switch Function. Given: ! = -1529 ! = 12261 AOD: Switch(!-!=0,1, (!-!*-1)!,2, ((!-!)*-1)!,3)
January 2nd, 2010 05:31 AM
by Marshall Barton Go to last post
2 166
querying a percentage of table info by Cloudbuster[_2_]
If there are 3 unique groups listed in a table, is there a way I can make a query that will show me the first 20% of records from each group, 2nd 20%,...
January 1st, 2010 06:15 PM
by David F Cox Go to last post
4 163
Update Query: Enter Parameter Value by CC
I'm trying to set a field to a value that is stored in a variable using an update query in VBA (Access 2003). The query prompts the user to enter parameter...
January 1st, 2010 03:08 PM
by Bob Barrows Go to last post
2 182
How do I seperate information using a delimiter by OverMyHead
I have a column titled "Shift Start-End" that has the work start and end time of the employee. The information is formatted as "XX:XX-XX:XX". I need to be...
December 31st, 2009 10:40 PM
by Dorian Go to last post
4 254
HAVING / Where time count / excluding any instance by Rebecca
Greetings this almost New Year's Eve, I have a set of data with open and close dates (for one person). I want to calculate the duration the person was open....
December 31st, 2009 07:46 PM
by KenSheridan via AccessMonster.com Go to last post
1 136
Post New Thread


Display Options
Showing threads 1781 to 1800 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 07:54 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.