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 Reverse Sort Order / Thread Starter Last Post Replies Views
Writing numbers as alpha by Dudley
I produce mail merge documents using an Access query, and I need to write numbers as alpha, eg 100 as ONE HUNDRED. Can anyone advise how to do this? Thanks...
September 7th, 2007 09:50 AM
by Dudley Go to last post
7 75
Writing information to a new file by KB
OK I am a little stumped. I am working on a dispute database. I have a main data table which users update via a form. On this form I have a number of push...
May 24th, 2005 05:38 PM
by Martin J Go to last post
1 65
writing in english & spanish, are both grammer and spellchecks po. by leftytx
I write in English and Spanish. Are both spell and grammer checks possible
January 22nd, 2005 06:53 PM
by John Vinson Go to last post
2 65
Writing expression which selects last names from field of full nam by daylily
I am converting a large database to Access and need to divide a field containing full names into seperate fields (ie., First name, middle initial and last...
September 20th, 2004 10:19 PM
by John Spencer (MVP) Go to last post
3 86
Writing Data to Table from Query by Manuel
I have a table called tbl_training which stores training data. The fields in the table are as follows: ID (this is the primary key; data type: AutoNumber),...
January 9th, 2007 09:50 PM
by Manuel Go to last post
2 81
Writing Criteria Expression by amyfinlay
When creating a simple query, how do I write a criteria expression that will retreive only records with a "Yes" value in a field with "Yes/No" data type?
October 15th, 2004 03:24 AM
by Ken Snell [MVP] Go to last post
1 283
Writing an expression using fields with different formats by Whitney
I need to subtract a field sum from another, but they are in different formats. How can I convert one of themor get one to recognize the other? For...
January 9th, 2008 01:52 AM
by Whitney Go to last post
4 113
Writing about Access by ZZZ
Hi all, My apologies if this post does not respect newsgroup standards. I am unsure what is Okay to post here. I am interested in hearing from Access...
December 1st, 2004 03:06 PM
by ZZZ Go to last post
0 204
Writing a VBA Query for MS Access and have it show the Query Object Window by Pete Straman Straman via AccessMonster.com
I need to write VBA code for MS Access that runs a query and sets it in the Query Objects view. I have set up and performed operations on tables but can not...
February 4th, 2005 07:08 PM
by John Vinson Go to last post
5 291
writing a timestamp to a table? by [email protected]
Is there not a simple way to do this? The help page for the time date functions say that they are to be used in calculated controls in forms. If I set a...
December 4th, 2006 09:14 PM
by Marshall Barton Go to last post
1 66
Writing A Select Statement To Return a Count Of Unique Dates In aTable by R Tanner
Hi, I'm trying to write a query that will return a count of unique Dates in a table. The following is what I have been trying to use thus far. I just can't...
January 9th, 2009 06:02 PM
by R Tanner Go to last post
2 80
Writing a script by ChuckW
Hi, I am writing a script and need to figure out how in the script to have the tab key pressed followed by enter. Can anyone help? Thanks, Chuck
September 19th, 2004 01:58 PM
by Jeff Boyce Go to last post
1 92
Writing a query using VBA - Variable where clause by BlueWolverine
Hello, MS ACCESS 2003 on XP Pro. I want to write a query using vba based on the selection(s) from a list box. If the list box has N entries, I want the user...
March 3rd, 2009 07:51 PM
by Michel Walsh Go to last post
7 140
Writing a query to return only rows that are null by [email protected]
I am trying figure out how to get access to do the following: Column 1 = Name Column 2 = Project1 Column 3 = Project2 Column 4 = Project3 Column 5 =...
May 11th, 2007 05:22 PM
by John Spencer Go to last post
2 76
Writing a query to get a sum of a group average by ktm400
Please help - I have a table with 3 columns. One of the columns is date, one is time and the last one is the value I want to average. What I need to do is...
February 7th, 2007 09:36 PM
by Jason Lepack Go to last post
8 98
Writing a query to count records with partial match by Pennington
? have a table of names and addresses including a 7 digit postcode E.g BA16 7TY in a list of other BA* together with TA*, GL* etc. When I create a query...
February 14th, 2008 05:09 PM
by Pennington Go to last post
4 128
Writing =Dlookup() into TextBox.RecordSource using VB at run time. by Ilya
I have the problem: Access rejected quotes inside Dlookup() and Char "=". So I have changed them for Chr(34) and Chr(61). Now there is no syntax error in thee...
December 11th, 2004 09:35 AM
by Steve Schapel Go to last post
3 158
Write the first digit, only by an
Hello! I have records with numeric IdNum and others fields. When is assumed, in query, the fix digit=1, for exemple: Like 1 & "*" very well but, in this time,...
July 27th, 2004 07:04 PM
by an Go to last post
2 66
Write Text Box to A Table by neenmarie
I'm using a form as a menu. There is a text box on the form that the user enters a date into. This date is used in multiple queries during the...
December 14th, 2005 04:39 PM
by neenmarie Go to last post
2 105
write sql using a form by Randal
I have several fields that I need to concatenate together based on user selection in a form. For example, if the user selects Field1 then Field2, I need a...
October 6th, 2004 11:14 AM
by Michel Walsh Go to last post
1 91
Post New Thread


Display Options
Showing threads 201 to 220 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 05:58 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.