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
Days and dates query by shirl
I am hoping someone can help me with this. My database contains events/courses with a start date and an end date, the start date could be say 1/9/12 (UK...
November 30th, 2012 09:27 AM
by shirl Go to last post
0 3,890
Can I use one prompted date critera to create others? by Lee S.
Hey, I have had to set up several rather complex queries using nested queries. I am required to enter an initial date, and would like to be able to use that...
November 5th, 2012 06:51 PM
by Lee S. Go to last post
0 1,137
Find a date between two date fields by shirl
I have a database which contains an events table, fields a Event Title, End date, Start date, Start time, End time, Frequency (this is a combo for weekly,...
April 22nd, 2012 09:04 PM
by shirl Go to last post
0 1,652
Prompt Date To Use In Query Formula by Jeff Monroe
I have a query where I would like a date entered by the user to be used in a formula for each record. The user is prompted to enter a date, and then that date...
December 14th, 2011 04:51 PM
by Jeff Monroe Go to last post
0 3,622
Forcing an ambiguous outer join by AccessKay
I tried to add another table to my query with a Left join and I receive a message that my SQL contains ambiguous joins. It went on to say that I needed to...
April 15th, 2011 01:43 AM
by bioday Go to last post
7 2,802
Like Criteria Question using a control from a Form by DawnP277
I am trying to do a like criteria with 2 wildcards using a text box as the parameter. The original data comes from our ERP system that I ODBC to. Everything...
June 7th, 2010 09:46 PM
by DawnP277 Go to last post
0 2,105
in access, if then statement by dtretina
if (Escalation/Assignment = 0) or (Updateheat = 0 )or (Worklog = 0), then 0 for the total. Else total. How would you set this up in design query? Each of...
June 7th, 2010 09:13 PM
by KARL DEWEY Go to last post
2 1,518
Using a combo box to determine which field to search. by vander via AccessMonster.com
What I want to do, hopefully, will be simple enough. I want to have a search form that has two fields, one a combo box and the other an unbound field. I want...
June 7th, 2010 08:38 PM
by vander via AccessMonster.com Go to last post
0 1,507
Function of colon between table names when query in design view by Jazz
I am looking at a field from a query that is in design view. Inside the field are two field names from the same table which are separated by a colon. For...
June 7th, 2010 08:05 PM
by John Spencer[_2_] Go to last post
1 1,514
duplicate results in query by pat67
Hi, I am getting duplicate results when I run a query. Here are the details. Bothe tables have the same data only dates have changed. what I am trying to do is...
June 7th, 2010 07:55 PM
by pat67 Go to last post
6 1,457
Pulling specific data from table field by jet04 via AccessMonster.com
I am having a problem figuring the right way to pull specific data from within the text of the table's field and separating it into a unique...
June 7th, 2010 04:24 PM
by KARL DEWEY Go to last post
4 1,760
How to calculate days due? by Jim
I have a table (tblTerms) with 2 fields & . The typical terms in the table would be 2%10 Net 30 with having a value of 30. I then take the difference...
June 7th, 2010 04:18 PM
by Jim Go to last post
2 1,411
Dsum Problem with date criteria by naveen prasad[_2_]
Hi all, Kindly solve my problem. I have 2 tables stock_received , stock_utilized. stock_received fields -- date,3pcs,4pcs,boxes. stock_utilized fields -- ...
June 7th, 2010 03:43 PM
by vanderghast Go to last post
1 1,600
Add character to string by Twimm
I have a simple query that pulls data from a single table containing some basic client information. One field is a text field containing alpha-numeric data. ...
June 7th, 2010 03:06 PM
by Marshall Barton Go to last post
3 1,393
Looping through data with calculations by clalc
I have to loop through the data from one table (demand) and calculate total supply expected depending on the data from the other tables, here is example and...
June 7th, 2010 02:34 PM
by vanderghast Go to last post
1 1,254
How to set the parameter query for this case? by klim1167 via AccessMonster.com
Dear all, I have 2 fields, Eng and Math. I would like to set the parameter query for Eng and Math == Eng min, Eng max, Math min and Math max. The Eng query...
June 7th, 2010 02:30 PM
by Krzysztof Naworyta Go to last post
2 1,335
Delete Query not Working by SSi308
I have tried to follow many of the suggestions in other posts, but have not been able to get this to work. I have a table called DailyCalls and another table...
June 7th, 2010 02:24 PM
by John Spencer Go to last post
5 1,565
Use of Parntheses in Expressions by bbal20
Hello, I am fairly new to Access and Excel. I am trying to write a formula/expression, but I think my problem is as simple as having the parenthese in the...
June 7th, 2010 01:59 PM
by John Spencer Go to last post
3 1,311
Multiple tables search by naveen prasad[_2_]
Hi all, Kindly solve my problem. I have a mdb file. tables created t1,t2,t3,t4. fields are almost same in all tables, but the data is different in all...
June 7th, 2010 07:57 AM
by naveen prasad[_2_] Go to last post
8 1,684
complex query to pull unique values by JR[_9_]
I have an inspection table to keep track of rooms in various buildings. These rooms are shared with different supervisors. One inspection of a location would...
June 7th, 2010 06:45 AM
by John W. Vinson Go to last post
5 1,606
Post New Thread


Display Options
Showing threads 1 to 20 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:52 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 OfficeFrustration.
The comments are property of their posters.