Please Help On An Expression

[NewYorkFashionToGo]

Hello everyone, This is a great board, I been lurking in the background for a few weeks now, reading learning education myself with the programming.

I am relatively new to Access I am better in Excel But like what Access can do so I am making an uneasy transition.

I am trying to create an expression in queries to sort out People who Paid me, People who Need to pay me Orders That I need to ship. I am trying to create an expression using Paid on date shipped on date. If no payment was made,or shippment the value is Null in the cell. I am completely able to do this using words using the iif function but stuck on how to get a date to function there. In excel I am able to date>1 and it works fine, This is a bit different in access.

Any advice would be greatly appreciated, Its been a nightmare learning and trying to get this to function the way I want.

Thanks

 

[MichaelRed]

In Ms. A., (as well as MANY Ms. Products) date is just a particular way of formatting a real number, so your expression Date > 1 is usually valid as a criteria expression. On the other hand, Date is a 'reserved' word (e.g. the name of an intrinsic object), so is avoided in naming of fields. The expression "Date()" generically refers to the current date, while "[Date]" )in a query / expression would refer to the value / content of a field (inappropiatly?) named "Date".

If you are switching to Ms. A. as a general practice, I would advise you to 'get thyself to ye olde corner BookShopee' where you will find some material suitable to the task at hand.




MichaelRed

 

[NewYorkFashionToGo]

Thanks for your reply Michael, That gives me a start, I need to convert Date to serial number, I think, I already have the books, Just dont have the time, Not to be confused with the desire to learn it.Or read up on it, I am reading, websites (like this one) books, I am finding myself spending full days trying to get one simple thing to execute. Im running out of time and money, I am down right now.And need to get it going.

I think for now I will excute a few new columns in excel to convert dates to Paid, Awaiting shipment,To Print, or a new column for serial time and pump it into access, I already know i can get it to match up this way in access. It just functions slightly different than excel. Its saving a whole lot of time in long run, with If(exact(vlookupfunctions on 6 different sheets. getting things to all match,Properly

I just need to learn the terminology with this program, and a few key areas and I will be on my way. I already am,

Thanks for your time taking to write to my post I do appreciate it.

 

[PHV]

Have you tried to play with the IsNull function or the IS NULL operator ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[MichaelRed]

in a company I worked for a long time ago, we had a 'mantra':

" ... there is never time to do it right ... there is ALWAYS time to do it over "

while I appreciate the deadline in concept, I have long ago left the company ... and the mantra behind returning to the philosphy that it is Perfect practice than makes for perfecy performance, not JUST the practice.

Take the time, do the work.




MichaelRed