I have already reposted this question in this forum and given the query in that post.
Thanks....
imnewtoaccess
Last Activity: Jul 30 '07, 11:11 PM
Joined: Jun 6 '07
Location:
-
This is the query.
...Code:SELECT "S0400016" AS LINE_HEADER, Format(TK_TCK_SALE_DETAILS1.DATE,'mmddyyyy') & Format(TK_TCK_SALE_DETAILS1.TIME,'hhnn') AS PURCHASE_TIME, Mid(TK_TCK_SALE_DETAILS1.WORKCODE,9,2) & '.' & FORMAT(RIGHT(CSTR(TK_TCK_SALE_DETAILS1.TCK_NBR),3),'000') & '.' & Format(TK_TCK_SALE_DETAILS1.DATE,'mmddyy') AS TRANSACTION_CODE, TK_IMPORT_TICKET1.TK_SERIAL_EXTERNAL AS TICKET_BARCODE, TK_PROGRAM_DETAILS1.SHORT_NAME
Leave a comment:
-
Query Save Error
Hi All,
Whenever i try to save a query, I get an error 'Inavlid Argument'. But I can execute the query and get the desired result. I want to use the query in another query to generate a file.
Pls Help....this is urgent.
Thanks in advance. -
Query Save Error
Hi,
When I save a query in MS ACCESS 2000, I get the error 'Invalid Argument'. But I can execute the query very well and I get the desired result. But I want to save this query and use it another one to create a file.
Pls Help !!!!
Thanks In Advance. -
ODBC Call Failed Error for Query using Linked Tables
Hi,
...Code:SELECT TK_TURN_DAILY_DETAIL1.DATE, TK_TURN_DAILY_DETAIL1.USH_REVENUE AS TDL_Revenue, TK_TCK_SALE_DETAILS1.USH_REVENUE AS TSD_Revenue, [TSD_Revenue]-[TDL_Revenue] AS Expr1, TK_TCK_SALE_DETAILS1.TK_SERIAL AS TSD_TK_SERIAL, TK_TURN_DAILY_DETAIL1.TK_SERIAL AS TDL_TK_SERIAL, TK_TCK_SALE_DETAILS1.QTY_TIX_REP AS TSD_Quantity, TK_TURN_DAILY_DETAIL1.TCK_SCAN_QTY AS TDL_Quantity FROM TK_TCK_SALE_DETAILS1 RIGHT JOIN (TK_TURN_DAILY_DETAIL1
-
SQL Error in DB2 and MS Access
Hi,
I am new to DB2. From the command center when I run this query I get the error given below the query :
Select a.tk_serial_ext ernal, a.tk_serial_int ernal, b.ush_revenue, c.ush_revenue, b.date
from tk.import_ticke t as a inner join tk.turn_daily_d etail as b
on a.tk_serial_ext ernal = b.tk_serial
inner join tk.tck_sale_det ails as c
on a.tk_serial_int ernal = c.tk_serial
where b.ush_revenue... -
Number Formattng
Hello,
I am getting a numeric value in a query like 42.56, 89.67, 56.77, etc.
I want to format these values like 04256, 08967, 05677.
Please help !!!!!!
Thanks in advance. -
Query a query with parameters
Hi all,
I have created a query in msaccess with a parameter.
Now I want to query that query but without the parameter. Is it possible ? -
Thanks. I thought it doesn't return NULL for values not found in one table, and so I was checking for spaces....Leave a comment:
-
LEFT JOIN Query Help
Hello everybody,
I have two tables : ac_online_scann ed_tkts_1 and TK_IMPORT_TICKE T1.
Both have external barcodes of tickets, but not all of them in ac_online_scann ed_tkts_1 table exist in TK_IMPORT_TICKE T1 table. I want a list of all those external barcodes that exist in ac_online_scann ed_tkts_1 table but do not exist in TK_IMPORT_TICKE T1 table. I am using the follwoing LEFT JOIN query to get these results, but I am not getting... -
if i use format directly on the text fields it gives incorrect date values.Leave a comment:
-
It is very strange...... MS Access is giving that error. But when I click on 'Yes' to ignore the error and run the query, it inserts those records that i want.Leave a comment:
-
Well, the other date fields are string fields in format "mmddyyyy". so i have to format them the way i am doing it in the query ( and cannot use the format function on them ).Leave a comment:
-
You have to create a table with the Time String you want to display corresponding to each time of the day, and use that table in your report.Leave a comment:
-
Violation errors while inserting data from one table into another
Hi,
I am getting errors while inserting records in one table from another.
These are the structures of two tables :
file51tm_new
RecordType Text
RecordNumber Number
WorkCOde Text
Date TExt
Tck_nbr Text
time text
transno text
Start_date Text
End_date TExt
Tk_serial Text
tck_price text
void_code text
... -
Thanks for the reply. I did use the DMax function, but directly in the query, and it worked fine.
Thanks again.Leave a comment:
-
Hi... Updateable Query Error with a Subquery
Hello everybody,
I am completely new to access and am facing a problem.
I am trying to run the following query from the query designer ( i am using access 2000 and the table that i am trying to update is created by me ) and I am getting the error 'Operation must use an updateable query'
UPDATE ac_online_scann ed_tkts_1 SET ac_online_scann ed_tkts_1.Batch = ( Select Max (temp.batch) as t1 from ac_online_scann ed_tkts_1...
No activity results to display
Leave a comment: