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
Is date in between by QB
I have a table 'tbl_scheduled_locations' with three fields 'sl_id','sl_date' and 'sl_loc' so basically the data is 1 12/01/2009 Detroit 2 12/05/2009 ...
December 4th, 2009 08:48 PM
by John Spencer Go to last post
1 131
Number to Number "Data Type Mismatch in Expression" in Join by excelCPA
I am attempting to write a query joining two linked tables in a query by payroll number (all numeric). When write the query and join by payroll number I get...
December 4th, 2009 08:46 PM
by Roger Carlson Go to last post
1 174
Sumarize data in Query like in a Pivot Table by excelCPA
I have a query that pulls in data from payroll and sales tables. Results are similar to the following: Payroll_No L_Name Sale_No Sale_Amt 12345 ...
December 4th, 2009 07:55 PM
by excelCPA Go to last post
7 236
Odd Too few parameters issue by tighe
all thanks for all the help past anf future. my current issue is that i have a query and get the titled error. now the odd part is i have a backup copy of my...
December 4th, 2009 07:49 PM
by tighe Go to last post
2 173
how do you use , by Izzzzy & stacey
How?
December 4th, 2009 07:19 PM
by John W. Vinson Go to last post
2 149
What character(s) is(are) used to preface comments in Access SQL? by John
I want to accomplish as simple task - adding comments in my sql so that it is documented. Nowhere can I find this in the MS documentation or via a web...
December 4th, 2009 06:54 PM
by Bob Barrows Go to last post
4 162
Is there a quick way to create an Update query? by Tony Williams[_2_]
I have a table with about 30 fields. I need to update it with data from another table. I understand how to create an update query but is there a quicker way...
December 4th, 2009 04:39 PM
by Tony Williams[_2_] Go to last post
3 171
hola by iva
Sign Inguille si te llega esto capas que estoy aprendiendo.
December 4th, 2009 06:38 AM
by keidy morales Go to last post
2 173
VAL Function Error by Nicolas M
I have been using the VAL function for a couple years with no problem in Access 2003, but have recently come across a particular sequence of letter and...
December 4th, 2009 03:06 AM
by Nicolas M Go to last post
7 211
Criteria based on checkbox by Paul Washburn[_2_]
Im trying to create a query that will return all results, but will apply filters based on a checkbox. I found the code below from a previous question, but...
(Multi-page thread 1 2 3)
December 4th, 2009 01:24 AM
by John W. Vinson Go to last post
28 583
Update question for a query by bladelock
I have two tables, A-Table and B-Table. A-Table has Names(Text), Numbers(Num). B-Table has Names(Text), Numbers(Num). I want to replace all A-Table with Names...
December 4th, 2009 01:12 AM
by John Spencer Go to last post
9 296
Simply confused - Query stopped working by QB
I have a db that is on it's 3rd year of usage and development. A while back I created a complex report built upon a set of queries. It has always worked...
December 4th, 2009 12:18 AM
by Jeff Boyce Go to last post
7 201
Top N Records minus lower scores by Devon
Hello I am a teacher and am trying to move my students grades from Excel to Access. I plan on using the Classroom management database from MS Office...
December 3rd, 2009 10:53 PM
by Devon Go to last post
8 233
Stacking queries and Calculations by DawnTreader
Hello All I have a general question about how best to do something. I have a lot of queries in my app that do calculations at some point in the stacks of...
December 3rd, 2009 10:18 PM
by DawnTreader Go to last post
3 160
how to append date to table name using mk table qry by Make table query
I am using a make table query to archieve data in a table. I would like to append the date / time behind the table name during the process. What is the best...
December 3rd, 2009 09:04 PM
by John W. Vinson Go to last post
1 128
IIf statement too long. Other options? by Christina[_2_]
In my query I have a field with an iif statement that is too long now. simple ex. IIf(="LA",(-)-, IIf(="NA",(-)-,(-)- )) Is there any way to convert this to...
December 3rd, 2009 08:00 PM
by John W. Vinson Go to last post
4 185
Criteria Filter by LTOSH
I have a database with a column that figures delinquent payment by how many months delinquent based on their last payment. now i am wanting to run a report...
December 3rd, 2009 07:34 PM
by KARL DEWEY Go to last post
4 139
Return records only when all linked records meet criteria by yator
I am trying to write a query that returns all records only when all values are 12.0 ? For example, the query below returns the following sample...
December 3rd, 2009 06:11 PM
by yator Go to last post
6 276
query result in relation with table by Valdemar[_2_]
Hello to all and please help me. I have a database (about 5000 rows) with 10 columns (person, date, time, amount, city, country, category etc..). I would like...
December 3rd, 2009 05:59 PM
by KARL DEWEY Go to last post
4 129
Parameters And Null Values by RedHeadedMonster via AccessMonster.com
I have a query that I wish to return ALL values between 2 dates AND any records that the date happens to be null I have used the following: WHERE...
December 3rd, 2009 05:46 PM
by RedHeadedMonster via AccessMonster.com Go to last post
2 207
Post New Thread


Display Options
Showing threads 2041 to 2060 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 11:04 AM.


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