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
Looking for Existing Records by Anders
Howdy, What type of expression do I create if I want to search a table (take customers) to see if someone already exists? My customer table contains the...
July 6th, 2009 01:51 PM
by TedMi Go to last post
2 144
I need to divide a query by rherhecg1
I need a formula to figure out the number of hours someone has worked (YTD/Hourly Rate)....I am stumped as to how to do this. Any help would be...
July 6th, 2009 04:24 AM
by John W. Vinson Go to last post
1 148
Set update query to reduce single field by user defined number by Anders
Greetings, I am looking for the best way to update my inventory on hand for a specific product after I make a sale. I have a customer form with an order...
July 6th, 2009 12:28 AM
by Anders Go to last post
2 92
Union query, combine all 4 fields into 1 field by efandango
I have a union query: SELECT tbl_Points.Run_No, tbl_Points.LeaveBy1, tbl_Points.LeaveBy2, tbl_Points.LeaveBy3, tbl_Points.LeaveBy4
July 5th, 2009 01:59 PM
by John Spencer Go to last post
5 125
Compound Indices by JimS
If I create a compound index on a table with, say, 2 columns in the index, then join it to another table using both columns, will Access automatically use...
July 4th, 2009 06:18 PM
by Jerry Whittle Go to last post
2 100
Random performances of same query?? by Ahmed Kendoussi
Question to an expert... I have built a query that inserts something like 50.000 rows into a table and i can notice that most of the time it executes without...
July 4th, 2009 06:13 PM
by Jerry Whittle Go to last post
2 116
how to output Access table to a text document? by Michelle
I have an Access file. When I open it up, and click on a Table, data shows up in field columns, where some field columns may have 1 word in it, some fields...
July 4th, 2009 04:15 AM
by fredg Go to last post
2 125
A form for selecting tables by Ben
I currently have a group of about 20 tables; each table is essentially a question bank for different vehicle parts, and there is no relationship to one...
July 4th, 2009 12:24 AM
by tina Go to last post
3 168
show all results even when null for each name by B
How can i display all names in the table even when there are no records that meet the parameter? When there are no records i want to show 0 not null...
July 3rd, 2009 06:30 PM
by Alvar Rodriguez Go to last post
6 227
Query Trouble by MLT[_2_]
I've got a table with the following columns: TagID, Date, Measurement. So for each TagID, there are multiple Times and associated Measurements listed. What...
July 3rd, 2009 05:45 PM
by MGFoster Go to last post
1 98
Multiple IIF query by snowball
I am trying to do a calculation in access to look at machine efficiency, my problem is i have a number of possible process steps to look at and calculate I...
July 3rd, 2009 04:03 PM
by snowball Go to last post
1 93
Output a user entered value by Andy
I have a make table query with some dates in it. The user-entered field is set as a 'where' field where they enter a month end date. I want this entered...
July 3rd, 2009 03:26 PM
by John Spencer Go to last post
3 101
DateDiff calculation by snowball
I am trying to get an efficiency figure calculation from a start time less a finish time less the sum of personal breaks and m/c breaks. Start time =...
July 3rd, 2009 02:21 PM
by snowball Go to last post
2 109
Selection Box's ? Noob question ..... please help ! by harp_s45
Hi Im a noob to access and this forum so I will apologise if his is a stupid quyestion or if this has been answered else where. I am putting together a...
July 3rd, 2009 01:43 PM
by Ken Snell [MVP] Go to last post
1 164
Query to retrieve top 2 of the Name & marks by Kumaresan
Imput Table example Eg: Table1 Id Name Marks 1 Test 50 2 Test 75 3 Test 60 4 Test1 85 5 Test1 95 6 Test1 90
July 3rd, 2009 09:08 AM
by Kumaresan Go to last post
5 151
change currency symbol by enrico via AccessMonster.com
my data property of my amount field is currency. when i query the sum of the amount a dollar sign will represent the whole sum. can we change the dollar sign...
July 3rd, 2009 07:02 AM
by fredg Go to last post
1 161
How to display an age in query based on Datediff expression in a f by Natahn
Help! I am kind of a novice at Access and need to display an age in a query, based on the Datediff formula I have in a form (.mbd), but all I get are...
July 3rd, 2009 06:01 AM
by Natahn Go to last post
2 109
Syntax error in append query by Frank Situmorang[_3_]
Hello, I can not save my following append query, with the error message " Syntax error on INSERT INTO statement. I presume because I wrongly name my field "...
July 3rd, 2009 03:02 AM
by Frank Situmorang[_3_] Go to last post
2 123
Count person only 1 time and show person not counted by Tina S
A manager needs to sit with each of their employees once a quarter. In the past, we have said if a manager has 8 employees, they need to have 8 sit alongs...
(Multi-page thread 1 2)
July 3rd, 2009 02:01 AM
by John Spencer Go to last post
10 269
Pull Column 1 from a combo Box and display in a Query! by Marcelo
Hello, I want to display Column 1 of my Combo box in a Query. Query----- Error @ !! SELECT DISTINCT tbl_FC_ImportData_2a.AssetID,...
July 2nd, 2009 09:49 PM
by Marcelo Go to last post
5 132
Post New Thread


Display Options
Showing threads 4081 to 4100 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 08:23 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.