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 06:21 PM
by John Spencer Go to last post
2 127
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 06:00 PM
by Dale Fye Go to last post
5 130
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 03:36 PM
by Nedan Nedzatra[_2_] Go to last post
2 102
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 03:31 PM
by Tracey Go to last post
3 136
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 03:22 PM
by Dorian Go to last post
1 101
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 03:02 PM
by Dale Fye Go to last post
2 128
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 01:58 PM
by Bob Barrows Go to last post
4 93
December 31st, 2009 03:55 AM
by Tony Toews [MVP] Go to last post
4 100
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 02:24 AM
by david Go to last post
1 107
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 01:29 AM
by Barry A&P[_2_] Go to last post
3 106
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 30th, 2009 11:48 PM
by KenSheridan via AccessMonster.com Go to last post
10 216
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 10:14 PM
by Anne Go to last post
1 75
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 07:31 PM
by Anne Go to last post
3 130
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 06:32 PM
by raskew via AccessMonster.com Go to last post
6 178
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 05:29 PM
by Barry A&P[_2_] Go to last post
1 94
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 05:14 PM
by Ian Go to last post
5 151
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 03:40 PM
by John Spencer Go to last post
6 138
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 01:55 PM
by Gina Whipp Go to last post
3 104
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 04:40 AM
by John W. Vinson Go to last post
3 86
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 02:06 AM
by Pamela Go to last post
2 86
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 02:22 AM.


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