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
Count Records in multiple tables by Jeff
I am trying to get a count of Appointments from multiple tables using this statement - when I try to run it I get the unspecified expression...
March 16th, 2010 02:36 PM
by Jeff Go to last post
2 189
SQL totalling items report by Spike
I will be very grateful if someone will give me the SQL to run a query using the Northwind data base that will produce a report that shows totals of “Units...
March 16th, 2010 02:00 PM
by John Spencer Go to last post
1 213
'Type Mismatch' Error- PLEASE HELP by khanner
we have a macro setup to update data info by uploading an excel spreadhseet in the access database. However when i try this, i get a 'type mismatch' error....
(Multi-page thread 1 2)
March 16th, 2010 01:53 PM
by John Spencer Go to last post
13 467
multiple one to many by Papa Jonah
I have a database with multiple tables that are populated with a form with subforms. Basically I have Table A with a record ID field that has a one to many...
March 16th, 2010 01:19 PM
by Krzysztof Naworyta Go to last post
2 205
How do u create criteria with a LIKE "xxx" or/and by stacy sin
I would like to find out how to use Query to filter out selective data like start with an alphabet "d" and "e"? How do I define in my query?
March 16th, 2010 01:16 PM
by Krzysztof Naworyta Go to last post
2 212
Query not showing certain records by Charlie
HEEELLLLP I have a query which is used to feed to certain reports. It gathers information from 4 related tables and has a criteria under the order number...
March 16th, 2010 03:52 AM
by Ken Snell Go to last post
5 355
Show maximum date in a query/report - JCW by JohnW
I am having trouble with a query/report that I run that should show the last payment date that a tuition payment was made. It works for most records but for...
March 16th, 2010 03:46 AM
by JohnW Go to last post
4 244
Adding up row values by kthomas
I am trying to add up all "fertilizer" costs by customer name. However, I am getting 3 results per customer due to there being 3 types of fertilizer. How...
March 16th, 2010 03:00 AM
by John W. Vinson Go to last post
4 197
Remove dublecate post by Highlight between 3 fields[_2_]
Hello I have Table with two columns "Eng" and "Arb" I found that contain dublecate posts with same information. Is it possible to keep only one post that use...
March 16th, 2010 01:05 AM
by Highlight between 3 fields[_2_] Go to last post
5 225
Identify Missing Time Ranges and create a record to account for it by brad5118 via AccessMonster.com
Hello Everyone, I have a scheduling system currently in use that is working fine, but I have been asked to improve upon it to reduce the manual additions made...
March 16th, 2010 01:04 AM
by brad5118 via AccessMonster.com Go to last post
0 250
Problem Passing Parameter from Form by autigger
If I hard code in the following into the critera: Like * Any record that starts with T is not returned. If I pass the same thing, *, from a form to: Like...
March 15th, 2010 10:23 PM
by John Spencer Go to last post
3 182
Update Query by Marc
I have two tables, Employee and Gaptable. In the employee table I have a SSN field (social security number) a UPI field (unique personal Id numer) I want to...
March 15th, 2010 10:08 PM
by KARL DEWEY Go to last post
2 205
"is not a valid name. Make sure... by AndrewB[_2_]
I just started getting the error message: "is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too...
March 15th, 2010 08:13 PM
by Scott Go to last post
5 356
Parameter in a critiria by Dan
We do 3 different types of estimates, Cut, LCP & Misc with any possible combination of them (7). I want to see how estimates were done for a specific day. ...
March 15th, 2010 06:38 PM
by John Spencer Go to last post
3 168
Multiple Tables in Query not Listing Data. by Ty
I cannot seem to get this correct. I am trying to run a query on two databases one of which is linked to the other. I am trying to get the query to display...
March 15th, 2010 06:36 PM
by KARL DEWEY Go to last post
2 173
create dropdown based on all people Not selectedyet to work onWork by babs
I have a dropdown based on all employee. Once the person is Scheduled to work on a given Workdate (of the record I am Sitting on ) field Name is workdate I...
March 15th, 2010 05:41 PM
by Jeff Boyce Go to last post
3 226
query too slow by angie
i have a table with 500000 records. it consists of pricelists from various suppliers so i have duplicate products with diffrent prices and supplier...
March 15th, 2010 03:33 PM
by Jerry Whittle Go to last post
1 212
Edit and save query criteria by DNuding
I have 2 Select queries where the results criteria changes on a yearly basis for 2 fields. There are 6 tables referenced in the queries. Only 2 tables...
March 15th, 2010 03:08 PM
by DNuding Go to last post
6 270
How do I execute multiple SQL statements in Access?? by nickB
I want to create a query that will use a series of INSERT statements to update the database. Each INSERT statement will create a new product record in the...
March 15th, 2010 09:51 AM
by david Go to last post
3 226
Parameter Queries by goodgirlinterrupted
When you put in the Enter criteria for a query so that the user will have to enter information first, such as entering a start date and then a finish date,...
March 15th, 2010 07:38 AM
by John W. Vinson Go to last post
2 214
Post New Thread


Display Options
Showing threads 861 to 880 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 01:54 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.