Issue in create a certain query
Hi,
I have 2 tables: tblRecord and tblRange
tblRange contain 4 field:
fldCode, fldStart, fldEnd
fldCode (Text)(Only Manager will know the code, User will not know about | | 0 | 8 | 11/11/2009 7:10:42 AM |
Outstanding Drafts
In the course of our business process, we have to draft some documents and
send them to another department (DJ) for advice. I have a table called
"tblDrafts" for recording the mov | | 0 | 8 | 11/11/2009 6:59:54 AM |
crosstab query with Sum -conditional
Hi, All
my query:
PARAMETERS [Enter Start Date] DateTime, [Enter End Date] DateTime;
TRANSFORM Nz(COUNT(Master.TickNo),0) AS CountofTicks
SELECT [Shield] AS Badge, Sum(Master.AmtVl | | 0 | 5 | 11/11/2009 3:38:35 AM |
crosstab with conditional SUM()
Hi, All
my query:
PARAMETERS [Enter Start Date] DateTime, [Enter End Date] DateTime;
TRANSFORM Nz(COUNT(Master.TickNo),0) AS CountofTicks
SELECT [Shield] AS Badge, Sum(Master.AmtVl | | 0 | 8 | 11/11/2009 3:38:34 AM |
Wrong Database Design
Dear All,
Currently I ask myself if the design of my database is wrong.
I have several tables with a lot of fields which use 'Value List' as a row
source type. Each of my r | | 0 | 8 | 11/11/2009 3:38:33 AM |
Crosstab query with multiple fields
Hi, All
My query:
PARAMETERS [Enter Start Date] DateTime, [Enter End Date] DateTime;
TRANSFORM Nz(COUNT(Master.TickNo),0) AS CountofTicks
SELECT [Shield] AS Badge, Sum(Master.AmtVl | | 0 | 9 | 11/11/2009 3:38:32 AM |
Grand Total in a Query
I have a table with two fields Class Type and Number Of Students.
I have a query that totals the Number of Students by Class but how do I get
a grand total of the Number of Students for all | | 0 | 7 | 11/11/2009 3:38:32 AM |
Date parameter question
I have a query that pulls data. What I am trying to get it to do is
pull the data greater than a specific date. Is there a way to do it
other than just entering the date in the criteria fiel | | 0 | 13 | 11/10/2009 8:34:32 PM |
Export Query To Excel Problem
Hi,
I have the following code to export a query to excel using a command button.
It was working well. Now user tells me he can't get it to work. If I log
on to the database, i | | 0 | 12 | 11/10/2009 7:56:40 PM |
Query Service History/Future Dates
Trying to setup a query which takes into account a list of cars using reg
numbers:
1 ----
2 ----
3 ----
4 ----
5------
up to 100+ cars
each c | | 0 | 16 | 11/10/2009 6:04:40 PM |
Appendding to/from Upsize_ts (time stamp) field
I am working with MS Access 97, with a SqlServer linked tables. I need to
append data from tblA to tblB, both of them link tables.
I created a new Append Query, but the append fails, I thin | | 0 | 13 | 11/10/2009 4:16:24 PM |
Make Table Query Truncating Memo Field at 255 Characters
I have a lot of data in an Excel spreadsheet that I want to analyze
with Access. Many of the data fields are >255 characters. I
understand linked tables to Excel in Access will truncate | | 0 | 13 | 11/10/2009 4:06:15 PM |
Process to modify multiple queries simultaneously
Greetings,
I have 10 DELETE queries set to remove data based on the MONTH field. The
month to be deleted is stored in the Criteria. My question is, is there a
query function wh | | 0 | 16 | 11/10/2009 3:40:11 PM |
Age calculation in Query
Access 2003
I am trying to calculate the age of a person directly in the query.
Not sure it is possible but here is what I have tried that does not work.
---
Age: today()-[DO | | 0 | 13 | 11/10/2009 3:40:11 PM |
update and append queries
I created a few 2007 access queries that would append or update
various tables. This is working fine on one machine, but when I
installed access 2007 on another machine and try to run the ex | | 0 | 11 | 11/10/2009 3:20:30 PM |
Summary Queries
I'm trying to run a simple summary select query to effectively filter out
multiple occurrences of database records by Grouping them via the "First"
criteria. For some reason, th | | 0 | 16 | 11/10/2009 2:26:21 PM |
select distinct fulladdress
I need to select distinct on the fulladdress and I can't remember how to do it.
I only want 1 of each distinct address in my list.
help PLEASE! ;}
SELECT tblArea.AreaName, [ | | 0 | 13 | 11/10/2009 2:04:23 PM |
Finding Matching data
I have the following data;
Order Code Order Detail
100 AA
101 AA
100 BB
102 AA
1 | | 0 | 16 | 11/10/2009 11:56:08 AM |
Lost in time!
I'm having difficulty in understanding times (although I've used them
many times before) and getting the results in a query.
Here's what I have. I have a db of accounts that have been | | 0 | 11 | 11/10/2009 10:20:34 AM |
Query Service History/Future Dates
Trying to setup a query which takes into account a list of cars using reg
numbers:
1 ----
2 ----
3 ----
4 ----
5------
up to 100+ cars
each c | | 0 | 13 | 11/10/2009 8:50:27 AM |
Data type mismatch in criteria expression issue
Hi,
I have a query call ListRecur where it will Caculate the date when the entry
is going to recur
Below it the query Field information
DetId (FieldName same as table, | | 0 | 14 | 11/10/2009 8:10:29 AM |
Data type mismatch in criteria expression even the datatype is the same
Hi,
I have a query call ListRecur where it will Caculate the date when the entry
is going to recur
Below it the query Field information
DetId (FieldName same as table, | | 0 | 9 | 11/10/2009 8:05:25 AM |
Last record by text field of an unsorted table
I have the followinig simple quwery:
SELECT M2001.LASTNAME, M2001.FIRSTNAME, SESSION1.Date
FROM M2001 INNER JOIN SESSION1 ON M2001.RECNUM = SESSION1.LINKNUM;
M2001 has 1 - t | | 0 | 13 | 11/10/2009 7:43:42 AM |
Join Queries Involving a blank field
I need to run a join query looking for all entries in Table B that correspond
to the same address is Table A. The common fields are StreetNumber,
StreetName and StreetType. It is a join sh | | 0 | 83 | 2/6/2008 8:12:04 PM |
Concatenate fields from multiple tables
I am attempting to use Duane Hookom?s concatenate function without any
success. I?ve read many threads, relating to Duane?s function, yet none seem
to fit my situation.
I am workin | | 2 | 158 | 2/6/2008 8:09:02 PM |
Multiplying field in query
I have a field that is called MH depth which list the depth in #ft'#in". I
need to convert this to inches, but do not know how to set up the query to do
this (bring out the numbers to multi | | 0 | 78 | 2/6/2008 7:57:06 PM |
Crosstab Query for Beginning Date and Ending Date
I have several crosstab queries were the end user will be selecting a report
by month. I have declared the parameters of [Beginning Date] and [Ending
Date] in the query and it works great b | | 5 | 89 | 2/6/2008 7:31:01 PM |
Date Range Totals for Logical Fields
Hi All:
I have a database I import from Outlook, and am keeping a list of all active
recruits. Each week, I need to update 10 logical fields to see how many more
entries were made | | 5 | 82 | 2/6/2008 7:28:03 PM |
RE: Counting Records
I have this query and I want to be able get a stop count.
SELECT tblInvoiceHistALL.[Customer Number], tblInvoiceHistALL.[Ship Date],
Count(tblInvoiceHistALL.[Customer Number]) AS Stops< | | 1 | 76 | 2/6/2008 7:26:17 PM |
upon submit, run duplicate query and display a pop up listing of d
In my Access 2000 database, I have a form for entering data on people who
register for an event. Key fields are "First Name", "Last Name", "Event
Code". I am tracking multiple events. | | 2 | 74 | 2/6/2008 7:23:39 PM |
read-only on attempted update
I'm using Access 2003 SP3. Run Permissions are set to Owner's, User and
Group Permissions are set to Updata Data etc. When I try to update, I get
Error 80040e09, "Cannot update. Database o | | 0 | 86 | 2/6/2008 6:57:02 PM |
combobox in query
Hello everybody, I have a question concerning the "Enter Parameter Value"
window that opens when I run a query.
Is it possible to have that as a combobox so that a list of possibilities is | | 9 | 69 | 2/6/2008 6:45:50 PM |
listing records from 2 database tables even if there are no values in
I hope that this makes sense, but as an example:
I have 2 databases. The first one (db1) contains Product Name &
Serial Number. The second (db2) contains Serial Number and Price (but | | 2 | 85 | 2/6/2008 6:20:42 PM |
Access Query: evaluate a determined value against age & place %til
I need help creating a query in MS Access 2007 that will take a determined
value (FC) and run a query against it showing what percentile the value
should fall into based on person's age? Is | | 10 | 74 | 2/6/2008 6:03:20 PM |
Non MR's and Blanks to show
Good afternoon,
I have a table that shows the following text fields -
Date - Associate - Status - StatusCode - Method -
each of these fields are text fields (except for date is D | | 3 | 85 | 2/6/2008 5:50:27 PM |
query question
Hello All
I have a table that has the following data in it.
Production Date Size Break Type Location
2/1/07 11oz Other Pre-Filler
| | 3 | 69 | 2/6/2008 5:45:02 PM |
Exclusion with an exception?
I have filtered a query to exclude a particular product, however, I have been
asked to make an exception based on a customer name. I tried an IIF
statement, but I get the "too complex" erro | | 2 | 79 | 2/6/2008 4:41:46 PM |
Previous record in Query
Hello,
I have query table wherein it has some calaulated fields. Some of it as
follow_
Tonnage Length FromSta ToSta
500 400 1200 1600
300 | | 7 | 84 | 2/6/2008 4:39:35 PM |
can you do txt to columns in access?
| | 1 | 72 | 2/6/2008 4:39:18 PM |
Queries and Now()
Hi
Using Access 2007.
I have a database in mdb format that records the information of customer
sales on a web site. In the OrderDate field I am using Now() to record the
d | | 4 | 85 | 2/6/2008 4:24:35 PM |
Concatenate fields from multiple tables - repost
// reposted: to straighten table data //
I am attempting to use Duane Hookom?s concatenate function without any
success. I?ve read many threads, relating to Duane?s function, yet none seem < | | 0 | 115 | 2/6/2008 3:37:02 PM |
Table Linking
I'll start out the question with what I'm trying to accomplish. Basically,
I've created a form that populates data into a table (lets call it table 1).
I want to be able to reference this | | 0 | 74 | 2/6/2008 1:54:01 PM |
yes/no field in query
Access 2003
I want to print label based on select query. The query pull out, for
example, 10 records. I want to use a form for user to check which of these
10 records to print label | | 4 | 89 | 2/6/2008 1:41:00 PM |
Update query help
I have Two tables with the same information. Table Two has a column called
Errors with data.
How can I update table one Error column with the same info in table two
errror column.
| | 1 | 88 | 2/6/2008 1:11:23 PM |
"Currency" format lost in subform.
I have a subform that has a combo which
selects filtered records.
The combo has a field "ItemPrice" which has
lost the currency format, but this format is
OK when the underlyin | | 2 | 85 | 2/6/2008 1:03:23 PM |
I need to write a query that eliminates both duplicate records.
Hi,
I need to write a query that eliminates all records where the Contract and
Order fields are equal. I cannot use the DISTINCT keyword, since it leaves
one record. Thanks,
< | | 1 | 84 | 2/6/2008 1:00:09 PM |
Rerun an open query in Access 2007
Hi,
In Access 2003 I was able to place the "exclamation point" RUN button on my
Access toolbar so that I could easily re-run a query that I already had open
(rather than try to find | | 4 | 176 | 2/6/2008 12:23:55 PM |
IIF IsNull help
Hello all,
I'm trying to build a query using inputs from a form.
This is is the gist of what I'm trying to input into the expression builder
IIf(IsNull([Forms]![Form3]![prod | | 6 | 76 | 2/6/2008 12:23:48 PM |
Select Query Criteria
I have a table that I need to query to pull out all account numbers that have
the characters 921 as the 11th, 12th and 13th character. The table has
90,000+ records a sampling of the format | | 4 | 85 | 2/6/2008 12:20:41 PM |
What function convert text value to numeric value
What function convert text value to numeric value
I want to sum 2 column in query
Cloumn1 column2
1 2
I'm use expr1=([colu | | 1 | 122 | 2/6/2008 8:46:00 AM |