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
SQL and Query results don't Match by Filo
In a very simple query I entered that I only want to retrieve data for product 200. After the query runs results show results for product 200 but also for...
July 10th, 2008 01:31 PM
by Ron2006 Go to last post
2 255
Microsoft Access 2003 Update Query to a null value by Richard Flores
I have a database that tracks items and who they belong to for work. The person and everything they have been given are entered into a form which updates the...
July 10th, 2008 12:51 PM
by John Spencer Go to last post
2 409
update blank fields by Ra
Hi, I have two imported tables. Table1: CSPC Toolset Month B3851 AB3851 4/1/2008 B3853 AB3851 B4852 AB4852 4/10/2008
July 10th, 2008 11:57 AM
by Ra Go to last post
3 260
multiple condition queries by stuart
morning all hopefully someone out there can offer some assistance i am building an access application in which i wish to be able to intially look at all the...
July 10th, 2008 10:49 AM
by Allen Browne Go to last post
1 303
Conditional Criteria within a query by Kerry
Hi! I've got the following fields and I want the second to contain criteria contingent on the value of the first: Dept_NBR is a number coming from a form...
July 10th, 2008 07:35 AM
by Allen Browne Go to last post
4 213
Conditional IIF question/null value by Kerry
Hi! I've got a combo list in a form which I have the choices of multiple numbers and an ALL choice (21, 22, 23, 24, ALL). I'm trying to use an IIF...
July 10th, 2008 05:42 AM
by Kerry Go to last post
2 287
Offer a Default in a Criteria by Ross[_3_]
Hello all, I want to create a query that offers a Default in the criteria under a Date field, for example: "default as Date today -7" This will allow the...
July 10th, 2008 03:40 AM
by Ross[_3_] Go to last post
2 247
Adding A Leading Space - Update Query by Singinbeauty
Hello, I need to add a leading space in a field to make the entry 6 digits because I have one table being matched to another but on one the WO#'s that have 5...
July 10th, 2008 12:33 AM
by Bob Barrows [MVP] Go to last post
8 277
Crosstab Parameter Decleration by AccessARS
Hello, I have been researching this for couple of days and with some trial and error managed to build this croostab statement. Unfortunately my parameter...
July 9th, 2008 11:24 PM
by AccessARS Go to last post
2 235
IIF/UpdateQuery/AppendQuery??? by susan
This morning I got help with the IIF statement but now it got a little more complicated (to me): the original: If StdPrice = 0, give me "rebill" If Part#...
July 9th, 2008 11:15 PM
by KARL DEWEY Go to last post
1 222
Missing Records in a 2 Table Query by Itenoeth
I have a query where I am combining two tables- "Leads" (contacts) and "Listings" (addresses). Not every Lead has a corresponding record in the "Listings"...
July 9th, 2008 10:18 PM
by Itenoeth Go to last post
2 224
Queries and reports by theIThombre
Hey Gang, Quick question- I have a staff member who is tryiyng to find out which queries are connected to certain reports. She is in the process of printing...
July 9th, 2008 09:21 PM
by Klatuu Go to last post
4 250
Query only showing specific records - i need all - please help by Yula
I have a combo box in a form (Based on a query) that looks up values in the Finish Lookup table. The table has the following info: Finish Description Finish...
July 9th, 2008 09:18 PM
by Michel Walsh Go to last post
5 261
Dues Query by DNork
I have a employee database. In the database, union members are a subset of employees, as such their "member status" is "member" or "member-LOA" while non...
July 9th, 2008 09:10 PM
by Klatuu Go to last post
2 207
Append query for data recovery by Steel Banana
Hi, newbie here. I've recently lost a lot of data from an Access database. I've since recovered it, and would like to combine it with additional data created...
July 9th, 2008 08:56 PM
by BlueWolverine Go to last post
1 187
Concatenate in a query - Access 2003 by Judi
I have a table which refers to two groups of salesmen, District Managers and Sales Service Managers. DM's are over SSM's and both are referred to in the...
July 9th, 2008 08:26 PM
by Judi Go to last post
4 228
crosstab query question by ragtopcaddy via AccessMonster.com
Store # KO# Threshold Start ...
July 9th, 2008 07:37 PM
by ragtopcaddy via AccessMonster.com Go to last post
7 209
Query ?? by dazoloko via AccessMonster.com
Dear All I have a table with the following fields which I have uploaded from a spreadsheet ID Number Reference Type Reference There are two reference...
July 9th, 2008 06:31 PM
by dazoloko via AccessMonster.com Go to last post
3 247
Query INSTR function? by William
I'm using a query and need strip out data. Here is an example of the data I have to work with: 85123147/RS08 85123147W/RS08 TEX-M/SS09 I need my query to...
July 9th, 2008 04:41 PM
by Stefan Hoffmann Go to last post
2 197
Help with calculation flow days by Cam
Hello, I got a query that I try to calculate the number of days at several operation, but not sure how to go about calculating in query. In the query I got...
July 9th, 2008 04:33 PM
by Cam Go to last post
0 212
Post New Thread


Display Options
Showing threads 10001 to 10020 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:57 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 OfficeFrustration.
The comments are property of their posters.