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 » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 25 of 100
Search took 9.80 seconds.
Search: Posts made by: KARL DEWEY
Forum: Using Forms June 7th, 2010, 09:27 PM Posted to microsoft.public.access.forms
Replies: 0
Views: 1,904
Posted By KARL DEWEY
Is there limit to number of files in a datebase in searching forms

Is this an Access question? So far as I know Access does not have FILES.
It has TABLES which has FIELDS that contain data.

--
Build a little, test a little.


"ky carver" wrote:

Once I hit 1001...
Forum: Running & Setting Up Queries June 7th, 2010, 09:13 PM Posted to microsoft.public.access.queries
Replies: 2
Views: 1,938
Posted By KARL DEWEY
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: 2,141
Posted By KARL DEWEY
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: 1,704
Posted By KARL DEWEY
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: 405
Posted By KARL DEWEY
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: 2,126
Posted By KARL DEWEY
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: 428
Posted By KARL DEWEY
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: 1,694
Posted By KARL DEWEY
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: 1,839
Posted By KARL DEWEY
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: 2,141
Posted By KARL DEWEY
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: 350
Posted By KARL DEWEY
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: 392
Posted By KARL DEWEY
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: 2,625
Posted By KARL DEWEY
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: 428
Posted By KARL DEWEY
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: 337
Posted By KARL DEWEY
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: 358
Posted By KARL DEWEY
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: 291
Posted By KARL DEWEY
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: 428
Posted By KARL DEWEY
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: 1,839
Posted By KARL DEWEY
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: 261
Posted By KARL DEWEY
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: 280
Posted By KARL DEWEY
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: 361
Posted By KARL DEWEY
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: 331
Posted By KARL DEWEY
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: 272
Posted By KARL DEWEY
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: 365
Posted By KARL DEWEY
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....
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 02:45 PM.


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