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
selecting a query from a combo box by No1momof3
HELP! Need to design a DB for my boss and I am lost! I have a database which lists students who have went on exchange over the last 17 years to over 20...
December 11th, 2009 01:48 AM
by KenSheridan via AccessMonster.com Go to last post
1 167
jeramie bellmay by jeramie francis[_2_]
December 11th, 2009 12:00 AM
by jeramie francis[_2_] Go to last post
0 204
Autofill Options by TC
I am developing a database to track training for employees. I would like to be able to type in a first and/or last name and/or an employee number and auto...
December 10th, 2009 11:45 PM
by Jeff Boyce Go to last post
1 155
jeramie bellmay by jeramie francis[_2_]
people jeramie bellmay www.myspace.com not mach no find 11/11/09 12/08/09 AREA FRIDAY @DON HILL S?s PHOTOS-VIEW PHOTO
December 10th, 2009 11:43 PM
by jeramie francis[_2_] Go to last post
0 165
Divide by Zero error by Jecker
I need assistance please. I have 2 fields called PWP_TRX and TOTAL_TRX. I have a query expression that reads sum()/sum([TOTAL_TRX). On occasion both these...
December 10th, 2009 10:45 PM
by Duane Hookom Go to last post
3 145
convert month text (MAR) to month number (3) by HLCruz via AccessMonster.com
I am trying to work with a data set that unfortunately has spit out all the dates in a text format - i.e. 03/01/2009 is MAR 3 2009. Is there a way to convert...
December 10th, 2009 10:00 PM
by Jerry Whittle Go to last post
1 251
2 criteria for query by NeedExcelHelp07
How would I write a query where I want to find a conflict of user profiles sorted by id's? I have a table listing user id's, names, and profiles. I want to...
December 10th, 2009 08:42 PM
by KARL DEWEY Go to last post
5 150
SQL View by Marsh
I inherited a database with a lot of queries, some of which need to be modified. Many of them will not open in design view, only in SQL view. This is not a...
December 10th, 2009 08:35 PM
by Daryl S[_2_] Go to last post
5 168
how do i creat something like this? by nathanmcc
hey guys i need to create something that looks like the picture below, i made it in ms paint because i need to know how to get it to work in either access or...
December 10th, 2009 08:27 PM
by Daryl S[_2_] Go to last post
2 305
Append query without duplicate rows by Eric[_24_]
I am trying to design an append query that will not add duplicate data. In my searching, all the information I have been able to find has been in regards to...
December 10th, 2009 07:41 PM
by Eric[_24_] Go to last post
5 217
Multiple records in table to display single records by Hurrikane4
My table has 3 columns, A is account numbers, B is first name, C is last name. If an account has 2 owners, the account number is listed twice in C1, like...
December 10th, 2009 07:34 PM
by Hurrikane4 Go to last post
7 229
"Invalid use of Null" in query by Rob Parker
I have a query which has suddenly started giving this error. It is based on two other queries, each of which run OK. The query contains 4 left joins (I'm...
December 10th, 2009 05:37 PM
by Jeff Boyce Go to last post
3 140
ranking a query or report by pat67
I have a report that ranks plyers based on the winning percentage. I just have a running sum so it adds 1 to each name. The problem is this does not work when...
December 10th, 2009 05:28 PM
by KARL DEWEY Go to last post
1 148
Office 2007 by Alan[_32_]
I have Office 2000, including Access. If I upgrade to the home edition of Office 2007, which does not include Access, will the old Access 2000 still be...
December 10th, 2009 04:57 PM
by John Spencer Go to last post
3 174
Text manipulation in update query by Tony in Michigan[_2_]
I want to compare two tables, in order to update fields in either table. The fields that I am matching on are text. Table 1 field...
December 10th, 2009 04:51 PM
by Duane Hookom Go to last post
2 154
text to number by Norm
I have a numbers in a feild in an excell sheet that I need to change from text to number so I can use the field in a query in Access
December 10th, 2009 04:20 PM
by Jerry Whittle Go to last post
1 121
Why is my Access Queries take a long time to generate? by Weak Access User
I used to do the query in less than 30 secs, but using the same method to do another query, it took more than a minutes to generate the table. Why is it so?
December 10th, 2009 04:04 PM
by Jerry Whittle Go to last post
1 221
timestamp handle by R Walle[_2_]
I have a database automatically created for a GE SCADA software, it creates a table with datalogging from the proccess , one column for each datafield is...
December 10th, 2009 03:48 PM
by John Spencer Go to last post
5 146
sutraction after sum by enrico via AccessMonster.com
if i have data a, b, c, up to z in my table with specific amounts, how do i get their sub-total if i don't want to include data l, m, n, o & p? how can you sum...
December 10th, 2009 03:47 PM
by John Spencer Go to last post
6 143
Can I call a function in query criteria? by Maarkr
Hope I'm not being too vague... I built a function to sort people into categories, most are in one, some are in many... the function works well when I use it...
December 10th, 2009 02:08 PM
by Maarkr Go to last post
5 209
Post New Thread


Display Options
Showing threads 1961 to 1980 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 09:11 AM.


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