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

Post New Thread
Threads in Forum : Running & Setting Up Queries Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Need help with concatenation function by EllenM
Hello, I've found a wonderful concatenation function at http://www.mvps.org/access/modules/mdl0008.htm. It, however, separates the concatenated values with...
May 21st, 2010 08:34 PM
by EllenM Go to last post
4 462
return record if 5th character is a letter by Ron5440
Hi, I have the mid statement to pull the 5th character, but I need the (query) syntax to filter out the ones that are a letter (alpha) -- Thanks, ...
May 21st, 2010 08:15 PM
by Ron5440 Go to last post
4 417
Export to Text Files Based on Field Value by Leviathan via AccessMonster.com
I have an Access table with personal information (e.g., first name, last name, birth date, etc.) for thousands of people. The table is sorted by state. I want...
May 21st, 2010 07:56 PM
by John Spencer Go to last post
1 359
Total - Total Fields in a Totals Query by JK[_4_]
Any idea why this won't work? TotalDays : nz()+nz()+nz()+nz()+nz() I get an error that say: SubQueries cannot be used in the expression. Any help would be...
May 21st, 2010 05:12 PM
by Daryl S[_2_] Go to last post
1 363
Help with small result type by Alain
Hi to all expert, I am running kind of a complex query and I want to know why I get the result as a string instead of a number/currency, the math is good...
May 21st, 2010 04:11 PM
by Alain Go to last post
2 327
Past Due Expression by Hank
In a child day care center database at church, I have used the following expression in a PaymentQry to determine a past due amount. PastDue:...
May 21st, 2010 03:01 PM
by Tom van Stiphout[_2_] Go to last post
1 316
Crosstab queries, and null values by Edwinah63
Hi everyone, I have a crosstab query attached to a graph on a report. It shows quantity of widgets produced by each employee for a specified period. The...
May 21st, 2010 02:28 PM
by John Spencer Go to last post
3 563
Querying 2 field unless duplicated by DC1
New at this, so please bear with me: I am looking to merge 2 fields unless duplicated. The fields are in the same row in the same table Female Surname & Male...
May 21st, 2010 01:56 PM
by John Spencer Go to last post
2 270
Union Query Access 2007 SP2 MSO by Bruce
I have a union query that keeps telling me that there is a data type mismatch. When I first run the query everything is okay and it displays the fields...
May 21st, 2010 10:20 AM
by Bruce Go to last post
7 476
Access 2003: Select Next Item in Combobox by eckert1961
Hello, I have a combobox on a form and currently I manually select the next item for a member as needed. This is fine for 1 or 2 but typically I have to do...
May 21st, 2010 02:45 AM
by eckert1961 Go to last post
5 359
Multiple Totals Columns in a Pivot Table by Danny
Hi. I've built a pivot table, and get totals values displayed as expected. In this case, it's a count of records. But I also want to see values for several...
May 21st, 2010 01:06 AM
by Duane Hookom[_4_] Go to last post
3 409
Need Help with Totals Query by SSi308
I have a table with daily call records. The table includes fields for: Department; Name; Date of Call; Time of Day; Call Direction; Number Dialed; Locale;...
(Multi-page thread 1 2 3)
May 20th, 2010 09:47 PM
by John Spencer Go to last post
24 869
delete query by inungh
I would like to delete first 3 records of the table. I know that I can set criteria to delete certain records in the table, but are there any way to set...
May 20th, 2010 05:21 PM
by inungh Go to last post
3 270
90 days and the first of the month by Gaetan via AccessMonster.com
I'm trying to figure out hoe to calculate 90 days from hire and the first of the month Example: HiredDate Insurance activated 1/3/2010 ...
May 20th, 2010 05:04 PM
by Gaetan via AccessMonster.com Go to last post
4 277
Reminder - Microsoft Responds to the Evolution of Community by [email protected]
Microsoft Office Evolves Community as Part of Office 2010 Launch: As you know, this is a big year for Microsoft as we are launching the latest version of...
May 20th, 2010 04:13 PM
by [email protected] Go to last post
0 270
count qry by StuJol
using access 2003 i have the following qry SELECT DateSerial(Year(),Month(),Day()) AS , ., .Parameter, .Desc2, Count(*) AS MyCount, .Module FROM GROUP BY...
May 20th, 2010 02:54 PM
by Daryl S[_2_] Go to last post
2 292
delete files by PANOS via AccessMonster.com
Good morning and thks for your help, 1. Have on acces Qouestion with the following CODE 02304 02305 02306 Code is the item No 2. I have folder one my pc...
May 20th, 2010 02:47 PM
by Tom van Stiphout[_2_] Go to last post
1 343
Parameter Query No Results - Needs to Auto Create Record by JudyKemp
I have a parameter query works as long as there are related records in the tables. My problem is I when the query results are "null" or no records exist I...
May 20th, 2010 02:41 PM
by Tom van Stiphout[_2_] Go to last post
4 420
Calculating Elapsed Time by Machyde
How do I calculate elapsed time in a simple query when the starting time is before 00:00 and the end time after 00:00 ... all I'm getting at the moment is a...
May 20th, 2010 02:05 PM
by John Spencer Go to last post
3 382
Updating text field to new numeric field & moving minus sign to fr by RyNC
Hi, I need some help with the below IF statement for update query. I got it to move the negative sign to the front of the number, but now it is removing all...
May 20th, 2010 01:41 PM
by John Spencer Go to last post
3 296
Post New Thread

Display Options
Showing threads 141 to 160 of 43289
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

All times are GMT +1. The time now is 09:21 PM.

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