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 Between times by anna_717717
Hi all, hope somebody can help I've got two tables. Table 1 has the data against a batch of product, data about the batch test setup and has the test date...
July 10th, 2009 01:58 PM
by John Spencer Go to last post
1 64
Ranking by Bill
I have the following SQL statement that will rank my data. I am trying to perform that ranking within age groups. I cannot get it to work. Can anyone...
July 10th, 2009 01:54 PM
by Bill Go to last post
6 65
Update query help by jenksonu via AccessMonster.com
I'm trying to update all records in one table GCI.EmployeeName to House after I add a check to y/n field in table2 EmployeeInfo UPDATE GCI.EmployeeName to...
July 10th, 2009 10:41 AM
by MGFoster Go to last post
1 84
update query by fresher
Dear Team, I have created 2 queries which contain 2 difference result set, in fact this 2 queries from same table and this table linked from SQL database....
July 10th, 2009 05:03 AM
by fresher via AccessMonster.com Go to last post
2 94
Sorting data with query by frogstyle
First let me start by apologizing... If this question has already been answered, I don't know where to look for it. I went through several pages of posts...
July 10th, 2009 02:52 AM
by John W. Vinson Go to last post
4 85
UNION, WHERE or Something else? by Thomas
I have a mailing list where there are multiple yes/no fields. A record can have multiple Yes or just one. One of the fields is a Text for emails. Not all...
July 10th, 2009 02:10 AM
by John W. Vinson Go to last post
3 86
If Like "#*" gives me everything that starts with a number, what do I use to get only alpha? by Kelvin[_3_]
This gives me everything that starts with a number, Like "#*" How do I get everything that starts with an alpha character? I guess Not Like "#*" would be an...
July 10th, 2009 01:02 AM
by John Spencer Go to last post
4 114
Query (Recordset) is Not Updateable by LA Lawyer
I have a query that has a single table linked one-to-one to two other tables. I want to update a field that exists only in one of the tables. This field is...
July 10th, 2009 12:59 AM
by John Spencer Go to last post
1 81
In String - Urgent Request by Sean
Is there a way to use the in string function to pull out text if you do not know the position of the text you are looking for? For example, if my string...
July 10th, 2009 12:57 AM
by John Spencer Go to last post
5 68
Query the ealiest date within several columns in table by Alison
Hi, I have a database of projects with four different date columns (DOB, First LWS, First SLDWS, and First SA). Some of these fields are blank. I want to run...
July 9th, 2009 11:21 PM
by KARL DEWEY Go to last post
1 76
Counting posts by Twisty
I need to count lines/posts in i a report. The report shows dates or "no dates" (empty fields). I need a "Total-line" in the bottom of the report, which...
July 9th, 2009 09:33 PM
by Twisty Go to last post
8 97
identify missing numbers in sequence of records by Tom Whyte
Please can someone tell me how to identify gaps in supposedly sequential data and calculate the value of teh difference. Thanks.
July 9th, 2009 09:18 PM
by MGFoster Go to last post
4 80
sql string as field data; ado? by robert.waters
How might one escape an SQL string for insertion into a table? I have a multi-user Access db, with users that create their own queries that need to be synced...
July 9th, 2009 09:01 PM
by MGFoster Go to last post
1 63
"microsoft office access" unknown error by jcandamo
I'm getting a "Microsoft office access" unknown (error with exclamation mark) when opening a table in a MS Access 2003 database. The error happens in one...
July 9th, 2009 09:01 PM
by jcandamo Go to last post
1 81
table by Tammy
I have a table that i want to pull queries from. I want to see all the homes with an address on Andalusia. So I want my query to pull all the homes on...
July 9th, 2009 08:45 PM
by Tammy Go to last post
2 62
template for timesheet - calculation wrong by SS
I AM USING THE TEMPLATE FOR TIMESHEET WITH BREAKS BUT CAN NOT UNDERSTAND HOW MY TOTAL CAN BE 53.77 HOURS AND NOT 54.17? I'M CONFUSED WITH THE CONVERTION TO...
July 9th, 2009 08:06 PM
by MGFoster Go to last post
1 75
query for non matching fields by kevin[_8_]
Hello, I have two spreadsheets with first and last names and other info. I want to query the two so the result is the names that are NOT duplicated in the two....
July 9th, 2009 07:22 PM
by kevin[_8_] Go to last post
2 86
three query union. by Thomas
Trying to make a three querry, but every time I try I get an error message that MS Accesss DB can't find object ". I have 4 querries They all work & they...
(Multi-page thread 1 2)
July 9th, 2009 06:31 PM
by Thomas Go to last post
13 161
how to select a random item from a field by JohnL
I am building a simple database to randomly select items from a table, but can't seem to build a query that will randomly select one record from the...
July 9th, 2009 06:09 PM
by KARL DEWEY Go to last post
1 82
Calculating days from last meeting held by Tina Hudson
Good afternoon, I need to set up a query for a report that shows a list of all active cases by unit and the date of the last TDM Meeting for each case. TDM...
July 9th, 2009 05:26 PM
by Jeff Boyce Go to last post
4 91
Post New Thread


Display Options
Showing threads 4001 to 4020 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 05:28 PM.


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