Search results

Because I need to calculate sum etc and I cant do it on letters so I need to bring it back to the original digits so that I can perform arithmetic operations on it.

Hi friends Want to know that I have used Replace function in the form so when the user presses enter, the digits change to a particular code. But since the report is only for me, I want the original numbers in the report rather than the coded value. Is it possible? Thanks in advance.

No :banghead:

its like the whole record is coming 5 times

yes, thats what I did, slowly adding fields but at a point it duplicates, I checked the sql code, couldn't find anything. just wondering what could be the reason.

I guess I made some mistakes that Im unaware of. In the start it was only giving me the required records but when I tried after a while it started giving me duplicates.

and no duplicates are coming in the query you gave.

q are the 30 text boxes where user enter 30 sizes of the order. Same is size boxes.

The query is working but giving me duplicate records. It shows me one record 5 times. SELECT order.[SalesOrderNo], order.[oDate], order.[Application], order.[AdditionalInformation], order.[Image], order.[Image].[FileData], [Image].[FileFlags] AS Expr1, order.[Image].[FileName]...

tried it. Not working

aye got it, now I want to give a print command to print only those orders that are not shipped.

I have just a check box for shipment. If ticked then shipped if unchecked, it means still pending.

alright got the point. One more thing if I only need to take print of the forms that are shipped or not shipped. How to go about that. Consider em a novice and help please.

ok suppose I want to shift then... you are not answering my question :(

sometimes we need to only deal with the pending orders and like printing and all and sometimes we need to play with the shipped orders. So we want to keep it in separate tables. Can I get the solution how to move records from one table to another please?

I can filter the records but how can I move them to another table. Plz help

We have one table for all the orders coming. Now when the orders get ready and are shipped, they need to be moved from the orders table to the shipped table. So that the orders table only contain the new/pending orders.

Thanks Simon I have already split my db in back end and front end. Is that what you are suggesting? or some other approach? Ok so I will design a query to filter the shipped records but then I need to move those records from the ''order' table to the ''shipped'' table. I need it to be deleted...

My db has exactly 116 fields and its working fine. Just need to move records. What could be done?

Hi there I need a help in Access. I have a full database including too many fields. Now I want to insert a checkbox 'shipped'. When I tick it, I need the 'ticked' records to automatically move(cut) from the order table/file to shipped table/file. Is it possible? If yes, how can I achieve this...