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
HAVING clause by Rebecca
Having trouble with HAVING clause. Say my table shows families with one row for each kid, labeling that kid's gender So Jones family has 2 girls, 1 boy;...
December 31st, 2009 07:21 PM
by John Spencer Go to last post
2 261
Validating Email Address by Steve Stad
I want to verify/validate user has input a good email address so I am checking for the '@' sign and a period in the email string. Is there a better way? ...
December 31st, 2009 07:00 PM
by Dale Fye Go to last post
5 217
Monthly Averages by Nedan Nedzatra[_2_]
Hia! How are you friends!! Some help please; I have a 2 column table on Access 2002. One field(ProductsSold) has inetgers and the other dates spread over...
December 31st, 2009 04:36 PM
by Nedan Nedzatra[_2_] Go to last post
2 160
Date range for a report by Tracey
Hi I am trying to run a query and can't seem to nail down the right code. We use the access database to track files, incoming/outgoing correspondence dates...
December 31st, 2009 04:31 PM
by Tracey Go to last post
3 202
insert rows after count by Ginger
Query shows 5 years of data for various accounts. Some accounts may not have 5 years of data however I want rows added with the year that doesn't have...
December 31st, 2009 04:22 PM
by Dorian Go to last post
1 168
Need help getting query to reference a field in a subform by Mike Daniska
I am trying to run a query using a specific field in a subform as the criteria. The query is displaying one combo box from the Form, as well as several fields...
December 31st, 2009 04:02 PM
by Dale Fye Go to last post
2 211
Make URLs by EllenM
Hello, I'd like to make urls by concatenating three fields. The urls will look like this: a href=''Introduction/a I think it should constructed like...
December 31st, 2009 02:58 PM
by Bob Barrows Go to last post
4 161
December 31st, 2009 04:55 AM
by Tony Toews [MVP] Go to last post
4 176
UNION query taking 5 minutes for approx 2000 records - any tune uptips? by JohnM[_5_]
I am dealing with data from two hospitals, each with their version of the database. I am trying to group records of admissions and discharges from each...
December 31st, 2009 03:24 AM
by david Go to last post
1 178
need help removing zeros with Left or right?? by Barry A&P[_2_]
way back when everything was typewritten Bell Used partnumbers like 204-040-032-1 that was all find and dandy well now they changed all the endings...
December 31st, 2009 02:29 AM
by Barry A&P[_2_] Go to last post
3 158
query in access 2007 pulls yes only answers by Kim T
I've got a form that has Y/N questions I want to make a query that only pulls the yes answers then turn that into a report need help please.
(Multi-page thread 1 2)
December 31st, 2009 12:48 AM
by KenSheridan via AccessMonster.com Go to last post
10 309
splits investment transaction by Anne
I need an idea on how to split a transaction into two. I am recording investments in stocks and bonds, and many times only part of the shares are sold and I...
December 30th, 2009 11:14 PM
by Anne Go to last post
1 116
calculated field by angie
i have a query with the following fields: year, month, customer, debit euro, credit euro and balance (debit-credit). the query returns multible entries for...
December 30th, 2009 08:31 PM
by Anne Go to last post
3 172
format OXXXXXO by Octet32
I have a field in a query called DELDAYS in the field the date reads 0XXXXX0 how can I for matt this so it will show as SMTWTHFS? This date represent the day...
December 30th, 2009 07:32 PM
by raskew via AccessMonster.com Go to last post
6 276
How to add another field to a max query result without grouping by Barry A&P[_2_]
I am trying to create a query to find the most recent locationID for each item with a TrkID but i can only seem to get it with two queries then join it back...
December 30th, 2009 06:29 PM
by Barry A&P[_2_] Go to last post
1 127
show top values by Ian
posted to SQL Queries English with no reponse -- sorry for the repeat I have a single table with 5 fields: READID (key, INT), ID (user identifier, INT),...
December 30th, 2009 06:14 PM
by Ian Go to last post
5 213
I believe I have an AutoCorrect Issue with a field name? by BobC[_6_]
I have 4 linked tables in Access 2007. At one point in time I was having issues with what turned out to be an AutoCorrect associated file and whether or not...
December 30th, 2009 04:40 PM
by John Spencer Go to last post
6 339
Is there a way to turn off the prompts of a make table query? by BobC[_6_]
I merely want to update the table to be used as an export to Excel using TransferSpreadsheet. Each time it prompts for deleting old records and adding new...
December 30th, 2009 02:55 PM
by Gina Whipp Go to last post
3 191
help with nested iif statement by Help with complex nested iif statement
I have a table and I want to create a query that has a new field " Type of Shipment" base on a field "Item Category" If the item category field equals ZDIR,...
December 30th, 2009 05:40 AM
by John W. Vinson Go to last post
3 169
Dlookup Expression Error by Pamela
My query is based on a table that I use to populate a cbo on a form. My table includes: ID(pk), ShopName, and ShopCity (which stores the ID # from...
December 30th, 2009 03:06 AM
by Pamela Go to last post
2 138
Post New Thread


Display Options
Showing threads 1801 to 1820 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 11:47 PM.


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