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
Cannot Delete From Specified Tables by Dave
I've got a VB.NET app that needs to delete all the records from a single, unlinked Access table. The table has one field (non-key) of type OLE object. When I...
September 20th, 2005 03:53 PM
by Dave Go to last post
3 133
Replace two fields into one by bladelock
I have three fields (all three text) in a table "a1", "a2" and "a3" How can put all for a1 Plus (combine) a2 into a3 with a query? Thanks
September 20th, 2005 04:20 PM
by bladelock Go to last post
5 105
Simple Expression Question by QRATRAINER
I keep track of training sessions in a table. I want to run a query that will prompt me to enter in a Last Name, then First to list all training sessions that...
September 20th, 2005 05:17 PM
by QRATRAINER Go to last post
2 95
Time/Date by Jay
My table has a TimeInSec field (Time/Date datatype). This field has ALL NEGATIVE numbers in seconds. I used the following expression to change to regular time...
September 20th, 2005 05:51 PM
by Marshall Barton Go to last post
3 93
Format Yes/No fields after Union by DD
I have 2 tables which have a field whose value is either Yes or No. After performing a UNION query on both these tables the corresponding resuting field shows...
September 20th, 2005 06:17 PM
by Marshall Barton Go to last post
1 87
Make table query with derived fields by Andy
I am trying to create a make table query that contains an end value dervied from numberic fields within the table. I have 9 different columns where I need to...
September 20th, 2005 06:22 PM
by Marshall Barton Go to last post
1 111
September 20th, 2005 06:25 PM
by SusanV Go to last post
3 84
Date restrictor for this week by ChuckW
Hi, I want to create a report that will always give sales for the current week starting with monday and going to friday. We are closed on Saturday and Sunday...
September 20th, 2005 06:39 PM
by John Vinson Go to last post
1 85
Delete query by Bob
I have a table. the table has a field called "product_id". there are many records with the same product_id. I would like to run a query that will delete all...
September 20th, 2005 07:21 PM
by Ofer Go to last post
1 80
Variable Table name by SLeach
Hello! I am looking to create an SQL statement, or anything else, that would allow me to create tables with a variable in their name. For example, I want to...
September 20th, 2005 07:48 PM
by SLeach Go to last post
5 113
Dynamic Set Query Feild Properties by Aron
I designed a query with over 60 columns I need too enter information in each columns for the 'Description Property' is there a way to add info into...
September 20th, 2005 07:49 PM
by '69 Camaro Go to last post
3 110
How to add just one field by Bob
I have two tables. They both have a field "Product_ID", and are linked on this field. One table has a field Vendor, every record in this field is empty. The...
September 20th, 2005 08:19 PM
by Rick B Go to last post
1 73
name query by Rowan
I have a query with 50 peoples names in, some names appear more than once. What I want to do it to show all names that appear more than once and not show any...
September 20th, 2005 08:20 PM
by Chaim Go to last post
1 77
date parameter by Jim
I have a query built with a "start date" and "end date" parameter. What can I enter in the "end date" to allow the query to run through "current?"
September 20th, 2005 09:41 PM
by Chaim Go to last post
2 110
Need help with updating with value from another database by Alpha
I'm getting error about 'missing opeartor' with my query below. Appreciate it if someone can help me out here. Thanks, Alpha UPDATE VehDetail set ...
(Multi-page thread 1 2)
September 20th, 2005 10:09 PM
by Alpha Go to last post
12 220
Payroll Dates by [email protected]
I'm trying to set up a cross tab query with the column headings as payroll dates (ex. 1/15/2005, 1/31/2005...etc). Is it possible to do this programmatically?...
September 20th, 2005 10:09 PM
by [email protected] Go to last post
4 121
Return Latest Quarterly and Monthly info. by spartanmba
Hello, I have a table with the follow data: Store Quarter Month Sales Percent ID 245 2 5 3.5% ...
September 20th, 2005 10:15 PM
by spartanmba Go to last post
2 128
How do I fix Access Error undefined function "CStr$" in expressio by Compeer buddy
I am using the 2003 Office Professional Package In running a query in Access the following error message pops up Error(3085) - Undefined function"CStr$" in...
September 20th, 2005 11:36 PM
by Douglas J. Steele Go to last post
1 208
Searching for records that do not exist yet by Sarah Stockton
I have 3 tables "Owner", Business" and "Annual Fees". They all have a one to many relationship ie. one owner to many businesses and one business to several...
September 20th, 2005 11:46 PM
by Sarah Stockton Go to last post
4 125
Running a query against it's own base table by Jay
I am developing an application which is sort an inventory system. What I need to do is load last month or weeks data minus the new product additions. This, I...
September 21st, 2005 12:33 AM
by David S via AccessMonster.com Go to last post
1 80
Post New Thread


Display Options
Showing threads 10181 to 10200 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 02:34 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.