equivilant to trunc function in access
Tue, 9 Dec 2008 08:02:26 -0800
Hi there,
I used the round function but it rounded my numbers - I really just want to
cut of the decimals at the 2 decimal. I read about the trunc function on the
internet however it only works in excel and I need to do this in a query.
Any help would be great as my numbers are off by a little.
Thanks
...
|
If statement in Where Clause of SQL?
Tue, 9 Dec 2008 07:03:41 -0800
Hello
Ms Access 2003 on XP Pro.
I want to put an if statement in my where clause.
where
if Checkbox = true then
t.A=f.A AND t.b=f.b
else
t.A=f.A OR t.b=f.b
endif
1) Does this work?
2) Is this more efficient than having the vba pick between two different
queries?
Since I want to ...
|
Crosstab workings
Tue, 9 Dec 2008 04:35:01 -0800
I have a query which is used to create basic LxBxD for two types of items. I
am wanting to run a crosstab query so that it can 1) display the results as
Type 1 Type 2 Varaince
L 5 8 37.5%
B 9 8 -12.5%
D ...
|
Turn small letters to capital letters
Tue, 9 Dec 2008 04:21:01 -0800
Hello in a field there are entries with small letters I want to turn them
into capital letters. Is that possible?
Thank you
Dimitris ...
|
date based query fails to find records in given period
Mon, 8 Dec 2008 19:02:00 -0800
Access 2007. I have a query that groups records into a time period: p1 is 1
minute past midnight to 6am, p2 is 6:01am to noon, p3 is 1 minute past noon
to 6pm and p4 is 6:01pm to midnight (SQL below).
For some reason, I get no records for period 3. I have tried all sorts of
combinations (12 and 24 hour clo ...
|
Heavy Duty Crosstabs with Access 97
Mon, 8 Dec 2008 19:04:03 -0700
Do any long time Access users happen to have a copy of this paper I wrote
over 10 years ago?:)
thanks,
steve
www.beyondsql.blogspot.com
...
|
Complicated IIf statement
Mon, 8 Dec 2008 15:25:01 -0800
Using Access 2007 on XP - I need to label the type of product for each record
based on certain criteria. There are about 200,000 records right now.
Depending on variations of Division, Product, Program, Aslob, Subline and
Type of Loss, each record will get a new label. The only problem is that for
some pr ...
|
|
|
Can Field Descriptions be Scripted
Mon, 8 Dec 2008 14:54:01 -0800
HI
I have alter table scripts to add new fields. Can I also script the field
descriptions?
Glenn ...
|
How to Silence messages on Make Table query?
Mon, 8 Dec 2008 14:31:02 -0800
How do you silence the following messages when running a make table query?
"you are about to run a make-table query that will modify data in your
table....."
"The existing table will be deleted before your run the query....."
"You are about to post xxxx row(s) of data into a new table..."
I don't want ...
|
search for max value
Mon, 8 Dec 2008 14:27:01 -0800
I have two tables that have a relationship, mapunit and component. there can
only be a single record for each mapunit, however, each single mapunit can
have many components. my question is how to structure a query to search
through all components and return the maximum value, such as percent
composition of ...
|
