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
Using saved query for different tables by Barry
I want to use the same query for many tables. I'm new to Access. I see where you can save the query and name it, but is there a way to then use it with...
February 22nd, 2010 01:06 AM
by Barry Go to last post
5 333
3rd time posting this problem , still no solution by naveen prasad[_2_]
Dear Kindly solve my problem table t1 has fields pictures, name in design view pictures field is ole object and name field is text. now in table, i have...
February 21st, 2010 06:41 PM
by KenSheridan via AccessMonster.com Go to last post
7 363
Updating a table with a field extracted from a join by Patrick Bowman
Okay, here's a fun SQL question that's got me stumped, but it takes a bit to explain. I want to update a table with a value extracted from a join of two...
February 21st, 2010 01:43 PM
by Ken Snell Go to last post
1 212
Exclude afield when using 'Select *' by Steve S
The following appends all 15 fields but I want to exclude Fld3. INSERT INTO Fees SELECT Fees.* FROM Fees WHERE (((Fees.ContestID)=9)); Is there a way to do...
February 21st, 2010 06:36 AM
by David W. Fenton Go to last post
5 177
High light the controls by Leo
I have a form with number of Yes/No fields. Is there a way to highlight the labels with a different color when the fields get focus. I am not able to use the...
February 21st, 2010 02:45 AM
by Allen Browne Go to last post
6 262
Data type mismatch error -- text to date by Marshall Barton
roll-monroe-co wrote: The only reason I haven't pulled out my hair yet is that it's too short to grab. However, I'm about to go for the tweezers! I hope...
February 20th, 2010 10:06 PM
by Marshall Barton Go to last post
0 147
Chinese letters in a Query by Peter
Hi all, i have this strange issue: I just converted to 2007..and in a memo field of a query i receive chinese letter???? what have i done wrong?
February 20th, 2010 09:44 PM
by Jeanette Cunningham Go to last post
1 337
How can I find out who is in the Database? by Dave
Users must login using Access security potentially 20 + users but in reality one 2 or 3 in at a time DB NOT split Problem is I sometimes come in early to do a...
February 20th, 2010 08:05 PM
by Dave Go to last post
2 222
Date comparison in IIF statement in a query by LL
I have a form with a control containing a date. This date is used in a query as part of a IIF statement included in the criteria row of the...
February 20th, 2010 06:34 PM
by Marshall Barton Go to last post
1 149
mail merge with Word and Access Query by sailor
I am trying to create a Word mail merge with an Access database query that has a parameter (asks for a unique date). When Word asks for "Select Recipients" I...
February 20th, 2010 05:55 PM
by sailor Go to last post
0 142
Trouble with Expression by TonyWilliams via AccessMonster.com
This expression counts the number of records where a tick box is YES TxtSoleYes: Count(IIf(txtSole,1,Null)) Why doesn't this work to give me the number of...
February 20th, 2010 10:12 AM
by TonyWilliams via AccessMonster.com Go to last post
5 163
Last records from a Group By query by KevinE via AccessMonster.com
I would like to write a query to find the last (most recent date) records only from two different fields. No problems using MAX in the ‘Date’ field, the...
February 20th, 2010 09:54 AM
by Allen Browne Go to last post
1 156
Help with complex query by Cam
Hello, I have a Routing query which show all seq of step to complete the part. Another query that show production WIP status. I want to be able to tie them...
February 20th, 2010 06:33 AM
by KARL DEWEY Go to last post
1 131
Same field name in two tables by cluckers
I am running a query that utilizes two joined table. One of the fields for my query is Left( ,3) AS Prefix. The problem is that both tables have a field...
February 20th, 2010 01:51 AM
by David W. Fenton Go to last post
3 177
Can I do this in a query? by Karin
tblNames: id (auto), name tblSvcCode: id, name (there are only 2, 0=nonbill; 1=bill) tblWIP: id(auto), EmpID (linkto tblNames), SVCcode(link to...
February 19th, 2010 11:15 PM
by Jerry Whittle Go to last post
1 128
summarize data in access 2007 by HelpMe!
I have a EmployeeInfo table with 1000 records. Each employee has an autonumber EmployeeID field. Within that same table there are 117 supervisors, identified...
February 19th, 2010 09:05 PM
by Jerry Whittle Go to last post
1 115
Building a query from three tables with differing infomation by SNA400
Hi - Not too sure if this is possible, or if i'm being a dillweed! And please bear with me - it may seem a long explanation but it does get there in the...
February 19th, 2010 08:48 PM
by SNA400 Go to last post
3 136
IIF statement pulling from wrong field by jligue via AccessMonster.com
I have a query have has the 5 variations of the following IIF statement: Bag Total: IIf(" " & & " " Like "* BAG *",,Null) this statement says to add up if the...
February 19th, 2010 08:31 PM
by jligue via AccessMonster.com Go to last post
2 154
Importing Excel data into Access? by Rajeev Rawat
Can Excel data be imported into Access easily!? I know from Word table I can simply copy and paste but it is not that easy when doing from Excel to Access! I...
February 19th, 2010 08:28 PM
by John Caulfield Go to last post
3 255
Query Results Where Qty Shipped is not Divisable by 4 by meangene
How would I construct a query to return all invoices where the qty shipped for a specific item is not divisable by 4? Really its the divisable by 4 part need...
February 19th, 2010 07:43 PM
by meangene Go to last post
4 181
Post New Thread


Display Options
Showing threads 1141 to 1160 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 08:45 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.