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
how truncate one table so i can make a relationship with another by ANDY CALLAGHAN
I have several tables that are linked with a common field, but one particular table needs formatting to make a relationship possible.eg table order number...
October 15th, 2006 08:36 PM
by John Vinson Go to last post
2 79
a little complicated for me by Claes D
Hi. Since I'm just a novice, I need some help with this. In a query, I need to have a category on each article. The Category is based on the size and code of...
October 15th, 2006 03:29 PM
by David F Cox Go to last post
4 101
Show records with dates 30 days old by Lewis M
I need to know how to build an expression or use a date/time function in a query to show records with a date that is more than 30 days old.
October 15th, 2006 11:30 AM
by Lewis M Go to last post
6 84
Query, Qty Reorder level I want "Order Now" to show. syntax? by Buzz
Using MS Access 2003, I want to create a query from two fields. When my quantity on hand field becomes less than my reorder level field, I want "Order Now to...
October 15th, 2006 03:52 AM
by David F Cox Go to last post
1 101
want to only see dates for today and the past by greeneyedladynj
I have a list of employees and several classes that they need to become recertified for yearly... In the fields I have the due date for their recerts. Some...
October 15th, 2006 02:37 AM
by Tom Lake Go to last post
1 96
if null or zero by sierralightfoot
Simple but I can't get it: if is null or equal to zero, then , otherwise
October 14th, 2006 09:02 PM
by Gina Whipp Go to last post
9 133
Totaling Query by F1stman
Hey all, Let me try to explain this. I am creating a query to take the sum of transactions for a certain ID# in one table and subtract them from the original...
October 14th, 2006 06:53 PM
by F1stman Go to last post
3 79
i have a database where records are entered daily. how do i total by sz
i have a database where records are entered daily. how do i total a figure in a specific field and then sort it by date
October 14th, 2006 03:41 PM
by Kc-Mass Go to last post
3 72
Data in table but not in Query/Report by magicpatel
I have a form that saves data to various tables using code, and this all seems to work. But when i try to run a query on some of the tables, some data...
October 14th, 2006 03:10 PM
by Jerry Whittle Go to last post
3 65
SQL query for Access.MDB file doesn't work,F1 by AleXmanFree
Hello World. I have code that connects to Access file (.mdb) and executing query that returnst table to my code, it has no matter here but code is on C#, and...
October 14th, 2006 12:08 PM
by AleXmanFree Go to last post
1 64
exporting to excell by Neal
Hello, I have a query that excel pulls from. When excel pulls the data I lose all formatting in the cell and then have to go through each line and hit...
October 14th, 2006 08:01 AM
by Naveed Pathan Go to last post
1 76
Date Criteria - Last Month same day by yasser
I'm trying to run a query from the Sales Table that will give me a snapshot of today's sales. I want to compare today's sales with sales from one month ago,...
October 14th, 2006 05:02 AM
by Van T. Dinh Go to last post
2 59
query speed / table design by Jim
I have two HUGE tables that don't have keys but are indexed (Yes (Duplicates OK)) on the fields I use for the join and select. There's no keys because these...
October 14th, 2006 02:10 AM
by Dale Fye Go to last post
6 83
Totaling Query by F1stman
Hey all, Let me try to explain this. I am creating a query to take the sum of transactions for a certain ID# in one table and subtract them from the original...
October 14th, 2006 01:41 AM
by David F Cox Go to last post
1 68
append query record repeats by [email protected]
I am using an append query to append 15 records to a table. Access wants to append those records 1000's of times. Every field in the importing table is used,...
October 14th, 2006 12:04 AM
by [email protected] Go to last post
5 79
Duplicates numbered but with a new condition by Céline Brien
Hello all, From the table Color, ID Colors 1 red 2 red 3 red 4 green 5 green 6 Blue 7 ...
October 13th, 2006 11:59 PM
by Céline Brien Go to last post
4 120
How to create a [Select] Transfer Text in a Macro by ACWOKING
I have a switchboard on my Access DB. One of the buttons on this form runs a macro. This Macro Transfers Text into Access using a predefined spec. The...
October 13th, 2006 10:51 PM
by Van T. Dinh Go to last post
3 65
split text in access 2000 by Stupid and can prove it.
My Access 2000 database has a field that contains variable quantity of chars ending with an alpha "A". I want to remove the "A" at the end of each one. ...
October 13th, 2006 10:47 PM
by Stupid and can prove it. Go to last post
2 72
Group by Two Fields, Sort Field1 by a seperate Sum, then Field2 by SEdison
Let's say I have a table….with 3 fields... State, City, Popluation I have a query where I've group by State, then Grouped by City, then have a value of...
October 13th, 2006 10:26 PM
by KARL DEWEY Go to last post
1 68
Not updatble query by Raul Sousa
Dear all I have the fowling query statement, returning a non updatable query. I can not understand is it not updatable. SELECT FacturaVenda.NIF,...
October 13th, 2006 09:06 PM
by Jerry Whittle Go to last post
1 69
Post New Thread


Display Options
Showing threads 23001 to 23020 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 04:06 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.