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...

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] & " -- " &...

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!

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...

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...

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...

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...

Hello! i'm new, obviously :) I have 3 books open on my desk, and have searched online, and I cant figure this out... I am trying to do something so simple, but it isnt working... I have 2 tables... one with a list of companies, addresses, ph#'s, etc.. (customers) and their CompanyID (which I...