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
Help with parameter query by Zeunasc
I have a very simple query that has two parameters - and . The End Date should always be 90 days from the Start Date. I would like to just have the ...
February 28th, 2007 08:29 PM
by Zeunasc Go to last post
2 106
MDB Queries by MUSIWA
I have a query that shows the visits of my contacts. I would like to filter it so that only one visit per contactID shows and is the most recent visit. right...
February 28th, 2007 08:03 PM
by MUSIWA Go to last post
2 135
Access Function like Excel TRUNC function? by Cyhill
Is there an access function that performs the same action as the TRUNC function in excel? The round function doesn't work for my needs. Don't need to round...
February 28th, 2007 08:02 PM
by Marshall Barton Go to last post
2 141
Date Search in Date & Time Field by hobbit2612 via AccessMonster.com
Hi, Wonder if someone can help me please. I have a date and time field which shows the dates and times that files were received onto a server at work. This...
February 28th, 2007 07:37 PM
by hobbit2612 via AccessMonster.com Go to last post
9 142
Help with duplicate query by Jessica Murray
I hope I can explain this so it makes sense.... I made a duplicate query with the wizard which is fine BUT I'd like to have it give me only the records that...
February 28th, 2007 07:21 PM
by Jeff Boyce Go to last post
4 125
Using a query to populate a search form by mikeinohio
I have a query that i want to use to look up parts by part number, every part has 20 related field in this query, i want to use a textbox to type the part...
February 28th, 2007 07:20 PM
by Jeff Boyce Go to last post
3 139
How do I do reverse concatenation in an Access query? by trainer07
If I have a field in a query called "Address" and this field has information in it that looks something like this: 555 First Street, Chicago IL 39847 How...
February 28th, 2007 07:09 PM
by John W. Vinson Go to last post
4 151
Drop down list search by Matt Dawson
I currently have a query which run from 3 parameters in order to select fields which are based on three criteria. However, some users do not know the list to...
February 28th, 2007 06:22 PM
by fredg Go to last post
2 121
Distinct.... and count together by Sonnich
Basically I have a table with: field1, field2 a, 1 a, 2 a, 2 (this repeats!) b, 1 and wanted result is:
February 28th, 2007 06:19 PM
by Sonnich Go to last post
2 113
How do I show only the fields that are not the same beween two tab by Eric
I have two tables with cat # informations. When I join the two I want to only show the records that are not the same between the two, not the ones that are...
February 28th, 2007 05:37 PM
by Eric Go to last post
0 127
How do I show only the fields that are not the same beween two tab by Jennyrd
You may want to try the unmatched query wizard. "Eric" wrote: I have two tables with cat # informations. When I join the two I want to only show the...
February 28th, 2007 05:20 PM
by Jennyrd Go to last post
0 128
where statement by Dries
Hi Guys, I got the following problem I have a table Nr Country Cost 1234 DE 1.21 1234 NL 1.28 1234 BE 1234 ...
February 28th, 2007 04:37 PM
by Jerry Whittle Go to last post
2 143
Multi Select Lists by djf44
I found this code in a text book that works for selecting multiple items in a list box. I can't get the bottom part to work, the part that shows how to open...
February 28th, 2007 04:23 PM
by Cinzia Go to last post
5 166
Sorting Numbers by jasidebo
I just ran across something strange. I am sorting approxematley 80k records by a field containing positive and negative numbers. When I sort in ascending...
February 28th, 2007 04:10 PM
by Gary Walter Go to last post
4 199
Number of working days by [email protected]
Hi, I use the codes to calculate the working days but how do I know if it will calculate the days including leap year. Is there a way to know how many...
February 28th, 2007 03:29 PM
by Jamie Collins Go to last post
6 131
Parameter Query by pjscott
I have query that converts the months of service to years. Years: / 12 The user wants to display a list that's =. I created a parameter query with the...
February 28th, 2007 02:52 PM
by Jamie Collins Go to last post
5 146
How do I get values based on Field name? by Govind
I need to get values by entering only the field name in query. Ex..In a Student table, the fields are like RNo,Name,English,Maths,Science,.etc I want to get...
February 28th, 2007 02:34 PM
by Jamie Collins Go to last post
4 152
update query? - Form Object? by Fuzuy
I am running some difficulty, I try to update ID_req of Table "documents" using ID# of another Table "Dwg_Spe_Cal_Dsheet" based on a selection of ID from a...
February 28th, 2007 12:43 PM
by Michel Walsh Go to last post
1 195
query with subquery does not take all rows it should i think by [email protected]
Hello There is two tables: 1. product_nb;price_start_date;shop;price 2. Days (dates from two months day par day)
(Multi-page thread 1 2)
February 28th, 2007 11:46 AM
by Gary Walter Go to last post
10 230
Cover up attempt by Jennifer Crosby
http://toiletseatcoverup.blogspot.com/ - Yahoo ads not performing well? Publisher profits in the toilet? Join the best affiliate program known to man....
February 28th, 2007 10:28 AM
by Jennifer Crosby Go to last post
0 169
Post New Thread


Display Options
Showing threads 19801 to 19820 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 08:11 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.