Running & Setting Up Queries - Page 72

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.

		Home » OfficeFrustration forum » Microsoft Access
Running & Setting Up Queries

Home

Page 72 of 2165

Threads in Forum : Running & Setting Up Queries

Forum Tools

Search this Forum

Thread / Thread Starter	Last Post	Replies	Views
USING PARAMETERS IN A CROSSTAB QUERY by Kingsoft Hello, Does Access allow the use of parameters in crosstab queries? I have attempted to add a parameter in my query but get the following error message: The...	January 29th, 2010 05:04 PM by Kingsoft	4	111
select user from .... by William Help please. In an Oracle database I can identify the current user with the statement "SELECT USER FROM DUAL;" Can I do something similar in MS Access?	January 29th, 2010 03:22 PM by ghetto_banjo	3	206
Need to show continuous time in the form by naveen prasad[_2_] hi all, In my form I want to show continous system time, it should show according to system time I tried to add text box, and in form properties - on load...	January 29th, 2010 03:09 PM by naveen prasad[_2_]	4	130
Shouldn't a LEFT JOIN work this way? by MJatAflac If I have two table and I want to get all of the records from one and only the matching records from the other, shouldn't I be able to just use a left...	January 29th, 2010 02:05 PM by Gina Whipp	7	156
Adding values in to table for appropriate fields only by naveen prasad Hi all i have a table T1 Fields are a1,a2,a3, b1,b2,b3, c1,c2,c3, d1,d2,d3, e1,e2,e3 = 15 fields created a1,a2,a3 belongs to 1 group like requests...	January 29th, 2010 07:55 AM by naveen prasad[_2_]	5	125
If you buy the world's best and the cheapest batteries will not blame me by Starain[_2_] www.laptop-battery-inc.co.uk This is inside what used between the plates £££*spy pen http://www.laptop-battery-inc.co.uk/spy-pen.htm	January 29th, 2010 03:35 AM by Starain[_2_]	0	111
fractional part of value returns multiple digits by Bill.Carlson Access 2007 We have imported data (through copy and paste append) from another application into an Access table and we are struggling with maintaining a value...	January 28th, 2010 10:15 PM by Bill.Carlson	3	139
Pass-Through Query Prompting for ID# by IrishRed Hello, I have a pass-through query in which the SQL looks like this: select Field A, Field B, Field C from Table1 where MemberID = '1245%' order by...	January 28th, 2010 09:49 PM by IrishRed	4	131
combining 2 expressions by clalc I have created 2 separate expressions in query: Test_1: IIf(! Not Like (""),"Missing",0) Test_2: IIf(! Not Like (""),1, "Found") When I combine them...	January 28th, 2010 08:53 PM by clalc	3	144
Datediff by Lucinda Hello Access Gurus: I have an Access 2003 database that I am trying to calculate datepart and datediff; I need assistance with the datediff portion. Here is...	January 28th, 2010 08:27 PM by Lucinda	2	99
Splitting a table into smaller tables by joseph g I'm trying to split firsttable into smaller tables based on values in firsttable. no relationships need to be maintained. FIRSTTABLE 1 green eggs 1 orange...	January 28th, 2010 08:09 PM by John W. Vinson	8	119
Counting by groups by John R.[_2_] I can count records down in a group on a report. Is there a way to cont and store in a query to start and renumber from one. I want to get a list of the top...	January 28th, 2010 08:06 PM by vanderghast	5	75
Query to text file cuts my leading zeros off. by Vadimbar Hello, this is my third attempt to post this question. I have a query that has a value of "012810" in one of the fields. When I run the query it shows up as...	January 28th, 2010 06:40 PM by Vadimbar	4	123
adding yes/no field by MaRSMAN[_2_] How do I add a check box field to my query field name to be "Active" I Tried Active:=yes/no,checkbox DIDN't WORK can you fix for me or is it not able to...	January 28th, 2010 06:22 PM by John W. Vinson	2	111
Automatically adding a record by Scott McSweeney Hi I'm making a database for a lawnmowing bussiness and have got stuck on the scheduling. when entering jobs done I want to have a new shedule(record) entered...	January 28th, 2010 04:33 PM by Dorian	1	112
Query?? or something else? by Heath[_2_] Greetings all, I am new to actually messing around in access and can’t seem to find a solution to my problem. I have two tables one is Employees and the...	January 28th, 2010 04:05 PM by John Spencer	5	129
calculating a percentage by Belinda7237 I have a field Question 1aa that has a result of Yes or No I also have a record id count for a particular month 9user enters a start and end date) The...	January 28th, 2010 03:09 PM by Marshall Barton	1	123
Query - Crosstab ? by rob4465 via AccessMonster.com Hi Good Morning, I currently have a query that displays six columns: Company \| Product1 \| Product2 \| Product3 \| Product4 \| Product5 So one row...	January 28th, 2010 12:53 PM by rob4465 via AccessMonster.com	2	107
Replace third space with "-" by Ljudmil Hi I have a text field whose records contain for 1 to 4 words, separated by space. I am wondering if I can replace automatically only third spaces with...	January 28th, 2010 08:24 AM by Ljudmil	3	144
Nz function in query by trevorC via AccessMonster.com Hi All, the query below shows an error if any of the date in / date out entries in the table are empty. How can i impiment the Nz function to stop this. SQL...	January 28th, 2010 07:17 AM by trevorC via AccessMonster.com	2	87

Page 72 of 2165

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	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 01:13 PM.