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
Multiple look up criteria by Dee
I have three queries. First one: "Discrepancies in unit price": SELECT Data.MANUFACTURER, Data., Data.DESCRIPTION, Data. FROM Data WHERE...
November 21st, 2006 08:07 PM
by Dee Go to last post
2 70
Update Query to run on SELECT records in table by Andy
I have a form with two sets of data in, running from one table. I would like a button that would give the user the ability to update dataset 2 with the...
November 21st, 2006 07:48 PM
by Andy Go to last post
0 66
Selected Days Filter by Simon One
I want to filter my data to return information for a specified date and for the previous 14th Day, 28th day, etc for the previous 6 periods. i.e. 28/11/06 ...
November 21st, 2006 06:26 PM
by Simon One Go to last post
2 81
Time Calculation by Scott
I am calculating the amount of time that an employee is tardy. I am using the following expression: TardyTime: Format(/1440)-(/1440),”h:nn”). The...
November 21st, 2006 05:46 PM
by Scott Go to last post
2 80
Cannot execute data definition statements on linked data sources by RWilly
I receive the error message in the subject line when I try to run the following SQL ALTER TABLE tblProgDeliv ADD COLUMN NUMBER TechID would be a foreign...
November 21st, 2006 05:40 PM
by RWilly Go to last post
2 87
Return parent based on child by ES
How can I build a query to return Jack from the following from two tables? Table1 (parents) 1 John 2 Jack 3 Sue Table 2 (child)
November 21st, 2006 04:55 PM
by Marshall Barton Go to last post
1 75
Update a boolean field by jac007
I have two tables that are being compared. If field_1 from TABLE B is the same as field1 from TABLE A, then there QCTV1 field from TABLE A should have a...
November 21st, 2006 03:09 PM
by jac007 Go to last post
2 74
List record by sum condition!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! by AN Thanh Nguyen
ex: I have a table: idex name codequestion mark 1 A MS_HR_RI1 45 2 A MS_HR_RI2 30 3 A MS_HR_RI3...
November 21st, 2006 02:33 PM
by Gary Walter Go to last post
5 115
Criteria that allows to Query Upper Case by Romin
Hi, I have a query where I want to retrieve only records from a Table where one of th e Fields in that Table does not contain the two letters BR in upper...
November 21st, 2006 02:28 PM
by Romin Go to last post
6 93
Bonus 10% of Salary by na
Hi, The query is: Employees whose Bonus is at least 10% of their Salary. Thanks Myrna
November 21st, 2006 02:09 PM
by Jeff Boyce Go to last post
2 88
Use Date as Query Criteria by Dave C
Hi, I hope someone can help me. I have a query that I want to execute using a date range in the criteria. It works fine if I prompt the user to enter the...
November 21st, 2006 02:07 PM
by Allen Browne Go to last post
4 64
Use List Box to select a paramter for a query by jeh
For the first time I'm trying to base a query on a user selection via a list box. My simple test db has one table, two forms and two queries. Tbl_1 contains...
November 21st, 2006 01:40 PM
by John Spencer Go to last post
5 84
Show ontly the information that's not in table A by Laputa
Hello, I need some help with a query... I have two tables table1 and table2 they are linked by table1.Upas_id --- table2.Upas_id. In table2 there are only few...
November 21st, 2006 09:08 AM
by Laputa Go to last post
2 58
Missing Birth Dates by na
Hi The query I need All employees, except those with missing Birth dates. Thanks Myrna
November 21st, 2006 04:22 AM
by David F Cox Go to last post
3 74
Help on Consolidating data by The Dummy in Access for Dummies
Is there a way to consolidate data for one particular item (record), without converting into a Pivot Table? Example: If I have 60 units for the year 2005 and...
November 21st, 2006 03:36 AM
by John Vinson Go to last post
1 65
Queries by na
Hi The query that I am having difficulties with. Query. Employees whose first name and last names begin with the same letter (e.g. Jill Jones). Thanks
November 21st, 2006 03:34 AM
by John Vinson Go to last post
1 60
Help on Consolidation by The Dummy in Access for Dummies
November 21st, 2006 03:33 AM
by John Vinson Go to last post
1 49
Exclude records in qry1 if the same record ID is found in qry2 .. by Silvio
In short: I have two join query, qryJoinApproved and qry JoinPending. How can I excluded rercords from showing in qryJoinApproved if the same record ID is...
November 21st, 2006 03:07 AM
by David F Cox Go to last post
3 93
Type Mismatch in Expression Error by Bill
I am trying to run a make table query from existing related tables that are linked through a connection that updates their information daily. I have dragged...
November 21st, 2006 02:04 AM
by John Vinson Go to last post
1 61
1st Of Every Month by Jose Aleman
Hi, I'm trying to build a query that gives me the first day of the current month. This is what I currently have: When I run my query it returns 10/1/06 and...
November 21st, 2006 01:54 AM
by Jeff Boyce Go to last post
2 78
Post New Thread


Display Options
Showing threads 22121 to 22140 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 01:01 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.