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 18.38 seconds.
Search: Posts made by: Marshall Barton
Forum: Setting Up & Running Reports June 7th, 2010, 04:35 PM Posted to microsoft.public.access.reports
Replies: 8
Views: 2,988
Posted By Marshall Barton
Force the group footer to print on the first page

VBNovice10 wrote:

My report is based off of a current form we manually create through Microsoft
Word for every customer. Each customer may have anywhere from 1 to 300
items, so the detail...
Forum: Running & Setting Up Queries June 7th, 2010, 03:06 PM Posted to microsoft.public.access.queries
Replies: 3
Views: 2,421
Posted By Marshall Barton
Add character to string

Twimm wrote:

I have a simple query that pulls data from a single table containing
some basic client information. One field is a text field containing
alpha-numeric data. For purposes of a...
Forum: Running & Setting Up Queries June 7th, 2010, 12:42 PM Posted to microsoft.public.access.queries
Replies: 2
Views: 2,238
Posted By Marshall Barton
How to set the parameter query for this case?

klim1167 via AccessMonster.com wrote:
I have 2 fields, Eng and Math.
I would like to set the parameter query for Eng and Math == Eng min, Eng max,
Math min and Math max.
The Eng query criteria...
Forum: Running & Setting Up Queries June 7th, 2010, 02:12 AM Posted to microsoft.public.access.queries
Replies: 2
Views: 950
Posted By Marshall Barton
calculating average days

JohnL wrote:

I am trying to develop a report where in the PartNum footer the
average number of days between orders is calculated. I have
created the...
Forum: Setting Up & Running Reports June 6th, 2010, 08:11 PM Posted to microsoft.public.access.reports
Replies: 10
Views: 4,062
Posted By Marshall Barton
conditional numeric formatting of field output on report

David McCormack wrote:

I have tried this but I keep getting an error. This is what I have:

=IIf([Operation]=2,Format([May], "##0.0"),Format([May], "##0.0%"))

I have a field that if the...
Forum: Running & Setting Up Queries June 6th, 2010, 08:05 PM Posted to microsoft.public.access.queries
Replies: 8
Views: 2,852
Posted By Marshall Barton
Multiple tables search

Good point. TblName would definitely elimiate the issue.
--
Marsh
MVP [MS Access]


nrgins via AccessMonster.com wrote:
I wonder if using "Table" would create problems, since it's a reserved...
Forum: Running & Setting Up Queries June 6th, 2010, 05:10 PM Posted to microsoft.public.access.queries
Replies: 8
Views: 2,852
Posted By Marshall Barton
Multiple tables search

SELECT t1.name. "t1" As Table FROM t1
WHERE mobile_number = [Enter mobile number]
UNION ALL
SELECT t2.name, "t2" FROM t2
WHERE mobile_number = [Enter mobile number]
UNION ALL
SELECT t3.name, "t3"...
Forum: Running & Setting Up Queries June 6th, 2010, 05:06 PM Posted to microsoft.public.access.queries
Replies: 6
Views: 912
Posted By Marshall Barton
date and time query

domaze via AccessMonster.com wrote:

Marshall Barton wrote:
Date/Time values are internally represented as Doubles with
the fractional part being the part of a day. It appears
[quoted...
Forum: Running & Setting Up Queries June 6th, 2010, 11:25 AM Posted to microsoft.public.access.queries
Replies: 8
Views: 2,852
Posted By Marshall Barton
Multiple tables search

naveen prasad wrote:
I have a mdb file.
tables created t1,t2,t3,t4.

fields are almost same in all tables, but the data is different in all tables.

fields are.. name, age,...
Forum: Setting Up & Running Reports June 6th, 2010, 11:18 AM Posted to microsoft.public.access.reports
Replies: 1
Views: 2,418
Posted By Marshall Barton
Access report date problem.

pinchin1 wrote:

I have created a lot of graphs to show various information. The problem I'm
having is that I need the graphs to show the last 14 days of data. The
criteria I have used is...
Forum: Running & Setting Up Queries June 6th, 2010, 03:42 AM Posted to microsoft.public.access.queries
Replies: 6
Views: 912
Posted By Marshall Barton
date and time query

domaze wrote:

Date/Time values are internally represented as Doubles with
the fractional part being the part of a day. It appears
that your end time value is a very small fraction...
Forum: Running & Setting Up Queries June 5th, 2010, 11:21 PM Posted to microsoft.public.access.queries
Replies: 6
Views: 912
Posted By Marshall Barton
date and time query

domaze wrote:
I have the following problem and i really need some help because i am about
to go crazy.

I cannot understand why running this code in sql

select * from lessons...
Forum: General Discussion June 5th, 2010, 04:03 PM Posted to microsoft.public.access,comp.databases.ms-access
Replies: 4
Views: 2,904
Posted By Marshall Barton
populating an Access table from a text file

s wrote:

A text file has data in a format like the below:

Title1
Cell 1 data
Title 2
Cell 2 data
Title 3
Cell 3 data
Forum: Running & Setting Up Queries June 5th, 2010, 02:15 PM Posted to microsoft.public.access.queries
Replies: 2
Views: 559
Posted By Marshall Barton
A field (string) is into other field (string)

Victor2020 wrote:

Using 2 tables I want to get the rows that match where the content of the
field (string) is equal or is into other field (string) from other table.


SELECT tbl1.*, tbl2.*
FROM...
Forum: Setting Up & Running Reports June 4th, 2010, 10:13 PM Posted to microsoft.public.access.reports
Replies: 10
Views: 3,680
Posted By Marshall Barton
PLEASE HELP: Refresh columns displayed in a report from a quer

sam wrote:
This worked out perfect! Thanks a LOT!

Good to hear that you were able to figure out the details
and get it working.

The amount of code could be reduced by naming the user
selectable...
Forum: Running & Setting Up Queries June 4th, 2010, 07:04 PM Posted to microsoft.public.access.queries
Replies: 2
Views: 355
Posted By Marshall Barton
DatePart

Keith wrote:

I'm trying to convert "mm/dd/yyyy hh:nn:ss" date format to just time using
DatePart function.

I've used DatePart("hh:nn",[TimeIn]) and it returns "Error".

I've used TEMP:...
Forum: Running & Setting Up Queries June 4th, 2010, 02:19 PM Posted to microsoft.public.access.queries
Replies: 4
Views: 789
Posted By Marshall Barton
JOIN Query very slow

Tally.NET wrote:
I have the following Input tables

Table1
Serial Item Date SerialandDate
123 Item1 01-04-2007 12339173
123 Item2 01-06-2010 12340330
234 Item1...
Forum: Running & Setting Up Queries June 4th, 2010, 02:15 PM Posted to microsoft.public.access.queries
Replies: 1
Views: 771
Posted By Marshall Barton
create a form that collects parameters

Kalai wrote:
i need a form where we search for a detail and the result should be
published in the bottom, based on the result the user will decide what to do
next in acess 2007.

i refered the...
Forum: Setting Up & Running Reports June 2nd, 2010, 07:12 PM Posted to microsoft.public.access.reports
Replies: 8
Views: 2,988
Posted By Marshall Barton
Force the group footer to print on the first page

"the code didn't work" does not convey much information
beyond the fact that you did not like the result.

AFAICS, Wolfgang's code does what you asked for, so I am
guessing that there may be a flaw...
Forum: Setting Up & Running Reports June 2nd, 2010, 10:28 AM Posted to microsoft.public.access.reports
Replies: 6
Views: 493
Posted By Marshall Barton
Subreport Keeps Repeating Itself

Joel_123 via AccessMonster.com wrote:

I use the Start/End Date fields from the Forms in the criteria section of the
query (ie) under the DateWorked field, I have "Between...
Forum: Setting Up & Running Reports June 2nd, 2010, 03:48 AM Posted to microsoft.public.access.reports
Replies: 1
Views: 557
Posted By Marshall Barton
Error in totals when no data in subreport

Barry wrote:
I have a report ("Invoice") which has 2 subreports, one for parts and the
other for labor. When either has no data the calculations for totals on the
main report show #error. I am...
Forum: Setting Up & Running Reports June 2nd, 2010, 03:41 AM Posted to microsoft.public.access.reports
Replies: 6
Views: 493
Posted By Marshall Barton
Subreport Keeps Repeating Itself

Joel_123 via AccessMonster.com wrote:
Thanks for the response. Could I UNION the two payroll queries together to
use as the main form query or does that still count as including...
Forum: Running & Setting Up Queries June 1st, 2010, 06:34 PM Posted to microsoft.public.access.queries
Replies: 5
Views: 603
Posted By Marshall Barton
Random Function for Selecting Records

esn wrote:

Thanks for the replies - I care how the record was chosen only in that
I need it to be random (or reasonably close to random). When I
checked to make sure that Access was functioning...
Forum: Setting Up & Running Reports June 1st, 2010, 02:51 PM Posted to microsoft.public.access.reports
Replies: 6
Views: 493
Posted By Marshall Barton
Subreport Keeps Repeating Itself

Joel_123 via AccessMonster.com wrote:
I am having a problem with a report. I am trying to print out paystubs for
employees over a given time period. I have a start up form in which the...
Forum: Setting Up & Running Reports June 1st, 2010, 02:43 PM Posted to microsoft.public.access.reports
Replies: 10
Views: 3,680
Posted By Marshall Barton
PLEASE HELP: Refresh columns displayed in a report from a quer

sam wrote:
I have a couple questions:
1: I have put the code in form_load procedure, Is this a better place to
execute the code than form_open procedure?

Whoa! We had better be talking about...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 04:37 PM.


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