Search results for query: *

thread701-1136806 Hello, I been trying to follow the steps in thread thread701-1136806 to add my fields [P/U day] + [Transit days] while taking into account weekends. I'm however getting a zero as my value. not sure what im doing wrong but here's my Query SELECT [Estimated Delivery...

Hello, I need one of my cells to put a date stamp on that row every time a value is entered. Example every time a value is entered in cell D14, Cell AF14 will automatically put today’s date and keep that date forever. I tried the following formula =IF (D14,TODAy(),"") but every time I open my...

is there any way i can create a barcode from fields in a datase?

How can i calculate the difference between time in excel? Exm Start Time End Time # of Seconds # of Minutes 9:00 18:18 558 9:18 I want the formula to tell me the # of seconds and number of minutes. Thanks JG

How do I run queries from another database? or maybe there is a better way to do this. here's what i am trying to do. I have one database that uses data from 18 databases, I need to run a querie which updates the data in each of this 18 databases. I would like to create a command that would...

Hello, I have the following IIF statement but i keep getting an #error. any ideas what i am doing wrong? Thanks JG REC: IIf([adj]>=[trigger],&quot;YES&quot;,IIf([adj]<[trigger],&quot;NO&quot;)) I even tried this and still keep getting an error. REC2...

Hello, I currently have a query that randomly selects 100 records from a table. My SQL statement looks like this: SELECT TOP 100 * FROM [X1A Pick Slots] ORDER BY Rnd(asc([slot])); I'm trying to change my statement so that i can enter the number of records i want to select every time i run...

I have a query that randomly selects 87 records from a table, is there a way that every time i run this query those 87 records are deleted from the original table so they can't be selected again??? Please Help!!! Thanks