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
Help!! withdrawing materials from a stock. by Chris
In a form, i have a command button with a code like below, which is making a sellection from a query (which represent the current state of a stock) to display...
May 26th, 2004 06:14 AM
by Chris Go to last post
0 290
Using IIF statement in Memo Field by J Cunningham
Hi, I'm fairly new to Access, and I need to write a query which will check a memo field to see if it is null, then display "n" (for not having data in the...
May 26th, 2004 09:19 AM
by david epsom dot com dot au Go to last post
5 896
Urgent - Problems with grouping Unique values by FJP
I have three tables; tblsalesrep, tblclients, tblgeneral. tblclients references tblsalesrep to show what salesrep is assigned to that particular client,...
May 26th, 2004 09:26 AM
by Nikos Yannacopoulos Go to last post
1 293
Access 2000 SP3 Issues by Paul Lockwood
Hello We have just upgraded all of our machines to Office SP3. Since doing this I am now getting a large number of errors within Access db's. A couple of the...
May 26th, 2004 09:30 AM
by david epsom dot com dot au Go to last post
3 354
three leters abbr for Day of week by gal
Hi group, I have a report that runs totals accompanied with the date and the day of the week. All my days are being displayed with three letter abbreviation...
May 26th, 2004 09:56 AM
by Peter R. Fletcher Go to last post
2 329
Convert data. by Robert
I have a table with phone number that were imported in the following format (212)-555-0440. The field is set to text, with no input masks. I need to convert...
May 26th, 2004 10:56 AM
by ali kwok Go to last post
2 298
more dates!!! by brigid
How is this any different than the current code? -----Original Message----- Hi, .... WHERE myField BETWEEN Nz( Nz( StartDate, EndDate), date() ) ...
May 26th, 2004 10:59 AM
by Michel Walsh Go to last post
6 1,041
"Fill-in data when there's no data" by Gary Walter
Hi Bob, I have helped several people do similar; it is for sure doable and fairly straightforward.... but I would first like to know how you will be limiting...
May 26th, 2004 11:49 AM
by Gary Walter Go to last post
0 347
Limiting a query by Fay Yocum
I have a grant that one staff member's salary comes from. There can only be one staff member that gets paid from that grant at a time. If this person cares for...
May 26th, 2004 12:13 PM
by Michel Walsh Go to last post
1 304
string by Allouche Patrick
Salut j'aimerai remplacer un carctere present plusieur fois dans une chaine ? 1-2-3-4-5-6 deviendrai 1 2 3 4 5 6 donc '-' par ' ' ou encor inser un espace ce...
May 26th, 2004 02:56 PM
by Cheryl Fischer Go to last post
1 334
Unmatched Query by
I have created an unmatched query using the wizard. However I wanted the query to check more than one field before returning the unmatched records? Any ideas?
May 26th, 2004 03:20 PM
by Allen Browne Go to last post
1 1,068
Access query is renaming output fields - dreadfully inconvenient by JonR
Hello, I am running a select query with a lot of different output fields. These fields relate all information pertaining to a number of projects that may be...
May 26th, 2004 03:31 PM
by JonR Go to last post
3 689
Crosstab Report and query by Newbie
Hi, I have the following query - see below I want a report that is based on week number - the actual week number needs to be on the report. I have written a...
May 26th, 2004 05:11 PM
by Newbie Go to last post
4 714
need to delete the first 4 numbers of each record by Jimmy
I have 45000 records. In one field about 80% of those records are in a format: 4numbers space and a word (any word). What I need is to delete those 4 first...
May 26th, 2004 05:15 PM
by Go to last post
2 463
Please help me!!! by Ann
Hi to anyone who can help. I have a table with the following fields: Last Name First Name Course ID 1 Course date req 1 Course ID 2 Course date req 2
May 26th, 2004 06:17 PM
by Ann Go to last post
2 345
Crosstab Query Help by Newbie
Hi, I have the following query PARAMETERS !frmMetalRequirements! DateTime; TRANSFORM Sum(tblMatlSchedule.OSQtyReqd) AS SumOfOSQtyReqd SELECT...
May 26th, 2004 06:22 PM
by Michel Walsh Go to last post
1 291
Convert grouped records into a string by mmattson
I am trying to convert all the names I have listed in a grouped query into one string record. For example, I am 1) grouping my records by date, 2) each date...
May 26th, 2004 07:04 PM
by Duane Hookom Go to last post
1 417
crosstab query not showing all values by Michel Peeters
I have a crosstabquery. The 8 column headings are weeknr based on DateDif. The value is the sum of Kg (double) The rowheadings are fields from the customer...
May 26th, 2004 07:32 PM
by Michel Peeters Go to last post
0 526
Multiple Append Queries to One Table by wpshop
I have a table with 5 fields. Each field's value can be calculated by using a Query to run a count on existing information in the main table. I can change...
May 26th, 2004 07:51 PM
by wpshop Go to last post
2 630
Return String from Boolean Field by Dragon
Hi, I have the following query collecting data from a table where 'Complete' field is a yes/no field. I am exporting this data for a PDF merge and what I need...
May 26th, 2004 08:08 PM
by Dragon Go to last post
2 397
Post New Thread


Display Options
Showing threads 61 to 80 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 06:59 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.