Recent content by Lucia Balkamp

Don't why I didn't think about it. I just used <Date() and it worked Thank you for your help in getting my brain to work Lucia

so there is no code for just entering a simple date?

I'm working on a report of pass due items with a date showing when they were due. I would like be able to enter or have today's date automaticly used and have the query only show me all items on the report. <=#11/18/2010# works Returns all orders open before 11/18 but this has no prompt...

OMG...... I would kiss you if you were here !!!!!! but since your not I'll drink a shot for you THANKS big time !!!!! L

Ok, I got lost but I built a query for it but where would I place the code, I tried putting it in the Criteria and in the General tab area, the numbers did not change. Please help me, L

Thanks, I know how it can be and a lot can be lost in the translation Have a great day !!1

Actually, it looks like the format it is being linked to Access is a Number format. Is there another code and does this code go in the Design View, General Tab, Format? Thanks so much, I need a Tequila today Lucia

I got a crazy excel file I'm linking to a Access table. There are 4 columns with dates on the report that look like this 1100106 which is really 01/06/10 (Jan. 6, 2010) I really need them to be in the form of 01/06/10, I can not change the excel file format it has to stay the same format for...

Hi My name is Lucia and can't wait to here from some of you :rolleyes: Well maybe even a few more. I'm a report fool in Indianapolis running crazy questions though numbers. Been working with Access but it's been a while for me. I even took the wonderful Microsoft on-line, get in touch classes...