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
is this a friday? by ty
I need an update query with an If statement on it. Basically, it would say something like If AssignDate is Friday, then update Time Elapsed to 1 hour. My...
May 16th, 2007 08:05 PM
by John Spencer Go to last post
3 57
Problem with Update Query by MacNut2004
Hello, I have the following in a query: UPDATE Actuals INNER JOIN ON (Actuals. = .) AND (Actuals. = .) SET .Jan = IIf(Month(Forms!Main!)=1,,), .Feb =...
May 16th, 2007 08:01 PM
by John Spencer Go to last post
5 61
Seems so simple - Percentage by Danu
I have a table with the code designation in one column and the number of records with that code in the other column. I need to find out what percentage of...
May 16th, 2007 07:28 PM
by Danu Go to last post
4 59
how do use GROUP BY on a CASE statement located in the SELECT part of function? by Mitchell_Collen via AccessMonster.com
Hi, I am new to access and can't figure this one out. Does anyone know how to do this? Here is my code: ps: this function is not requiring parameters at this...
May 16th, 2007 06:44 PM
by Mitchell_Collen via AccessMonster.com Go to last post
1 102
Finding and deleting dupe queries across two fields by efandango
How can I display duplicate addresses with matching postcodes. At the moment my SQL will only find duplicate Street Names, which will only be duplicate if...
May 16th, 2007 06:17 PM
by John Spencer Go to last post
6 51
field returns a value if at least one matching record is found by bicyclops
I had posted this question in the Forms thread, but that was probably the wrong place. TblPartNumInfo TblDefectRpt My query for PartNumInfo brings together...
May 16th, 2007 06:01 PM
by bicyclops Go to last post
2 65
query timing out. how do you stop this from happening? by Mitchell_Collen via AccessMonster.com
What can be done to keep a querie from constantly timing out? Almost all my queries and functions are doing this lately as my database grows. Any advice on...
May 16th, 2007 05:31 PM
by Jerry Whittle Go to last post
1 48
Somebody Please Help by JS
I have a main table tblOHInst. Fields Match and Zip are blank. I have a secondary table tblInstNew that has the same fields as the tblOHInst but the Match...
May 16th, 2007 05:31 PM
by JS Go to last post
3 63
Multiple parameter query by JoeA2006
I need a form to allow the user to drill down to records using a multiple parameter query. In the columns criteria I have something like this !.!. I will...
May 16th, 2007 05:10 PM
by KARL DEWEY Go to last post
1 57
Get month between non calendar dates by AccessNewbie
Office 2007 I want to be able to get the Tax Month from a given pay date. Tax months run from 6 April to 5th May, 6th May to 5th June etc If the payment...
May 16th, 2007 04:46 PM
by KARL DEWEY Go to last post
3 71
multiple date ranges by GiBB
Hello, I am trying to create a query to search for various date ranges in a table. to make it easier for the user i am trying to create the query so they...
May 16th, 2007 04:43 PM
by GiBB Go to last post
3 63
Query on Date position by [email protected]
I have a table where the date field is stored as yyyy/mm. I want to be able to query all records that have the previous month in their record. In other words...
May 16th, 2007 04:31 PM
by Jerry Whittle Go to last post
2 67
Report Query Woes by Michael Conroy
I need help with SQL syntax to combine two queries and use a criteria string to limit the results and feed this all into a report. The criteria is determined...
May 16th, 2007 04:27 PM
by Carl Rapson Go to last post
1 68
Help to correct this DLookUp by Marco
Can you check what wrong with this DLOOKUp that I want o insert on a report. =DLookUp("";"";" = '" & & "' and = '" & & "'") I have a report base on a...
May 16th, 2007 03:22 PM
by Rick Brandt Go to last post
3 76
Diference between hours when hours in diferent recordset by Marco
Hello. I need to calculate the diference between diferente hours, but those hours are are in diferente recordsets. Like...
May 16th, 2007 03:05 PM
by John Spencer Go to last post
9 112
Less of Two...but not ZERO by cnistler
I'm looking to take the lesser of 2 data values (in different colums) but only when the data is greater than 100. Here's an example: Col A Col B Desired...
May 16th, 2007 02:44 PM
by cnistler via AccessMonster.com Go to last post
3 121
Passing Public varialble to a query by Frank
Hello, I've got a button that when pushed will declare my VarCurrQry variable as a parameter that I then want to pass to a query. From reading posts it...
May 16th, 2007 02:29 PM
by Ofer Cohen Go to last post
5 58
Unable to access database simultaneously by NB
hi, we have migrated the machines from one domain to another. after that users are not able to access the access database simultaneously. please suggest
May 16th, 2007 02:04 PM
by Klatuu Go to last post
1 77
Counting within a count group by query? by [email protected]
Hi All, I would like to ask for your assistance with merging two queries into one to achieve a desired outcome. The first query counts the total occurrences...
May 16th, 2007 12:16 PM
by John Spencer Go to last post
4 64
How do I correct erros from another program? by Marco
Hello. I'm creating a querie from another program. It register the time of each employee get in and get out of work. But the machine that read cards and...
May 16th, 2007 09:47 AM
by Marco Go to last post
4 78
Post New Thread


Display Options
Showing threads 18061 to 18080 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 04:47 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.