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
Multiple Queries / Same Criteria by AndrewB[_2_]
I have a main form with 4 subforms. The 4 subforms source are 4 individual queries. When I open the main form I am prompted to enter the...
July 9th, 2009 05:25 PM
by Jeff Boyce Go to last post
3 124
Query to Form View by Eric Starn
I have created a table that holds records of assets for my company. I have also created a form for data entry so a user can add a new asset to the table. I...
July 9th, 2009 05:01 PM
by vanderghast Go to last post
1 78
Calculation Error in Select Query by vg
have created a database for Payments entry for various parties in which I have created a Select Query for obtaining the Bill Details (Advance, Running &...
July 9th, 2009 04:51 PM
by Allen Browne Go to last post
9 187
Add 2 queries by rscosta
Hi I've build two diferente queries with the same fields (they have diferent records). How can I add the 2 queries in just one? Thanks Ricardo
July 9th, 2009 04:40 PM
by Marshall Barton Go to last post
2 108
Previous Months data by gm6243 via AccessMonster.com
Hi, I am using Access 2003 as Front end and Sql backend. I have a cross tab query which spits sales by sales rep for month 1 to mth xx based on the...
July 9th, 2009 04:17 PM
by Jerry Whittle Go to last post
1 95
Creating an "if then" in a query by Jack at ArcLight
Hi All: I have a number value for an investment db that corresponds to the maintenance priority of that investment (priority 1,2 and 3). The higher...
July 9th, 2009 03:55 PM
by John Spencer MVP Go to last post
2 93
Find duplicates query by rscosta
Hi I already search several past threads about this subject, but couldn't find what I'm looking for. Hope you can help me. Here it goes: I've build a query...
July 9th, 2009 02:38 PM
by rscosta Go to last post
4 82
Combine Crosstab Queries? by AGOKP4
Hi, I'm trying to combine 3 crosstab queries, the SQL statements are below and get a report out of it. Is it possible to do it this way or try something...
July 9th, 2009 02:13 PM
by AGOKP4 Go to last post
2 126
short date, short time by Mary
Can someone help me with the display for a date field? I want to display it in short date short time format so it has the date and military time. Example: ...
July 9th, 2009 02:06 PM
by Mary Go to last post
2 75
Compare capitals with non-capitals by PayeDoc
Hellow All I have a table with several thousand records, where one of the text fields 'employee' sometimes is in capitals and sometimes not. Is it possible...
July 9th, 2009 01:34 PM
by PayeDoc Go to last post
7 111
Nested SQL? Need easy to understand "How To" by Eddie[_4_]
In Access, I am currently using two queries to accomplish the following. 1. The first is a summary query. 2. To the output of this first query, I then do a...
July 9th, 2009 11:53 AM
by Eddie[_4_] Go to last post
2 197
Extracting data from field by Alex Hammerstein
Hi I need to extract some data from the middle of a field. Starting at position 8 and ending at 4 characters from the end. I can do the start bit using the...
July 9th, 2009 11:49 AM
by Alex Hammerstein Go to last post
3 79
Query to show all if parameter is blank by Boss
Hi, I run a query which returns me filtered record based on textbox1 value on form (master). I have added the criteria in the design view of the...
July 9th, 2009 10:26 AM
by Boss Go to last post
2 111
Single Query by Ananth
I have 3 year Spend data pulled from the Hyperion in the following format Supplier_ID Site_ID Year Jan $ Feb $ Mar $ Apr $ May $
July 9th, 2009 06:06 AM
by Ananth Go to last post
6 100
Print sub form only by Leo
How do you write the code so that only the subform will be printed when you do not want to go through report format? The sub form displays the seleted...
July 9th, 2009 05:29 AM
by Leo Go to last post
2 81
creating a form by reportyemi
I have a column for patients age on a form that i am creating but during analysis/ reporting I want to report total number of patints ages in age ranges like...
July 9th, 2009 05:27 AM
by MGFoster Go to last post
1 89
DCount by zyzzyva
I use Access 2007 The following works fine, until the counting goes 10 and above I want it the "CD" counted Ascending 1...8,9, 10, 11 and so on What do I...
July 9th, 2009 01:58 AM
by zyzzyva Go to last post
4 117
Trim a field down by Dennis Villareal[_2_]
i think this can be done. i would like to trim a field down that shows the following 2" X 4" X 10 GA 4" X 2" X 3/16" 3-1/2" SQ X .210" 4-1/2" X...
July 9th, 2009 01:22 AM
by John Spencer Go to last post
2 83
Combining Records from the Same Table? by Brad Autry
Pardon me if this has been posted previously, or if this is in the wrong forum. I have one table with records that are somewhat repetitive, however one field...
July 8th, 2009 10:49 PM
by Jerry Whittle Go to last post
1 62
SQL Formatting does not save by Stephen Lloyd[_2_]
Any formatting changes made in SQL View do not save. Is there a way to modify this behavior?
July 8th, 2009 09:45 PM
by Stephen Lloyd[_2_] Go to last post
2 82
Post New Thread


Display Options
Showing threads 4021 to 4040 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 10: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.