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
SQL Command to List all Tables? by Harry Whitehouse
I'm trying to read an Access database from a C++ program and get a list of the table names in the target MDB. I've done this with SQL Server with this...
February 15th, 2007 03:52 PM
by Harry Whitehouse Go to last post
2 144
Format text by Rodney
Hi, I am just trying to set the format to capitalise the first letter. I am using L??????????? But every time I change fields it changes...
February 15th, 2007 02:55 PM
by John Spencer Go to last post
1 151
Subform parameter query by [email protected]
There is probably a much better way to do this, and I hope there is, but here is what I am trying to do: I have two controls on a "subform" (a combobox and a...
February 15th, 2007 02:42 PM
by [email protected] Go to last post
1 175
query by Helen
I want to be able to take two tables I have and join them into 1 linking it by last name and first name. The first name in table 1 is the actual first name,...
February 15th, 2007 02:36 PM
by John Spencer Go to last post
2 148
Accessing Queries in another file by ACCESS2007
Database is Access 2000 format but working with in Access 2007 I have a database split into three files; one holds the tables, another holds the...
February 15th, 2007 01:52 PM
by Jeff Boyce Go to last post
3 191
Adding a prefix number by CAM
Hello, In my query I have a text field called "Location" in this field I usually have a single digit number or a double or triple digit number. What I want...
February 15th, 2007 07:52 AM
by John W. Vinson Go to last post
2 208
Make 1.5 million in 11 minutes by Virgin Mobile
Find out how Roy . Made over 1 million in 15 minutes. http://alberta-oilsands.blogspot.com/
February 15th, 2007 07:27 AM
by Virgin Mobile Go to last post
0 141
Duplicate Query by quest1914
I am attempting to find duplicate numbers by creating a new query in Access. I have imported an excel file with multiple worksheets into access and would...
February 15th, 2007 05:57 AM
by John W. Vinson Go to last post
3 174
how to chek if a field is not null by Moe
I have query that populates a Report based on values and fields from two tables. However, it shoud not include any record where one specific field is blank....
February 15th, 2007 03:06 AM
by Paul B Go to last post
1 135
Invalid Argument Error with Append Query by stenz
We've been getting an Invalid Argument error whenever we try to run an append query. We have not had this problem in the past. We have just installed the...
February 15th, 2007 02:53 AM
by [email protected] Go to last post
3 121
First|Last Function by May
Field “code” is a text variable in a table and it can be sorted properly in the same way as a numeric variable. In a query, I want the dataset shows the...
February 15th, 2007 01:34 AM
by Marshall Barton Go to last post
7 149
weekend query by Joel Allen
Hi there, I have a query that does: - and it gives me a number of days. This works, but I want it exclude Saturday and Sundays. Is there a way to do...
February 15th, 2007 01:29 AM
by Smartin Go to last post
1 138
need help with percent by oxicottin
I have a qry where I want to divide "Regular Delay" by "Employee Regular Time" and give me a percent. Example: Regular Delay 2.5hrs Employee Regular Time...
February 15th, 2007 01:14 AM
by oxicottin Go to last post
4 139
Can I sort by field A but group by field B? by Michael Nagan
My data looks something like this: Date Job ID Expense 1/1/07 1 $100 1/2/07 1 $50
February 15th, 2007 01:10 AM
by Allen Browne Go to last post
3 135
Queries with Parameters by Dale
Is there a way to have a 2 queries with a parameter input and then have a 3rd call these queries selecting everything and unioning them together somehow...
February 15th, 2007 12:57 AM
by John Spencer Go to last post
2 158
show dups where all fields equal by perryclisbee via AccessMonster.com
I have a detailed patient information table with instances where there are duplicate claim numbers . I ran a query that showed all cases where the claim...
February 15th, 2007 12:03 AM
by jamesdeckert Go to last post
1 166
flip this query by rodchar
hey all, i have a query that produces the following results: field1 field2 field3 ------ ------ ------- val1 val2 val3 well there are so many fields that it...
February 14th, 2007 11:29 PM
by John W. Vinson Go to last post
3 173
Association Difficulty by Allison
Windows XP Pro SP2, Access 2003 I have a query containing (among other fields) the fields: fldName (text), fldID (number), fldPrimary (yes/no field), and...
February 14th, 2007 11:24 PM
by Allison Go to last post
2 139
Crosstab more than a years data?? by Bill
Hi All, I would like to use a crosstab query to analyse monthly data over a longer period than a year but it doesn't seem to be able to do that, instead the...
(Multi-page thread 1 2)
February 14th, 2007 11:12 PM
by Duane Hookom Go to last post
12 218
What am I missing? by Amy Blankenship
I have a query that creates a new record but does not populate all the fields. All fields except the memo field (reportRTF) populate properly. I'm guessing...
February 14th, 2007 10:47 PM
by Amy Blankenship Go to last post
7 143
Post New Thread


Display Options
Showing threads 20121 to 20140 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:38 AM.


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