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 | 53 | 11/11/2009 6:58:11 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 | 52 | 11/11/2009 6:57:00 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 | | 3 | 50 | 11/11/2009 4:55:27 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 | | 2 | 56 | 11/11/2009 4:23:03 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 | | 1 | 55 | 11/11/2009 4:23:02 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 | | 1 | 60 | 11/11/2009 4:23:01 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 | | 1 | 48 | 11/11/2009 3:29:40 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 | 60 | 11/11/2009 3:28:31 AM |
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 | | 3 | 95 | 11/11/2009 3:28:19 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 | 51 | 11/11/2009 3:25:16 AM |
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 | | 5 | 46 | 11/11/2009 3:23:31 AM |
Finding Matching data
I have the following data;
Order Code Order Detail
100 AA
101 AA
100 BB
102 AA
1 | | 3 | 54 | 11/11/2009 3:22:30 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, | | 2 | 64 | 11/11/2009 2:02:55 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 | | 2 | 60 | 11/10/2009 9:50:36 PM |
nested iif function
Hello, I am getting an error when I insert a nested iif function and I
can't understand why. Can someone help? Here is the issue. I have a
field which shows either a number or the word "L | | 4 | 45 | 11/10/2009 8:47:35 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 | 55 | 11/10/2009 8:10:02 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 | | 1 | 60 | 11/10/2009 7:58:38 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 | | 1 | 47 | 11/10/2009 7:23:41 PM |
Crosstab returns blank fields
What am I missing?
Here is the SQL:
TRANSFORM Sum(Query3SalesConvert.SALES) AS SumOfSALES1
SELECT Query3SalesConvert.MANUFACTURERNAME,
Query3SalesConvert.CREATETERRITORYID, Sum(Qu | | 6 | 61 | 11/10/2009 7:01:02 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 | | 2 | 53 | 11/10/2009 6:43:08 PM |
Subquery Range Lookup
I could do this in VBA easily, however I want to know the pure-access query
syntax for accomplishing this (to allow the range table to be maintained by
the end-user) I have looked at http | | 3 | 57 | 11/10/2009 6:38:11 PM |
RecordsetNot Updateable
Hello,
I have a query as a Recordsource for a form. It originally contained two
tables, [Order Entry Header] and [Customers] with an inner join. It was
updateable.
S | | 22 | 51 | 11/10/2009 6:15:06 PM |
Crosstab Returns Empty Fields
What am I doing wrong here?
Here is the SQL:
TRANSFORM Sum(Query3SalesConvert.SALES) AS SumOfSALES1
SELECT Query3SalesConvert.MANUFACTURERNAME,
Query3SalesConvert.CREATETERR | | 2 | 57 | 11/10/2009 6:07:02 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 | | 1 | 49 | 11/10/2009 5:33:53 PM |
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, | | 1 | 57 | 11/10/2009 5:09:26 PM |
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 | | 3 | 51 | 11/10/2009 4:51:49 PM |
Problem with Expression
Good afternoon,
I have a parent form with 2 list boxes and 2 text boxes that supply
information to an expression located within a calculated control in a
subform.
Li | | 2 | 44 | 11/10/2009 4:00:09 PM |
Choose the highest and second highest from three field
Can anyone solve my problem ....
In query there are 3 field - Mark1, Mark2, Mark3. I like to do an expression
that we can choose the highest mark and second highest mark only from 3 mark
< | | 6 | 55 | 11/10/2009 3:36:16 PM |
Subquery help
Hi.
I am trying to run a query, but am getting a 'At most one record can be
returned by this subquery' error.
I have used subqueries before but have never seen this message | | 7 | 46 | 11/10/2009 2:45:01 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, [ | | 2 | 51 | 11/10/2009 2:41:35 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 | 44 | 11/10/2009 8:47:58 AM |
find who the driver is
Hi,
I’m trying to identify a route driver based on the route number the location
& the time the route was at the location.
I have many routes with the same number (i.e. 100, 200, | | 1 | 50 | 11/10/2009 5:48:02 AM |
Multiple IIF In Query
I'm sure there is a simple solution to this, I have tried some other solututions to no effect.
I have a query field [MemebrType] where the data will only be Gold, Silver or Bronze.
| | 3 | 68 | 11/10/2009 5:43:57 AM |
Can understand access code
Could someone help me document this code so me, the newbie can learn
something?
I tried to document what i could.
Andrew
Here is some code I am trying to understand:
| | 1 | 51 | 11/10/2009 12:48:15 AM |
2 Table Query issues
Below is my current Query.
It behaves oddly. I am rather new to this all.
At this time there is only 1 Record in the Address table, and that address is
used for every name in the 2nd ta | | 2 | 56 | 11/10/2009 12:22:57 AM |
Auto join in access 2007
I have checked AutoJoin in the Access Options, however, when i place two
tables w/ identical primary keys, it does not auto join them. It appears to
be not working. Any help will be greatl | | 1 | 49 | 11/9/2009 11:47:46 PM |
Trying not to run multiple queries
Hello,
I have a query where I select the items in our property room on a specific
day by using the criteria [Received Date]<=Date AND [Disposed Date]>=Date or
Is Null. I then h | | 4 | 53 | 11/9/2009 11:38:10 PM |
Select row by ID to nearest date, future (or past if no future dat
Hello all,
I have a table in a database named "tm_tasks" that contains records of tasks
to be carried out on a case. The end user enters the tasks from a form which
inclu | | 4 | 40 | 11/9/2009 9:44:42 PM |
Remove all characters after "hyphen" in field
I have field in a query that values are in two parts example
location name 1 - material type
location name 2 - material type
location name 3 - material type
I would lik | | 3 | 48 | 11/9/2009 9:35:27 PM |
query result in text box
Hi,
I am creating a database that is designed to perform calculations on data
that is input daily. I have made a form on which to input the data and there
are two text boxes tha | | 2 | 50 | 11/9/2009 8:25:02 PM |
Combining Records Question.
I have data like this:
Record 1:
Doe, Jane Doe, 1 main street
Record 2:
Doe, John Doe, 1 Main Street
What I what to do is the following:
Doe, Jane Doe, John D | | 2 | 55 | 11/9/2009 8:20:05 PM |
Append record with Yes/No
I have some records that occasionally need to have fields updated that change
the field it is looking and also the clear another field.
I am sure it is an append query but I am not sure h | | 1 | 51 | 11/9/2009 7:59:55 PM |
separate field
I have a field which contains first and last name. I want to convert it to
an email address.
For example: Bob Jones
I want to have bob.jones@aol.com
| | 2 | 53 | 11/9/2009 7:30:49 PM |
Inverted Query
Can't seem to figure this one out...has to be simple though.
I have a database of employee's training records. I need to find
those employees who have not had the course "BPS&quo | | 2 | 49 | 11/9/2009 7:03:20 PM |
iif statement
I am new to access; trying to create a query for a report that has a subtotal,
the field will only total if a portion of a word appears in a combo box of
another field. Specifically, if the | | 1 | 53 | 11/9/2009 6:14:20 PM |
Custom Counter Question (Repost)
Hello Everyone -
I haven't received a response back to one of my posts so I am re-posting
with the hope that someone will pick up the new post.
I have created a field in a | | 4 | 52 | 11/9/2009 5:41:02 PM |
Querying Numbers - Field Size = "Double"
I have a table that has the ID set as Number with field size Double (It's the
Key, required no duplicates).
I have two pieces of data
1492 (Some Integer)
39797.6002777778 (S | | 2 | 52 | 11/9/2009 5:14:43 PM |
dcount
PatientTable contains thousands of patient records. subform current record
selection should for a given clinic ID, update the parent totalpatients text
box with total number of patients in goo | | 9 | 49 | 11/9/2009 9:36:43 AM |
where clause
I am trying to view records where the date value of one control equals that
of another. The following clause causes an error:
WHERE DateValue([TimeStart])=DateValue([DateAppointment]) | | 3 | 56 | 11/9/2009 3:44:01 AM |
where do i get a windows installer download from
cannot download progs problem with windows installer missing
| | 1 | 55 | 11/8/2009 9:59:36 PM |
IIF in Query, more output then I want
I'm trying to compile a list of purchases done between 0906 and 0911
M1: IIf([Purch]>"0906" And [Purch]<"0911",[ Purch],"")
The query works but in | | 5 | 52 | 11/8/2009 7:18:31 PM |
Show a picture on a form specific to each record - JCW
I want to add a picture to a form that will show a specific picture for each
record. I have a picture field set to OLE Object. Ideally I would like for
the user's to be able to do this w | | 1 | 48 | 11/8/2009 5:43:28 PM |
Characters found at end of sql error-Repost
My last post did not contain the sql but bottomline the i have isolated the
problem in the where section of the sql yet i cant determine what is wrong
SELECT Inv.OrderDate, Customers. | | 2 | 55 | 11/8/2009 1:45:44 PM |
Query to find offstting transactions
I have a table, tblTransactions. In there I have some transactions which
represent a person registering for an event, and some which represent
cancelling a registration.
each re | | 6 | 47 | 11/8/2009 1:19:31 PM |
Characters found at end of sql error
I am trying to create a join query and continue to get a Characters found at
end of sql error. Is there a way to determine where in the sql view this
error may exist so it can be fixed si | | 1 | 62 | 11/8/2009 7:37:28 AM |
Query to Find Records with only 1 transaction
All,
I thought I posted this last week, but cannot fidn it.
I am working on a table that has transactions for registering for events. So
in my table, I have PersonIDNum and Trans | | 6 | 54 | 11/8/2009 5:08:02 AM |
Is it an Ms Access bug?
Hello Forum users,
Any advise on the following will be much appreciated:
I have a customer who has created a form in Access which contains two combo
boxes. Then 2nd combo m | | 5 | 47 | 11/7/2009 11:34:34 PM |
Modifying subform's underlying SQL statement
I am trying to make modifications to the SQL statement underlying a
subform. I make the changes using Access Query Builder view. However, after
I make the changes and save them my changes ju | | 1 | 51 | 11/7/2009 1:39:21 PM |
Filtering records for 2 types of dates
Using Access 2003 and I use the query grid for my criteria etc. I have a
list of patients who were on a particular therapy and a list of all the
units they were in for their entire stay. I | | 10 | 40 | 11/6/2009 8:13:43 PM |
find exact match or match those only few cents off
Table1
item# CustID Dep$
1234A 111 10.15
2554S 222 7.75
1232B 111 8.49
Table2
item# CustID Return$
1234A 111 10.15
1232B 111 8.47
Rig | | 3 | 49 | 11/6/2009 7:30:01 PM |
Totals with WHERE left() criteria
Hi Brainy people,
I have fields Male & Register & I want to total the number of males (yes/no
field) where the left([Register],2) = "GU"
I have to create the s | | 11 | 50 | 11/6/2009 7:18:02 PM |
fConcatChild issues
I am trying to use fConcatChild and am unsuccessful.
I have a query that uses a value from a form along the way that has a list
of scheduled tests during a certain month (qryScheduling5). | | 6 | 50 | 11/6/2009 7:15:02 PM |
Error in syntax
I was given this sql code but have the following error which I can't resolve..
"The SELECT Statement contains a reserved word or
an argument name that misspelled or missing, or t | | 2 | 56 | 11/6/2009 7:14:01 PM |
Multiple records in a query
I am pulling a very simple query: anybody throughout the last 3 years who
have given a financial donation. However, I am getting Multiple/Duplicate
records showing in my query (same ID of r | | 4 | 56 | 11/6/2009 6:46:41 PM |
Subquery Issue 1
Karl:
The way this is working now, the query is pulling all "Shipping Priority"
information from the tbl_History table. Here is the code for the Crosstab
query:
| | 5 | 35 | 11/6/2009 6:01:02 PM |
DateAdd and other functions
I have a Date Arrived and I need to add a certain number of days to that
date. Which I successfully did. Is there a way to have that infortaion be
saved to a field in my database so when q | | 3 | 52 | 11/6/2009 5:26:55 PM |
200 results per page
Access 2007
I have a simple table that has about 2,300 records..
What I want to do is very simple, in my mind.
I want to create a query that select the records that I want b | | 2 | 51 | 11/6/2009 3:52:02 PM |
Create update query for remaining records
Need to create an update query that will add records to a table that when
summarized equals the amounts in another table when compared. I know how many
units I need to add, the problem comes | | 5 | 40 | 11/6/2009 1:14:03 AM |
Queries; Make Ready
I have a MakeReady query that I usually run to update tables. Today, it is
not running - I keep getting the same error to "delete it's relationship in
the Relationships window". | | 1 | 49 | 11/5/2009 11:00:02 PM |
MS Access
How do you setup or can you setup a subquery that would give you the max records for all clients for a parameter date provided. I know it would have t o check max records by client and have done this | | 1 | 62 | 11/5/2009 10:01:16 PM |
Calculation in a query
I have a table that contains job assignments. I want to, for a given date
range, calculate the percentage of job completion. So I want to take the
number of jobs closed from field [job sta | | 2 | 53 | 11/5/2009 9:17:01 PM |
Changing query criteria to supply a form
Hi all,
I have what's certainly a newbie question.
I have a query that supplies data to a form. Is there a way to filter
the data shown on the form according to different criter | | 3 | 41 | 11/5/2009 8:50:55 PM |
Turn Off Access Field Re-name? Calculation fields in query
I am wondering if there anyone has found a method for 'turning off' how
Access auto-renames a field that has a calculation against it.
For example, fi you are grouping on [Field1], and S | | 1 | 46 | 11/5/2009 8:15:01 PM |
search criteria in query
I've got an access dbase that has a link to an sql dbase table. I didn't
create the sql table and I'm just linked to it so I can run a couple custom
reports in access. My question is that I | | 7 | 43 | 11/5/2009 7:56:11 PM |
Pie Chart
I want to create a pie chart from an Access table.
I have a number of queries which are allocated to certain people under a
field called "Allocated to" and this then contains people | | 1 | 58 | 11/5/2009 5:16:05 PM |
Use of Max is quite working
Hi all,
I have Access 2003 on WinXP. I have a table with:
PartID
TransactionID (runs in incremental order by 1)
DateOfSales
TotalCost
NumOfUnit
UnitPrice (which i | | 4 | 45 | 11/5/2009 4:53:06 PM |
Query-finding umatched data with duplicates
I am trying to compare two tables to find what does not match. However each
table may have duplicate items but I need each item to have its’own match.
The Unmatch query does not work
| | 3 | 48 | 11/5/2009 4:23:01 PM |
IIF statement with DCount crashes A2007
Hoping someone can help me.
I have Access 2007 and a query with a field using this expression:
IIf(DCount("*","Deductions")<30,5,10)
Access crashes ev | | 2 | 56 | 11/5/2009 3:11:01 PM |
Maximum Number of Crosstab Column Headings
What is the maximum number of crosstab column headings I am allowed in my
query? I need about 200 columns.
--
Thank you, cs
~~~~~~~~~~~~~~~~~~~~~~~~
"What lies behind us and | | 2 | 48 | 11/5/2009 3:03:01 PM |
combobox in query
My DB has 8 fields (wo #/Date Inspected/Inspection Type/Group/
Group Items/Fault/Fault Description/Comments) fields 3,4,5,6 are
comboboxes,field 4 and 5 are cascaded comboboxes. I need to bui | | 2 | 61 | 11/5/2009 3:02:01 PM |
Query Weekly Data
I have a date field called "transactiondate". How do I query all the data
for the previous two full weeks? How do I query the data for the previous 52
full weeks? Not inclusive | | 2 | 48 | 11/5/2009 3:01:03 PM |
Custom Counter
I have a table that tracks employee attendance records. In the table, I am
calculating an accumulative total column for points. This took me quite some
time to figure out but I finally d | | 6 | 56 | 11/5/2009 1:48:01 PM |
Determine position in query recordset
Hi,
I am creating a function that I want to use in a query.
I need to test in the function whether the recordset is BOF.
How do I refer to the recordset from VBA - what is the object name? | | 1 | 52 | 11/5/2009 12:39:16 PM |
Count of Groups
I have a database that lists clients, the case # related to that client, etc.
multiple clients may have the same case #. I want to count the number of
different cases, but I can only seem | | 5 | 58 | 11/5/2009 12:26:07 AM |
IIf statement in query criteria
I have a query that returns sales history for a range of inventory items. I
have a form that allows me to enter a range of items, and a date range as
well. Currently my query returns all i | | 3 | 48 | 11/4/2009 9:36:02 PM |
IIF statement and multiple items
I have 3 fields (see below) and each of them contains True or False. I was
trying to write a query that combined all of them and output only 1 of the 3
fields. For example, [WFL] = True, [Ab | | 4 | 56 | 11/4/2009 8:52:05 PM |
Query to return only one value.
Hi, I need help please
Trying to do a select query where I only want one row returned if a field
has two values>
Example: Joe Bloggs can have two records one for SUBS | | 5 | 38 | 11/4/2009 8:31:03 PM |
can only name folders with 8 letters or less how can I extend it .
When naming a folder it keep saying that the path name is to long. I can
only use 8 characters or less. How can I extend this. I am using office 2007.
| | 1 | 40 | 11/4/2009 7:28:10 PM |
How to get previous and current and next values on one line
Hello All
I have need to know in one "line" the previous value, current value and the
"future" value.
here is my scenario. i have a "service report | | 2 | 48 | 11/4/2009 7:10:01 PM |
How to get the previous, current and next values for a field
Hello All
I have need to know in one "line" the previous value, current value and the
"future" value.
here is my scenario. i have a "service report | | 2 | 57 | 11/4/2009 7:06:01 PM |
How to find previous, current and future values
Hello All
I have need to know in one "line" the previous value, current value and the
"future" value.
here is my scenario. i have a "service report" | | 1 | 49 | 11/4/2009 7:04:02 PM |
hola
This is a multi-part message in MIME format.
------=_NextPart_000_000B_01CA59A4.B0153950
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quote | | 1 | 59 | 11/4/2009 6:00:14 PM |
Update table with values from another table
I have a table in MS Access and I need to copy it's rows to a SQL server
table and following regularly run a query that updates changed information.
Changes are still performed in Access. I | | 2 | 48 | 11/4/2009 4:23:01 PM |
cross tab query outer join
I tried to have a cross tab query out join like following data:
tblstudent
Student ID
1
2
3
tblExam
Student ID, Exam Date, Exam ID
1 | | 1 | 63 | 11/4/2009 4:12:23 PM |
Query Problem
Hi,
I am looking for a query to take 7 different fields, and produce a result if
ANY of the 7 fields are blank. If I use the "Is Null" function in each
field, it doesn't | | 2 | 50 | 11/4/2009 3:49:02 PM |
Calculating time in Access based on an 8 hour day
I am trying to calculate time based on an 8 hour day in Access. I have used
the DateDiff, but it gives me hours back based on 24 hours. Any suggestion!
Expr1:
DateDiff("h&quo | | 2 | 53 | 11/4/2009 2:40:32 PM |
01 Hosting Web www.ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Host | | 0 | 100 | 11/4/2009 11:50:25 AM |
query - express builder
I have two tables A & B, I need to check from B tables column 11 to find out
if there is anything like the table A column 8. In column 11, it contains
something like the following Key - | | 9 | 47 | 11/4/2009 5:57:46 AM |
IIF statement to compare two fields.
Hi,
I would like to use the IIF statement to compare two fields in Access query
design view. I would like to compare two fields in a query. I know how to
do it in Access using | | 2 | 103 | 11/3/2009 9:41:01 PM |
Year Beginning Date
I want to run a YTD report that will return the first day (January 1) of the
same year of a date (ending date) that I manually enter on a form. If the
date is any month, any day of 2009 t | | 2 | 61 | 11/3/2009 8:38:09 PM |