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
data type mismatch by scubadiver
I have a linked table from an SQL warehouse. first query SELECT dbo_Account.OriginalFeeTable, Format(,"mmm") & "-" & Format(,"yy") AS TODate, Val(/100) AS...
September 1st, 2008 04:34 PM
by John Spencer Go to last post
2 117
Run the Delete Query on Exit? by J.Bennett
I have a database that is used to provide quotes for storage buildings. If the customer wants to actually purchase the building, then the user proceeds with...
September 1st, 2008 03:05 PM
by J.Bennett Go to last post
4 227
Show create table by Jay974 via AccessMonster.com
Hi All I'm using Access 2003 and MS SQL server. Does anyone know if there is anything in access which is like the MySQL command "SHOW CREATE TABLE"? --...
September 1st, 2008 02:22 PM
by Bob Barrows [MVP] Go to last post
6 146
Combining queries and expressions to populate and select info by TravelingHT
Dear All I have essentially customers who have pets and go on trips and each trip has many visits and at the visits the pets may have different food or...
September 1st, 2008 03:47 AM
by bhicks11 via AccessMonster.com Go to last post
5 122
COUNTIF equivalent by Sue Compelling
Hi (Using ACCESS2000) I have a field which is populated with either 1, 2 or 3 (this is derived from an option group). (NOTE - my select query incl fields...
September 1st, 2008 02:26 AM
by Sue Compelling Go to last post
6 98
Display crosstab query result with conditional formatting by LBRT
I have read several posts here but none seem to answer this question of mine. I have a crosstab query: shows all kids alpha sorted in four grade levels...
September 1st, 2008 02:21 AM
by LBRT Go to last post
2 138
Check the duplicate records by Dimitris
Hello. There are a lot of duplicate records in a table. I used the duplicate wizard to find them. I also have a checkbox named "dupli". What I need is to...
September 1st, 2008 01:29 AM
by [email protected] Go to last post
1 144
how do I create a Delete Duplicates Query in Access by Howard Maidman[_2_]
I want to be able to delete the second or multiple instance of duplicate records in Access 2007. The query wizard for duplicate records returns all...
August 31st, 2008 07:11 PM
by Ken Sheridan Go to last post
1 117
HOW DO I SHOW ALL NAMES IN ONE OR TWO LINES? by Glint
Hi All, I have a table consisting of records of classes (date/time of lessons, venue, book etc) and a related one for the teachers. There can be up to six...
August 31st, 2008 05:38 PM
by Glint Go to last post
7 100
Error message upon opening database in Vista by Mike B[_3_]
I want to know how to eliminate a warning message that pops up when opening an Access 2003 database in Vista. The database contains many pages of compiled...
August 31st, 2008 09:52 AM
by Allen Browne Go to last post
1 126
Combining Records by Shoelaces
I am sure this is not the optimal manner for doing what I want to do, but my lack of skills has led me to this path. Anyhow . . . I have a query that has...
August 31st, 2008 04:04 AM
by Shoelaces Go to last post
4 136
Access 2003 by Tay J.[_2_]
If I were to look upinformations stored in a table using a query (thru a form) to see if I have previously been to an address, can I have the system ask me...
August 31st, 2008 02:39 AM
by John W. Vinson Go to last post
1 84
Trim in Query Error by Hackneyr
We use queries to extract data from our G/L. Our location numbers are stored in 12 characters, 7 preceding hard spaces and 5 characters. In Access 2003 was...
August 30th, 2008 07:13 PM
by Hackneyr Go to last post
0 98
Subform from query shows all records not just related records by Jojo
My database has two tables - Family and Children which are related showing many children for one family. I created a query to calculate School Year from each...
August 30th, 2008 12:07 PM
by Allen Browne Go to last post
1 107
Finding the value in a string by nadesico
Hi, I am trying to find a unique value in a string. For example, the value in my field is and another has a value of , and I am trying to create a query...
August 30th, 2008 04:29 AM
by nadesico Go to last post
2 86
Duplicate in a querie by Brendanpeek
i need a query that will display the values in the field but i do not want the query to show duplicate values.
August 30th, 2008 01:36 AM
by Brendanpeek Go to last post
2 80
Complex Queries by cybin992000
hi! maybe you guys could help me. i have two tables in msaccess, the first table has two columns, the first column contains the names of columns in the...
August 30th, 2008 12:45 AM
by Jeff Boyce Go to last post
1 81
IIf expression in design by drober
HELP Please... I am trying to build an IIf statement in my design view but can't figure out how to get results compare to skill type. I figure I am on the...
August 30th, 2008 12:23 AM
by drober Go to last post
5 119
Is Iif the right function to use for the following scenario??? by WilliamFence
I am using Access 2003. I have a form that lists states in a drop box. Depending on what state the user chooses, I need to be able to assign an integer to...
August 29th, 2008 11:35 PM
by [email protected] Go to last post
1 120
Display Query by Cyndi
Is it possible to display query criteria on the report that is generated? For example, the query requires the user to enter the start and end dates. Can...
August 29th, 2008 11:11 PM
by Cyndi Go to last post
2 94
Post New Thread


Display Options
Showing threads 9061 to 9080 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:42 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.