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 39,949
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 7,175
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 6,759
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 8,765
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 8,171
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 7,216
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 6,623
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 6,470
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 6,593
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 6,491
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 7,028
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 6,501
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 6,576
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 6,288
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 5,679
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 6,365
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 6,569
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 5,991
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 6,792
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 6,361
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 06:54 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.