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 Replies Views Reverse Sort Order
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 10:27 AM
by shirl Go to last post
0 6,097
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 05:51 PM
by Jeff Monroe Go to last post
0 4,090
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 3,436
create a table within an access2007 database using code in a vb.net app ? by Aussie Rules
Hi, Is it possible to create a table via code (create table ........) in an access 2007 database from a Vb.net 2008 application? Any tips/samples/links on...
February 14th, 2008 09:51 AM
by Allen Browne Go to last post
1 2,597
Create A "Check Register" in Access by LauraK
I have a user who wants to keep track of an account balance in Access...similar to a check register. She wants to enter amounts and have them add/subtract...
November 9th, 2006 07:32 AM
by Peter Yang [MSFT] Go to last post
3 2,582
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,567
Action Query (Append) didn't add records due to key violations. by Nick X
Hi all, I am using MS Access 2007 as front-end and SQL Server 2005 as back-end. In SQL Server I have a PK plus a multi-field index that is unique. I can add...
March 22nd, 2010 06:05 PM
by Nick X Go to last post
7 2,530
Access Subtotal in Query by scott
I have a simple query that uses 3 fields. Location, Person and Value. When I group by location and person and sum value, I get all the results I need but I...
May 12th, 2010 11:36 AM
by Bob Barrows Go to last post
3 2,364
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 2,275
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 2,247
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 2,132
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 2,125
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 2,042
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 2,034
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 2,009
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 2,001
April 6th, 2010 03:43 AM
by John W. Vinson Go to last post
2 1,982
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,965
Likert Scale data- how to enter in Access by Struggling graduate researcher
I have created a database to record responses to a questionnaire in which respondents must answer YES, NO or I Don't know for each question. For EACH...
September 23rd, 2008 02:52 AM
by Struggling graduate researcher[_2_] Go to last post
4 1,957
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,915
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 02:13 AM.

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