After building an expression to work out a percentage value I am left with a figure like 4.22225645.
How can I cut the decimal places down to just one of two figures. Even Better can I round the value up and Down.
Thanks
James
I have two Sales teams that need to be reported on a daily basis, with each team have four people and each of these (hopefully) make more than one sale per day.
As you can imagine there are a number of results that I need to produce, namely
- The total Sales value per Sales person(summary, not...
I have a table with 100 records with eight fields in each.
A form that displays two tick boxes.
- Checked (y/n)
- Succesful (y/n)
I need the end user to select to check through these records and tick them off, if a similar record is found from a diffenent source.
So far, so good.
However I...
Having selected the "Add new record" option from the command box, I receive the following error message when I return to form view.
Compiler Error, Ambigious name detected.
Err_Save_Record_Click
Any ideas folks?
Is it possible to import the system date into a particular field.
Thereby everytime the end user enters their sales details, the time and date is automaticaly recorded, in turn these can then be sorted by various time frames?
I wish to create a four sections type questionaire, using a tab for each section.
What do I need to do to forcce the end user to complete all the fields in the first section / tab before moving onto the next.
I also need to ensure that each tab is completed before a new record can be started...
I am importing a series of Outlook forms that contain the same eight fields into Access.
However having successfully imported these records via the “Get External Data” option, I only seem to have imported the static email Categories / Fields, i.e. ID, Importance, Icon, Sender name, etc.
While...
In my last query I asked....
I need to enter a set of records on a daily basis, which contain the same fields. Customer details etc.
With the exception of cutting and pasting the following days records, is there any way to include the both days records together without over writing the first...
In my last query I asked....
I need to enter a set of records on a daily basis, which contain the same fields. Customer details etc.
With the exception of cutting and pasting the following days records, is there any way to include the both days records together without over writing the first...
Thank you FancyPrairie for your early suggestion, it worked a treat.
Now for my latest question.
I need to enter a set of records on a daily basis, which contain the same fields. Customer details etc.
With the exception of cutting and pasting the following days records, is there any way to...
I need to import an Outlook template containing eight fields, into MS Access.
Unfortunately I don't know where to start with this process and I am presently forced to
- Convert each of these emails into a .txt format
(as there is no .csv format available)
- Convert each of these files into...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.