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
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
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
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
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
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
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
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
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
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
CrossTab Query with Dates by GNTK
Hi All, I have a database with 3 tables: TBL_Persons; TBL_Absence; TBL_AbsenceReasons. When a person is absent I put a record in the TBL_Absence with the...
May 31st, 2004 06:52 PM
by Michel Walsh Go to last post
3 323
1 Attachment(s) Help! -Match problem by Chengfu
Hi, group. I need your help. I have two tables, one is tblTutor with the names and their available times, the other one is tblTutee with the names and the...
May 31st, 2004 08:43 PM
by Michel Walsh Go to last post
4 289
Totaling selected records only. by David
I have been attempting to total some fields from individual records in a table and then display the result in a text box but have been unable to do so. I...
June 1st, 2004 12:55 AM
by John Vinson Go to last post
1 549
Query By Form by Craig
I have a query by form whereby the form has a Command Button to run a module which checks to see if the query has records. If the record count is 0 it opens...
June 1st, 2004 01:10 AM
by Craig Go to last post
2 952
Help by Andy
I currently run w2000 professional on my other pc. When I shutdown my pc is won't shutdown automatically, I now have to manually press the on off button. Any...
June 1st, 2004 03:34 AM
by John Vinson Go to last post
1 303
How to obtain, how many times "XXX" was visited? by normanf
Hi there, How do i accomplish a count of visits by the date "XXX" was visited using a query? regards Norman
June 1st, 2004 05:38 AM
by normanf Go to last post
2 276
Update query problem by WWV
I have a table (table 1) with many date ranges in them for grouping by age ie start, end dates for group 1, start end dates for group 2 etc. I have another...
June 1st, 2004 07:12 AM
by John Vinson Go to last post
1 550
HELP!!!! Report with more pages on the same paper page by Chris
I need to do a tabelar report with header and footer. For every change of each one of 2 of the parameters from the header, it is requested a new instance of...
June 1st, 2004 08:17 AM
by Chris Go to last post
0 586
Edit table using union query by De'Ville
I am trying to create a form for a union query that allows me to edit the data in either of the tables used for the query, but I can't understand why with...
June 1st, 2004 11:46 AM
by Michel Walsh Go to last post
1 1,331
More dates issues by Mike
Hello, The dates in a SQL2k table are stored as nvarchar (yyymmdd). When displayed, the CAST (DATE_FIELD AS datetime) syntax is used. Because of the...
June 1st, 2004 12:24 PM
by Gary Walter Go to last post
1 362
highlighting field in query or report by Tony
Hi, I'm trying to highlight a cost field if there is a change in the field value. eg if previous cost was $2.20 for the last 9 weeks and this order comes in at...
June 1st, 2004 12:53 PM
by Tony Go to last post
5 555
Post New Thread


Display Options
Showing threads 161 to 180 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 11:45 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.