Search results for query: *

Sorry usually when I reply to my own thread I don't get an answer - this is regarding the question I asked earlier today I tried the DateAdd("w",((WeekDay([BDT],vbMonday)-1)*-1,[BDT]) I actually want it to return the first day of the week (monday) I don't want to have to type in a...

Okay - so I figured that part out In my new field I wrote as - projected date:=DateAdd("w",-7,[BDT]) It returned exaclty what I wanted - ( My BDT field has different dates in it) but........can I also ask it -7 first day of the week? See it returns Sat and Sun dates and I just need...

Hi I posted a question in another forum (don't know if I'm posting in the right forums) anyway - I kind of figured out my last problem - I was wondering if you are using the DateAdd function if there is a way to return the criteria that you want by mondays? My Date field is BDT My new field is...

Hi - I have made a query of specific info that I need to pull a report from - the only problem is that I am not an access expert - especially when it comes to criteria or sql - what I have in my qry is a field that has a week span and a field that has a week # (example = week 19 is 5/6/02 -...

Hi I don't know if I'm in the right area to ask this question so I appologize if I'm not - I've never had to email any access materials before - I cannot figure out (is it possible) to email just a report? My computer has the netscape email - when I choose to attach - it attaches the whole...

Thank you - that worked beautifully!! Jingram

Hi - is it possible to create a report from 3 tables? (or qrys?) I have made one report from the first table and just want to add the other two on the same page - is this possible - maybe I have to create the report from scratch but I need a little bit of direction with it- any input would be a...

COULD SOMEONE POSSIBLY HELP ME WITH INSERTING THE CORRECT CRITERIA IN A QRY? I HAVE A DATE FIELD (ACTUALLY 4) AND FOR THE 1ST ONE I WOULD LIKE TO ASK IT TO RETURN ANY DATES THAT ARE THAT ARE MORE THAN 7 DAYS OLD. THEN ON THE NEXT QRY I WOULD LIKE IT TO COMPARE TWO OF THE DATE FIELDS AND HAVE...

Well there probably isn't 500 records but close to it - What they are is Part Numbers from an internal database - we don't have many consecutive numbers so...... is there anyway of increasing the limit of characters in the criteria? I am going to try to use the Part numbers (between - and)...

HI I WAS WONDERING IF THERE IS A LIMIT TO HOW MANY RECORDS THERE ARE ALLOWED IN THE CRITERIA BOX - WE HAVE PROBABLY AROUND A 500 OR MORE AND IT WON'T LET US ENTER ANYMORE - WHAT DO I DO??? PLESE HELP