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
Select fields on a form and put this data into a specific table. by Stefan van der Hooft
Hi! I’m trying to find the answer to this problem: I made a form where users can put their data in. This form has a date-field, a text-field and a field...
February 23rd, 2007 02:54 PM
by Michel Walsh Go to last post
1 129
multiple statements updating a table with multiple values by Millbrook School
Im trying to do this UPDATE INNER JOIN Software ON . = Software. SET .Software = " " UPDATE INNER JOIN Software ON . = Software. SET .Software =...
February 23rd, 2007 02:53 PM
by John Spencer Go to last post
2 107
Query Combobox Problems by UnderSeven
This is the code of my query: SELECT Table.Column FROM Table INNER JOIN Othertable ON Table.Column = Othertable.Column WHERE (((Table.Column)=!!.)) ORDER BY...
February 23rd, 2007 02:09 PM
by John Spencer Go to last post
2 108
CONVERSION DATE PROBLEM by Lucio
I have a txt file where the field is of the format 'dd-mmm-yy'. For example 04-MAY-04 When I import the file, it automatically detects that the field should...
February 23rd, 2007 01:59 PM
by John Spencer Go to last post
1 120
non-match query by johnny vino
I'm comparing two tables and I would like to see all the records where first and last name DON'T match. I know there are several instances where names...
February 23rd, 2007 08:12 AM
by John W. Vinson Go to last post
6 130
Query OVERFLOW Error by John D
I've tried as best I can to follow suggestions in this forum about "fixing" the Overflow error I'm getting in my query, but so far no good. I have a table of...
February 23rd, 2007 02:38 AM
by John Spencer Go to last post
6 173
Weighted Averages by Casa
Hello everyone; I have a query which links drilling sample intervals and geochemical results. I would like to average these results so that I highlight...
February 23rd, 2007 02:28 AM
by Smartin Go to last post
1 136
Calculating expressions between two dates by JCowell
(!) Between Date()-14 And Date()-8 I'm using the above statement as a criteria in a Query. It is not working and I'm getting errors. What I want to do is...
February 23rd, 2007 02:14 AM
by Ken Sheridan Go to last post
2 105
Append Queries by ray
I have an Append query that counts members. I have a table preset with a 0 count. If my append query finds no records, it deletes the row in the table with...
February 23rd, 2007 01:57 AM
by ray Go to last post
4 115
Query help by Bec_FS
I have run a query, but it took me multiple steps to get the answer I wanted. I was wondering if there was a way I could of gotten the answer in one simple...
February 23rd, 2007 01:41 AM
by Dale Fye Go to last post
3 103
IMPORT date from text file by Lucio
I have a text file that contains a field of the type 'dd-mmm-yy' When I import, it notices it is a date/time field It does not load. It returns a conversion...
February 23rd, 2007 12:39 AM
by Lucio Go to last post
0 86
Excluding by gmore
Hello, I've got a table containing suppliers (two fields: supplier_code and supplier_name) and another one containing suppliers' codes to exclude from...
February 23rd, 2007 12:30 AM
by gmore Go to last post
2 101
Searching mdbs for queries by Harry V
Is there a way to search mdb files for query names from Windows Explorer? -- Harry E Vermillion IT2 Division of Wildlife State of Colorado
February 23rd, 2007 12:23 AM
by Jeff Boyce Go to last post
3 151
iif statement in query by Joel Allen
Hello, I'm trying to use an "OR" in this iif statement and it's not working. Can somebody please help? My goal is: if ProductResultBDHC contains C or P,...
February 22nd, 2007 11:05 PM
by John W. Vinson Go to last post
4 159
Subqueries and ranking by Gina K
I'm ranking records in a query, but I'm having a little trouble getting the ties to display the way I want. Here's the sql: SELECT tblEventResults.fkAthlete,...
February 22nd, 2007 11:01 PM
by Gina K Go to last post
3 104
parameter message by Alan
Hi folks, In my query, I created a field to pass a value into to use for a calculation elsewhere. Everything works fine but when you run the query, it comes...
February 22nd, 2007 10:59 PM
by Alan Go to last post
2 129
How do I search for a specific year in a query? by CaptAdmCoy
I am using a Membership database in Access 2003. I have a Date field created and want to find all records in that date field with a specific year. The query...
February 22nd, 2007 10:58 PM
by KARL DEWEY Go to last post
2 117
crosstab query and main table by doran_doran
Here is the db with sample data. http://download.yousendit.com/AAA18BC7520F196E I want to use qryCrosstab and table "ALL" to achieve the result that...
February 22nd, 2007 10:23 PM
by doran_doran via AccessMonster.com Go to last post
3 152
Format the query results by Caledonia
I'm currently using Access 2k; I probably was using an earlier version at my last job. I thought that I used to be able to click on the field properties in...
February 22nd, 2007 09:25 PM
by Caledonia Go to last post
2 114
Update Query Question Need Help by totallyconfused
I have an update query that I use to update a table with data from another table. However, my "Finish" table is a checkbox (0 and -1). When I run the query...
February 22nd, 2007 09:04 PM
by Jason Lepack Go to last post
6 128
Post New Thread


Display Options
Showing threads 19941 to 19960 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 09:09 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.