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
wildcard by Joel Allen
Hello, I have the following criteria in a query. It will find anything with the letter "H" in it and it works. Like "*H*" I want it to be a a prompt...
February 13th, 2007 12:01 AM
by Joel Allen Go to last post
4 149
IsNull by Mike Will via AccessMonster.com
I've tried and tried to rewrite the following section of my sql statement to no avail using IsNull in place of Nz. I need to use this query in a...
February 12th, 2007 10:27 PM
by Mike Will via AccessMonster.com Go to last post
2 210
how to calculate the field delta between two records in the same table by charlie
Hi, My recent posts have all been related to one single (and I though simple) problem. Basically I need to calculate the delta for a given field using the...
February 12th, 2007 10:10 PM
by John Spencer Go to last post
1 137
Inputing various answers into a Query Prompt. by ChristineN.
I would like to be able to put a criteria into the query which when prompted, will allow me to input data that is not exactly the same as the data in the...
February 12th, 2007 09:41 PM
by ChristineN. Go to last post
2 173
Unwanted parameter dialogue box! by CW
In my Corporates table (and on the associated form) I have a field called Mailshot? and it is formatted as a Y/N. Needless to say, this is to flag which...
February 12th, 2007 09:11 PM
by CW Go to last post
2 140
Adding the data of two columns together. by Roman B.
I have two columns I need to add the data together and place into a third column. for example. Column 1 says - widget Column 2 says - 002 I would like...
February 12th, 2007 09:06 PM
by kingston via AccessMonster.com Go to last post
1 163
Criteria of two field values being equal by B. Meincke
I need to create a query that returns records from a table where the first six characters from one field equals the first six characters from another, and...
February 12th, 2007 07:58 PM
by B. Meincke Go to last post
2 135
Hybrid Autonumber tag for batches of records by efandango
I want to create batch numbers for sets of records driven from a query. I have a query that appends 10 records to a table, which becomes a ‘collection’...
February 12th, 2007 06:59 PM
by efandango Go to last post
0 152
Running a query on a few subtables at once and adding them together (HOW?) by [email protected]
I gave a database that consists of one main table with a few sub tables linked in. and I am having a problem running a query on it. The main table is for...
February 12th, 2007 05:59 PM
by John W. Vinson Go to last post
3 123
subform query by Spring
I am using ID# field as a combobox of unbound field in a form to select and display related information shown at the subform, so a memo field is warpping...
February 12th, 2007 05:52 PM
by Spring Go to last post
0 118
Feild could refer to more than one table? by John T Ingato
Can someone tell me what is wrong with this SQL. When I try to run it I get an error: The specified field '" could refer to to more than one table ilisted n...
February 12th, 2007 05:43 PM
by John T Ingato Go to last post
2 115
Am I forcing the 0's correctly? by Dos Equis
Hi all, Using this code: SELECT tbl_Carrier.CID, & " " & AS Name,Cint(NZ(Count(tbl_Complaint.Complaint),0)) AS FROM (tbl_Carrier INNER JOIN (tbl_Area...
February 12th, 2007 05:36 PM
by Dos Equis Go to last post
5 140
Record Counts in Query level by Jai_Friday
Good Morning/Afternoon to all... A quick question I hope.... Is there a basic function in query level that will put the record number on each record What I...
February 12th, 2007 05:12 PM
by Duane Hookom Go to last post
5 127
Fractional seconds by Jeroen
Hi, I am creating a database for a swimming association and they need to enter 100ths of a second. The problem is, Access does not seem to support fractional...
February 12th, 2007 02:44 PM
by John Spencer Go to last post
3 201
SELECT works with parameter query but CROSSTAB doesn't? by Howard
I have a simple SELECT query that extracts all fields from a table that are within two dates displayed in text boxes on a form. (!! and !! Its called...
February 12th, 2007 02:13 PM
by John Spencer Go to last post
2 203
Equi join by CoachBarkerOJPW
Can anyone give a simple definition of what an equi join is? The text book I am using isn't really clear on how to create one. Thanks CoachBarkerOJPW
February 12th, 2007 01:36 PM
by John Spencer Go to last post
4 122
Append crosstab result to a table by crafty
have following data: 1234 fred client 1234 tom owner 1235 ralph client 1235 bill owner crosstab query result: 1234 fred tom 1235 ralph bill I want to append...
February 12th, 2007 06:44 AM
by crafty Go to last post
2 128
Compare Sets of Data by David127
I have a list of products that have multiple features. Some optional some manditory. I'd like to compare my table of products and features with a reference...
February 12th, 2007 05:48 AM
by John W. Vinson Go to last post
1 136
Popup on Running a Query???? by Bill
Hi All, Is there anyway of getting something to popup when a query is run from the main menu. I appreciate that it can be made to happen through a macro or a...
February 12th, 2007 03:22 AM
by tina Go to last post
3 164
update query by DucateAssignment via AccessMonster.com
Is there anyone that knows how to import a txt file into access and create an update query to update a table? Any help would be appreciated. -- Message...
February 12th, 2007 12:53 AM
by DucateAssignment via AccessMonster.com Go to last post
6 131
Post New Thread


Display Options
Showing threads 20201 to 20220 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 03:44 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.