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
sql time formatting by dp
hey guys, trying very hard to format a time for an update query (without date part) I have this so far: Format$(strTime,"\#hh\:nn\:ss ampm\#") Isnt there...
July 9th, 2004 03:05 AM
by Dale Fye Go to last post
2 158
Missing records by AdmSteck
I have a query in which I am trying to pull the total misset parts for each month for each part. Here is the query I have: SELECT Parts.ID, Parts., Parts.,...
July 9th, 2004 02:59 AM
by Dale Fye Go to last post
1 273
Multiple results in a querie by Paula
I have an employee data base that has separate fields for different eligibility dates for our various benefits. I want to set up a querie/report that will...
July 9th, 2004 02:20 AM
by Dale Fye Go to last post
1 142
todays date by rml
I'm trying to run a query based on todays date. What is the syntax for today in the criteria line. Thanks.
July 9th, 2004 02:12 AM
by Dale Fye Go to last post
1 139
Dates range within Date range by Deanne
I am currently trying to write an expression that flags whether a specific date range occurs within a certain date range. This will enable me to calculate the...
July 9th, 2004 02:09 AM
by Dale Fye Go to last post
3 518
Summarise groups of data by damien
I've got some data which looks a bit like this: row_id user sick day sick...
July 9th, 2004 02:08 AM
by John Spencer (MVP) Go to last post
3 199
Update query by 1/2 entered number by Eb1mom
Two update queries. Number fields are being updated. Query is simply + A popup comes up and user enters number to be added. In second update query the...
July 9th, 2004 02:07 AM
by eb1mom Go to last post
2 756
using DLookup() to obtain a total from a group of records in a related table by Paul James
I've got two related tables - tblInvoice and tblDetail which are related by InvoiceID fields in each table. The Amount field is in tblDetail. I've got a...
July 9th, 2004 02:00 AM
by Paul James Go to last post
5 667
Queries adding Zeroes by Rob
hi, i have a table which keeps track of lawyer membership in different sections (i.e. criminal law, civil law, etc.) by having their section dues (in a...
July 9th, 2004 01:55 AM
by John Spencer (MVP) Go to last post
2 418
qry to show data from two tables by jane
I am trying to build an appointments database which includes a table of appointment times spaced at fifteen minute intervals and a table to record...
July 9th, 2004 01:47 AM
by John Spencer (MVP) Go to last post
7 281
Update query by Ian Sweeney
What is the Access equivalent of UPDATE table a FROM table b SET x = b.y WHERE a.c = b.d
July 9th, 2004 01:38 AM
by John Spencer (MVP) Go to last post
4 161
Query or queries by Dan
I have a query based on two tables. One table has ID number, point, and a Code field with either an X or a C. the other table has ID, Name etc. I have created...
July 9th, 2004 01:19 AM
by Ken Snell Go to last post
1 194
Query on a linked spreadsheet by Michelle
In Access, I have linked an Excel spreadsheet, and then have queries running off that linked spreasheet. The queries are functioning correctly, but when I...
July 9th, 2004 01:16 AM
by Ken Snell Go to last post
1 490
parameter query with multiple entries by lynn.atkinson
Can I have a parameter query where the user just types the various criteria in to one dialog box? eg I want to find location 1, location 2 and location 3 from...
July 8th, 2004 06:53 PM
by Duane Hookom Go to last post
1 468
Replace blanks by text by Seaman
How can I replace blank cells with the word "empty" in the results from a query.
July 8th, 2004 04:28 PM
by Seaman Go to last post
2 287
Unmatch query by Amorfosis
Could somebody please tell me what an unmatch query is in English. The help menu in access isn't exactly crystal clear on what the query is and what it...
July 8th, 2004 04:14 PM
by Wayne Morgan Go to last post
1 122
Pass Through Query Parameters by Stacy
I'm using an SQL pass through query and would like to run it based on criteria selected in a form. I've tried to call the form fields in the SQL statement, but...
July 8th, 2004 03:55 PM
by Lynn Trapp Go to last post
3 384
Appendquery to add display record, only by an
Hello! I have an Appendquery wich append all records to T_Values. But I would like append present record only, because is unique record with new data. I need...
July 8th, 2004 02:55 PM
by an Go to last post
4 199
append query overwrites all matching records by NoSpamTakeSquareRootOfNumber
I have an append query in a database that must append records into another database on a click() event. How can I make that append query overwrite all records...
July 8th, 2004 02:43 PM
by NoSpamTakeSquareRootOfNumber Go to last post
4 670
How do I reset a parameter used in a query with applyfilter by PACS
I have a macro that performs a first name search that can be executed from a form. It prompts me for the 'Party First Name to Search For'. It executes the...
July 8th, 2004 02:38 PM
by PACS Go to last post
2 236
Post New Thread


Display Options
Showing threads 42281 to 42300 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:53 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.