Search results

What syntax do I use to create a variable that = [ServiceDate] + 1 month? Im trying to make a query that says return all records where [field1] (which is a date) is < [field2 + 1mth]. Can I merely say: = [field1] < (dateadd("m",1,[field2]) ? Any ideas? Ive looked in Help but come up with...

How to I show a sum in a query based on two tables? I have a field in the query for a customer's telephone number and a number for the number of minutes they use. There can be several separate entries under the same number and I want to sum them. How should I go about it? Im the query? In a...

Microsoft Access isnt alphabetizing when I use the A -Z ascending button. I click in my customer name field, then hit the button. It works...but there are always a few stragglers...that is to say a P between D and E....or a Q between L and M. Actually...it works with the actual records, but...

I need a query based on a search form that runs a report. Basically, I have a form that records a person's name and has a subform with entries that records a date and a name on each line. What I need is to run a query that takes its information from a search form Ive made and automatically...

Id like to put a field in the header of my form that will jump to a record based on partial entries typed in. For example... Jump to: Donh will jump to the Donhoo, Keneeda record. Is this possible? It would help with multiple entries. Im going to search for articles about setting up a...

Im trying to import from an existing Excel database, but the fields arent the same..which is causing problems. Since I know its easier to point from field to field in Excel, Im thinking of making a new,blank spreadsheet with the field headings from the Access Database that I ultimately want to...

Im trying to make a command that closes the form you're in and goes back to the switchboard. The Wizard only gives you one command...how/where do you add another?

Ive looked in Tools...Add-Ins...but theres no option for Switchboard Manager. Id really like to have a switchboard. Is there another way to create/edit one? Thanks

The program is corrupting ITSELF! I was getting help setting up references from one text box to another. Well I got one to work fine then I did another and they both flashed the #error field. I go back into the expressions...and there are extraneous [] marks around certain values...

Two questions: First I need to put the sum for a range of values in a subform in the master. Im thinking I use the DSum(expr, domain[, criteria]) model. But I get an #error when I use: =DSum([Forms]![ReferralTable subform]![Referral Amt],[ReferralTable subform]) Am I getting the error...

How do I set up a "form inside a form" like in the MS Access example template called "Service Order Manager ?" I say "form inside a form" (see attatched pic) because when I put the "Service Order Manager" db into design view , the object which allowed ongoing entries looked another form. How do...

Ok. Im new to Access and obviously need some help. I've just made a Table/Form to track the free credits my home business gives to customers. Generally, I record incoming credits that customers will have applied to their balance in the future. Each customer has a unique Bill Day, which is the...

Heres my problem... I have a number field that I need to have a value based on the comparison of two other variables. Keep in mind each of these variables is a FIELD on the form. Eg. If A > B then C (this field)= D+1 Ive tried editing the Control Source (making an expression) and putting...

Heres my problem... I have a number field that I need to have a value based on the comparison of two other variables. Keep in mind each of these variables is a FIELD on the form. Eg. If A > B then C (this field)= D+1 Ive tried editing the Control Source (making an expression) and putting in...