Forum: Using Forms
June 7th, 2010, 09:27 PM Posted to microsoft.public.access.forms
|
|
Replies: 0
Views: 2,784
|
|
Forum: Running & Setting Up Queries
June 7th, 2010, 09:13 PM Posted to microsoft.public.access.queries
|
|
Replies: 2
Views: 2,872
in access, if then statement
You have the same names as calculated fields and fields that you are joining
tables on.
Which do you want to use in the IIF stateement?
--
Build a little, test a little.
"dtretina" wrote:
|
|
Forum: Running & Setting Up Queries
June 7th, 2010, 04:24 PM Posted to microsoft.public.access.queries
|
|
Replies: 4
Views: 3,197
Pulling specific data from table field
due to a type conversion failure. It states this is due to key violations,
lock violations, and validation rule violations.
First you have to figure out which of the reasons give you the error....
|
|
Forum: Running & Setting Up Queries
June 7th, 2010, 04:02 AM Posted to microsoft.public.access.queries
|
|
Replies: 3
Views: 2,500
Use of Parntheses in Expressions
Try this --
Sum(IIf([Mapping].[Pricing]="CPM",[TPImpressions]/1000*[Mapping].[Price],IIf([Mapping].[Pricing]="CPC",[TPClicks]*[Mapping].[Price],[TPConv]*[Mapping].[Price])))*[Mapping].[Eye Engage...
|
|
Forum: General Discussion
June 4th, 2010, 06:56 AM Posted to microsoft.public.access
|
|
Replies: 2
Views: 606
Access2007 Combo Box
Because it is 'unbound' it does not reflect data from any record.
If you were to open the table you would see that the field does not contain
data.
--
Build a little, test a little.
"ALF" wrote:
|
|
Forum: General Discussion
June 4th, 2010, 06:56 AM Posted to microsoft.public.access
|
|
Replies: 4
Views: 3,189
populating an Access table from a text file
If you could post some actual data with puncuation someone might have an idea
on how to proceed.
--
Build a little, test a little.
"s" wrote:
A text file has data in a format like the below:
|
|
Forum: General Discussion
June 4th, 2010, 06:24 AM Posted to microsoft.public.access
|
|
Replies: 7
Views: 638
Using Parameters in Graph
I forgot, crosstab queries must have parameters defined. Below is if they
are integers. This is for text --
PARAMETERS [Which Department] TEXT (255), [Which Division] TEXT (255);
PARAMETERS...
|
|
Forum: Database Design
June 3rd, 2010, 11:52 PM Posted to microsoft.public.access.tablesdbdesign
|
|
Replies: 2
Views: 2,727
Making 2 colums into one
Use a calculated field --
Combined: [column 1] & " - " & [column 3]
Or omit the dash and use one space or comma and a space as you wish it to be
displayed.
You could add a new field in your...
|
|
Forum: Running & Setting Up Queries
June 3rd, 2010, 11:18 PM Posted to microsoft.public.access.queries
|
|
Replies: 6
Views: 2,722
duplicate results in query
Revise to add 1 --
.....b.CC = a.CC AND b.Price = a.Price AND b.Value = a.Value)+1 AS Rank
--
Build a little, test a little.
"pat67" wrote:
On Jun 3, 11:18 am, pat67 ...
|
|
Forum: Running & Setting Up Queries
June 3rd, 2010, 11:10 PM Posted to microsoft.public.access.queries
|
|
Replies: 4
Views: 3,197
Pulling specific data from table field
Try these --
LName: Mid([tbl1].[userinfo], 17, Instr(20,[tbl1].[userinfo], " ")-16)
FName: Mid([tbl1].[userinfo],InStr(20,[tbl1].[userinfo],"
")+1,InStr(23,[tbl1].[userinfo],",...
|
|
Forum: Running & Setting Up Queries
June 3rd, 2010, 10:37 PM Posted to microsoft.public.access.queries
|
|
Replies: 2
Views: 505
Maybe Update Query?
It seems that you are mixing terms. An Update query revises the data in an
existing record. An Append query adds new records.
I do not see a need for either in your case.
If you want to see the...
|
|
Forum: Setting Up & Running Reports
June 3rd, 2010, 06:55 PM Posted to microsoft.public.access.reports
|
|
Replies: 1
Views: 641
Report only displaying some info
Use a left join from contracts to services.
In design view click on the connecting line, double click, and select option
to show all contracts.
--
Build a little, test a little.
"Jen" wrote:
...
|
|
Forum: Setting Up & Running Reports
June 3rd, 2010, 06:54 PM Posted to microsoft.public.access.reports
|
|
Replies: 10
Views: 4,064
Firstname plus Middlename??
There are several ways including an IIF statement.
=[surname] &", " & IIF([middlename] Is Null OR [middlename] = "",
[firstname], [firstname] & " " & [middlename])
--
Build a little, test a...
|
|
Forum: General Discussion
June 3rd, 2010, 06:44 PM Posted to microsoft.public.access
|
|
Replies: 7
Views: 638
Using Parameters in Graph
Try this --
TRANSFORM Sum([Time Sheet Errors by PS 2].CountOfTimeSheetErrors) AS
SumOfCountOfTimeSheetErrors
SELECT [Time Sheet Errors by PS 2].PerformanceSupervisor
FROM [Time Sheet Errors by PS...
|
|
Forum: Running & Setting Up Queries
June 3rd, 2010, 06:39 PM Posted to microsoft.public.access.queries
|
|
Replies: 7
Views: 570
querying unrelated tables
You should not use Date as a field name as it can give you problems.
Try these two queries --
UNTESTED --- UNTESTED --
qryEmpAllDate --
SELECT Employee_PunchTime.EmpID, Employee_PunchTime.[Date]...
|
|
Forum: Running & Setting Up Queries
June 3rd, 2010, 04:56 PM Posted to microsoft.public.access.queries
|
|
Replies: 2
Views: 546
Default Dates
Yes. Open the form in design view, click on the text box, right click,
scroll to bottom, click on Properties, enter a default value or formula and
select the format.
--
Build a little, test a...
|
|
Forum: General Discussion
June 3rd, 2010, 04:16 PM Posted to microsoft.public.access
|
|
Replies: 0
Views: 449
Menu
It has no flavor.
--
Build a little, test a little.
"Liz" wrote:
Here is my menu enjoy!
.
|
|
Forum: General Discussion
June 3rd, 2010, 04:16 PM Posted to microsoft.public.access
|
|
Replies: 7
Views: 638
Using Parameters in Graph
Your 'straight graph' pulls data via some SQL statement as does the crosstab
query. These can be edited to include parameters or better yet would be to
use a form with unbound text boxes for...
|
|
Forum: Running & Setting Up Queries
June 3rd, 2010, 03:58 PM Posted to microsoft.public.access.queries
|
|
Replies: 6
Views: 2,722
duplicate results in query
Your tables are joined on Purch Doc and Item but you have multiple dates in
both tables. This results in what is known as a Cartesian effect. The
number of dates in the first table will be...
|
|
Forum: General Discussion
June 2nd, 2010, 11:18 PM Posted to microsoft.public.access
|
|
Replies: 4
Views: 441
project
Naah. It sounds like they are using the difference in the number of electrons
in the outer shells of the metals in a formula with the pH of the working
fluid used for a battery to determine the...
|
|
Forum: General Discussion
June 2nd, 2010, 11:13 PM Posted to microsoft.public.access
|
|
Replies: 2
Views: 441
setFocus & inner join query glitch...
Don't know but try this --
SELECT tblFieldIDsPRNUMsNumeric.FLD_ID, tblFieldIDsPRNUMsNumeric.PRNUM AS
Project, tblFieldIDsPRNUMsNumeric.prnum_num, food_master.pesticide,
food_master.commodity,...
|
|
Forum: Setting Up & Running Reports
June 2nd, 2010, 09:51 PM Posted to microsoft.public.access.reports
|
|
Replies: 2
Views: 617
Multiple Queries...?
I am trying to make a section on the invoice that shows the date of each
payment
I never heard of payments listed on invoice but we all learn something new.
Your invoive should currently have a...
|
|
Forum: Setting Up & Running Reports
June 2nd, 2010, 09:39 PM Posted to microsoft.public.access.reports
|
|
Replies: 1
Views: 546
Create Categories
Each question in the survey is one of the fields in the Access table.
That is a spreadsheet that has more than 37 fields.
Use a union query to reformat the data like this --
Question Category...
|
|
Forum: Setting Up & Running Reports
June 2nd, 2010, 09:27 PM Posted to microsoft.public.access.reports
|
|
Replies: 1
Views: 430
Count funtion in report-I'm too rusty!
I have those four fields in each record,
Wrong structure. You are trying to use a spreadsheet. You need this --
State, ID#, Response
An Options Group would work for your data input for...
|
|
Forum: General Discussion
June 2nd, 2010, 09:06 PM Posted to microsoft.public.access
|
|
Replies: 2
Views: 535
Grouping multiple data for one search
Your table is constructed as a spreadsheet instead of a relational database.
It should be like this --
Area County
With data like this --
Metro Hennepin
Metro Anoka
Metro Wright
Duluth St....
|
