Search results

Hello... I don't know the best way to do this, but this is what I need to do: I have a table of "players" with main columns - total games played and total games won. Every time the players complete a match, they submit their scores (Lets say weekly) Once the scores are updated, I will run a...

Hello, I am trying to run a mail merge that will insert the web address for each recipient... When I insert the fieldin Word, the address comes out as: www.urlhere.com#http://www.urlhere.com# when what I want is just: www.urlhere.com I'm guessing this has something to do with the...

1 more question... Is there a way to just join 2 text boxes, so that I can format the phone number in grey and the name in black? I want the info to flow together, like concatenation allows, but I want the info to display differently... Is that possible? Thanks!

AWESOME! Thanks so much, worked perfectly... I knew there was some little snippet of code that I needed... thanks!!

Hello, My table data contains phone numbers as raw digits, ie: 9101234567 instead of (910)123-4567.. i used an input mask so that what I see is the "(910)123-4567" My problem is, when I run a report, and create a concatenation formula such as: =[FirstName] & " " & [LastName] & " -- " &...

Thanks for the tips.... I am currently using a formula that calculates the "hours spent" in a query for me: ShiftHours: Format([Start Time]-1-[End Time],"Short Time") this gives me a number like 04:00 for someone working 11:am-3pm What I want to do is also create a formula (or something)...

Hi, I am trying to create a report that will show employee shift time... I have a query that pulls a "Start Time" and "End Time", and then it calculates total time spent/shift... What I want to do is create a running total, or just a grand total, of the amount spent by each employee.. I want...

Is there a way to number entries within a group of my report? For example, I have a schedule of people working a certain shift, grouped and sorted by the day and start time... however, I want to number my entries so I can see at a glance how many people are scheduled... thanks!

OK... got the time showing better... does anyone know if there is a way to keep track of their "running total" of hours... As I mentioned earlier, the hours per shift are calculated in the query, and each person gets those hours/shift Is there a way to keep a tally of their hours over the...

So awesome!!!! Thanks!!!!!

Hi, I am trying to create a report that will show employee shift time... I have a query that pulls a "Start Time" and "End Time", which are both in Medium Time (6:00AM) In my report, I have the following concatenation: =[Start Time]&" - "&[End Time] Which I want to show: 6:00AM - 5:00PM But...

Hi, thisa is a general question, but I am wondering... I just purchased the MS Office 2007 upgrade for my computer.. I want to install on my laptop so I can work from there as well... Is this allowed? It seems as though it should be, since they are both my computers, that I alone work on...

Hey Wayne, Thanks... does the structure in design view determine where they appear in regular view? Maybe thats it... I'll try... Noticed your tagline... you play much pool? Ever been to the Super Billiards Expo in Valley Forge, PA? (www.superbilliardsexpo.com) Thanks again!

hmm... no, i am only person accessing files... The only time I move columns is to put them somewhere where I want them to permanently be... such as when I open file and have to move them back to the right places...

Hello! Ive been learning Access over the last few weeks, and I getting much better, thanks to a lot of help from here! I keep having this weird problme, which isnt too big of a deal, but its annoying... When I open an existing table, quite often the columns have shifted.. That is, for example...

Thanks, I have tried to check that, and unless I am doing something wrong, its not working.... I can get the arrows to show, meaning the tables are linked left and right, and I have tried both ways... no luck... I cant seem to get the "empty" booths to show up...

Hi All! So far, everyone her has been super helpful, and I'm starting to learn access a bit better... however, Im stumped again. Im new, so Ill try to explain as clearly as possible: My situation: We produce an annual tradeshow with approx 150 exhibitors. Each exhibitor rents a booth (or...

Thanks!! Finally found this, which helped me figure it out: Overview: Changing Initial Value of an AutoNumber Field In order to force Microsoft Access to number an AutoNumber field with a number you choose, follow these general steps (a more detailed example is shown later in this...

Hi No one (or Access help) seems to ever actually say how to set the number for autonumbering. I have a list of records that are "members" and I want to add a new column (and make it primary) and assign everyone a MemberID number, but I want to start the numbers from 412403111, or something just...

GOT IT!!! I figured it out before your post, just now... I dont have time to explain, bt I will later... basically, I didnt want autonumber to start at "1" for companyID, so I created some kind of "mask" or format rule by using "\10000" in the design view... but, in the 2nd table, i actually...