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
Group by query question by Joseph Greenberg
I have a query which is supposed to (and does) return the earliest record from a table that might have multiple records per "person" (famno). "dis is a...
April 24th, 2010 12:11 PM
by KenSheridan via AccessMonster.com Go to last post
2 186
Need help sorting a query by Iram
Hello, I have a combobox that is called "Category". This combobox runs a query that has two fields "Category" and "Team" from a table. I need to sort the...
April 24th, 2010 01:17 AM
by PieterLinden via AccessMonster.com Go to last post
3 176
Recalculate a field when another field's value changes - JCW by JohnW
I know I have asked this one before but so far I haven't found anything to work. I have the following fields I'm working with; they are all on the same...
April 23rd, 2010 11:48 PM
by JohnW Go to last post
2 137
Multiple "Not Like" not working by Iram
Hello, I need help writing a query that will exclude certain data. I can successfully exlcude one item but when it comes to excluding multiple I can't get...
(Multi-page thread 1 2)
April 23rd, 2010 11:45 PM
by SQLGal via AccessMonster.com Go to last post
10 327
A spin on a common question. DateAdd by Flopbot
This is a spin on a common question. I have a query with a field labeled: Day: Format(,"ddd, mm/dd/yy"). I need it to display the day along with the date...
April 23rd, 2010 11:33 PM
by Flopbot Go to last post
2 190
#Num! in Link File by Mike
I am trying to link an excel file into my database. However when it is finished linking, I have #Num! throughout the file. Certain fields in the file contain...
April 23rd, 2010 06:03 PM
by KARL DEWEY Go to last post
1 167
5 Fields Multiple Values by Ripper
I have five fields that can contain either 1 or 0. Let's call them Fields A, B, C, D, E. I need to write a query that will select them if any of the Fields...
April 23rd, 2010 05:05 PM
by John W. Vinson Go to last post
5 184
Multitable query problem by atledreier[_2_]
Hey. I have a problem I can't wrap my head around. I have a database with mostly normalized data. I have a few tables with a common key, so they are no...
April 23rd, 2010 05:02 PM
by John W. Vinson Go to last post
7 167
Requesting Help Ranking Sales Values..... by CBender
I have a field in a table named "Ext B/O" that lists the extended Backorder Value for parts sold. There may be duplicate values and they should show the...
April 23rd, 2010 04:46 PM
by CBender Go to last post
6 189
Numeric Field Overflow by Mike
I am trying to run a make-table query which has limited data from an excel file. It errors out and gives me "Numeric Field Overflow". However, when I compact...
April 23rd, 2010 04:02 PM
by Jerry Whittle Go to last post
1 182
How to make a query records as criteria to the other query by Tyven Bong
I have a select query that will display these records (no duplicate): # Product Qty -- --------- ------ 1 Soap 3 2 Milk 4 When...
April 23rd, 2010 03:40 PM
by KARL DEWEY Go to last post
1 180
show criteria data from a query on a report using that query by WilliamTheQueryMaker
I have a report that runs a query with a date range parameter criteria. It works great, now I want to display the entered date range on the report. Is this...
April 23rd, 2010 03:16 PM
by RonaldoOneNil Go to last post
2 130
Export empty columns to Excel by atledreier[_2_]
I have a database, and some data in that needs to be imported into another database through Excel. I have no control over this, that's the way it needs to be....
April 23rd, 2010 02:42 PM
by John Spencer Go to last post
1 138
pass through query variables by SimonT
Hi Guys, I am looking for some help with a pass through query. I have a number of reports that allow users to select values from combo box's and want to...
April 23rd, 2010 09:54 AM
by SimonT Go to last post
6 176
Change format of date in query? by Flopbot
Can this be done? I hope I’m missing something small. A query named “Qry Monthly Volunteer Email” has a field named . Right now it returns 4/24/2010...
April 23rd, 2010 02:23 AM
by Flopbot Go to last post
3 154
how to remove html tags from a field in MSACCESS. by KSKFM
I am importing data from SharePoint list to MSACCESS. I need to strip out html tags from the field values
April 23rd, 2010 01:52 AM
by Allen Browne Go to last post
1 175
Running queries via forms by Dragon
is there a good tutorial out there on how to make forms that run queries and reports? I've gotten all turned around on it all.
April 23rd, 2010 01:02 AM
by PieterLinden via AccessMonster.com Go to last post
2 218
Help with Query to find Month by AccessKay
I need some help please. I want to build a query based on a form with two combo boxes for Month 1 and Month 2 and then have a report that has two columns...
(Multi-page thread 1 2 3)
April 22nd, 2010 10:38 PM
by AccessKay via AccessMonster.com Go to last post
25 537
Query criteria based on table entries by Robbro
I have a report based on a query to report our "10 worst" customers based on a couple of factors. Certain customers however are just buying our off quality...
April 22nd, 2010 10:17 PM
by PieterLinden via AccessMonster.com Go to last post
2 219
Trying to update a field by Brian T
Hello all, I have created a query that has project details such as the award cost and want to determine the total cost of the project by bringing in the...
April 22nd, 2010 07:16 PM
by Brian T Go to last post
2 127
Post New Thread


Display Options
Showing threads 421 to 440 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 12:42 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.