Query to show records under a dollar amount.
Mon, 8 Dec 2008 10:32:06 -0800
I have a table with account balances. I am trying to query the records to
return all records with an a/c balance under $50,000.00. What would the
criteria be? ...
|
Monthly Data Analysis
Mon, 8 Dec 2008 10:11:41 -0800 (PST)
Hello -
I have been tasked to analyze data (on a monthly basis) and generate a
couple of reports. To save time and energy I'd like to input the data
into Access - run a couple of queries - and have Access spit out the
reports. I?ve tried reasearching how I might acheive the results, but
the SQL I entered in ...
|
invalid argument
Mon, 8 Dec 2008 09:53:01 -0800
Can anyone help? Running the following query:
INSERT INTO ildonotcalltable12_8_08 ( phonenumber )
SELECT ac & phone AS phonenumber
FROM [TEXT;DATABASE=C:\Do Not Call List\].IL_12_8_2008_do_not_call_list.txt;
I have a database with ac and phonenumber(2 million records) in seperate
columns in a text file. I need ...
|
Parameter to Select Year in Date column
Mon, 8 Dec 2008 08:09:00 -0800
I have a date column or date field in my database, I want to create a select
Query in which the Parameter asks to enter in a person's last name and the
year; then the query would show all data with the year wanted for the wanted
person. For example, I want to run a query of all the transactions taken
place i ...
|
Update Query based on calc. Field in another query
Mon, 8 Dec 2008 06:49:18 -0800
I have a table I want to update based on the calculation in another query.
I have tblFutureOrder with the field Archive and
qryFutureOrderUpdate with the calculated field
AmountLeft:[OrderedAmount]-[ShippedAmount].
I want tblFutureOrder.Archive to equal Yes when Amount < .
So far I have not been able to come u ...
|
Returning only a null value
Mon, 8 Dec 2008 05:14:12 -0800
I am trying to build a query that will only return null values - it's a
training roster and I only want to see the people who have not completed any
of the 12 mandatory training classes and I only want to see the course that
they need.
It's making my head hurt..... ...
|
Turning off autocomplete/predictive text
Mon, 8 Dec 2008 04:20:00 -0800
How can I turn off autocomplete/predictive text? For example, I want to
stop it automatically completely the entire date if I type "2008".
--
Juno ...
|
|
|
Grouping in Access 2007 queries messes up date field
Mon, 8 Dec 2008 02:28:00 -0800
Hello!
I have a field which is defined like this: Dato:left([flyttet tid];10).
[Flyttet tid] is a now() value in a datedefined field at SQL table.
When i run query in ungrouped mode it looks like this:
http://bildr.no/view/301115
But when i run query in grouped mode it messes up the field so it appeas
...
|
joining multiple records
Mon, 8 Dec 2008 02:24:01 -0800
I have a big problem and hoping someone can help me out.
I've created a database with two linked tables - one showing individuals
(urn / name / postcode / dob / etc), the other table shows transactions (urn
/ date / value / descr / etc) - which have a separate urn as well as
contianing the individuals urn. ...
|
Date Query
Sun, 07 Dec 2008 18:24:59 GMT
Dear All
Heres hoping someone can help me.
I have a field which contains a due date for an inspection. This date can be
between now and a year from now.
Where I want to get to is to create a report that basically looks at Todays
date and counts week by week the number of inspections due in each week.
C ...
|
