Search results

what is the data type for your field ListPrice ?

Select tblA.*, "SO Master" As TableUsed UNION Select tblB.*, "SO_Master_Shipped" As TableUsed

Hey Tesread, i have a Funtion called WorkingDays that you can give it 2 dates and will give you the working days excluding the weekends and holidays let me know if you are looking for something like that

keep getting an error (Query input must contain at least one table or query.)!!

I tried that BOB, but sometimes the record is in TableA and sometimes in TableB!! And you can’t populate 2 tables into one form

can someone help please

hey All, I have a union query that includes 2 tables TableA and TableB And I have a field called Comments in the 2 tables And I have a form where the records source is the union query that lists the data as datasheet Is there a way to add the Comments (in TableA or B) thru the unit queries ...

i think the easy way to go is PHP and MySQL good luck

actualy this is the one that did the trick Between (Date()-2) And (Date()+1)

here is what i did and got the correct result change the date in the Query for Today: to : Between Date() And (Date()+1)

I saw where are you coming from! But that’s not what the Form was for and that’s not the calculation I want :( because there are order that reviewed today but received 5 days later ...

and what are you trying to do exactly ?

here you go .. hope this works koz first time for me uploading :( http://www.mediafire.com/?f1e6093ezz19bk9 or http://www.mediafire.com/file/f1e6093ezz19bk9/Database2.accdb

where are you using this? what application?

you are welcome Please feel free to share your results/work around with the world ;)

the Fields are Date/Time. here is what i get from the Query: here is what it should looks like:

still not the right results!

Go to Linked Table Manager and select one of your linked Tables and Click OK, then it will ask for the Password ...

and your suggestion to change to Expression works .. thanks but it only works is Reviewed Date = Recieved Date !! here is what i did to try to fill all the Text boxes up: SOReviewedYesterday: Count(IIf([Reviewed]=(Date()-1),[Sales_Order],Null)) QtyReviewedYesterday...

thanks man, just to add ()(): SOReviewedYesterday: Count(IIF([Reviewed Date] = (Date() - 1), 1, Null)) QtyRecievedToday: Sum(IIF([Recieved Date] = Date(), Qty, Null)) also the part * Right-click any of the fields and select Totals generates a Groupping error, but after removing the Totals...