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
Working Days by hermie
I try to do the same but not got it work? I put next formula in my query: TotalDays: Work_Days(-) What is wrong with this formula? Herman "Ian Tranter"...
May 31st, 2004 05:16 PM
by Duane Hookom Go to last post
1 422
Exclude weekends by Dan
Hi: Can anybody tell me how to exclude the weekends from the rezult of: now()+5 - to calculate just the working days!!? Thank you, Dan
May 31st, 2004 05:15 PM
by Duane Hookom Go to last post
6 428
Subquery? by Chris
I have a table looking like this: Timekey Value ********** ******* 1 1.3 2 1.45 3 1.5 4 ...
May 31st, 2004 04:16 PM
by John Spencer (MVP) Go to last post
1 347
3 highest values in query by AK
Hello, How to display 3 highest (smallest) values in sql query (without Max. values field) . Andrzej
May 31st, 2004 12:29 PM
by Michel Walsh Go to last post
1 455
HOW CAN I VERIFY WHEN WITHDRAWING AN ITEM FROM A STORAGE IF IT EXISTS IN THE STORAGE? by Chris
I have a database for an existing stock in a warehouse. I made a table with the entries in the storage, and a query with the total of materials which are in...
May 31st, 2004 11:09 AM
by MacDermott Go to last post
3 474
Query Join Problem by Tom
Hi all, I am trying to join two queries together, but the join is on a normal field in one query to a calculated field in another. The join is working fine,...
May 31st, 2004 09:54 AM
by Tom Go to last post
0 1,044
Query DateTime Field by Tausif
Hi, I have a field DateStamp, stores both date and time. I would like put a query with which I can only compare date but not the time. I put this query but it...
May 31st, 2004 07:54 AM
by John Vinson Go to last post
7 432
Sorting a query is bringing up a parameter request for some fields by Donna
I have created a qry that uses a few fields created by IIF statements. When I run the query it prompts me only for the paramater of that I put in it. But as...
May 31st, 2004 07:51 AM
by John Vinson Go to last post
3 683
Format Date by Tiffany
I have to import a text file into access. When I import the file using the date format on the table I get import errors. Since I cannot control the text file...
May 31st, 2004 05:48 AM
by Tiffany Go to last post
4 283
current date less 28 days by marion
I support online learners and in this particular query I am using two tables one for the student information and one containing all the contact I have had with...
May 31st, 2004 03:19 AM
by Van T. Dinh Go to last post
5 302
Expr: Left([dob],4) = omitted an operator? by Jan
Getting error saying "omitted an operator" when trying a simple function. All I'm trying to do is get a list of the first 4 characters of a text field of 6...
May 30th, 2004 09:17 PM
by John Vinson Go to last post
2 378
criteria in query part of field text only by MemphiDoug
In my email field, I want to query only the aol.com users. I have tried ="**", I have tried LIKE "**", I have tried just "aol.com" I can't figure out how to...
May 30th, 2004 09:11 PM
by pdm Go to last post
1 558
"append query" issues by BJMLaJolla
I have the same problem. I have 70 tables that I want into one table. All tables have the same structure with different content. I tried an Append Query but...
May 30th, 2004 08:45 PM
by John Spencer (MVP) Go to last post
1 325
Quering 2 IDs from a single table by Paul
Hi, I need to query 2 salesman_ID from a table but I cannot figure out how. SELECT salesman_ID, FROM product
May 30th, 2004 06:23 PM
by Paul Go to last post
2 345
criteria in query part of field text only by MemphiDoug
In my email field, I want to query only the aol.com users. I have tried ="**", I have tried LIKE "**", I have tried just "aol.com" I can't figure out how to...
May 30th, 2004 06:02 PM
by Douglas J. Steele Go to last post
1 642
Substracting two adjacent rows by Yakimo
Hi! I have a very large table, containing some DateTime data. Is it possible to run a query that will return a resultset, containing the difference between my...
May 30th, 2004 06:01 PM
by Yakimo Go to last post
2 290
Autolookup Query by Ernie
I have an autolookup query that automatically fills in employee name and rate on a form. What I would like is to be able to update the rate, for each record,...
May 30th, 2004 05:25 PM
by Jeff Boyce Go to last post
6 596
HELP! by Hannah Jackson
Hi! I don't know how this works but I have a problem so I'm just gonna post it up here. When I'm connected to the internet and I open explorer after about 5...
May 30th, 2004 05:12 PM
by Michael Hopwood Go to last post
1 403
Using a query with a replaceable parameter as the source of a control by Hoo
I'm stuck, trying to base the contents of a listbox upon a query with a variable parameter. The trouble lies in the fact that if I set the listbox control to...
May 30th, 2004 07:07 AM
by tina Go to last post
1 969
how do you work with time? by Annelie
I am trying to create input for a time card Start: 07:44 (shorttime format) End: 17:13 (shorttime format) HoursWorked: 09:29 (shorttime format)-...
May 29th, 2004 11:56 PM
by Duane Hookom Go to last post
1 360
Post New Thread


Display Options
Showing threads 43121 to 43140 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 03:24 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.