Creating An Update Database For A Loyalty Points Scheme

Feb 5, 2008

hi i want to create a loyalty points scheme though a database,
general rulse apply 1 point per £1,

when the customer spens some money the staff then go to the machine and input the relevent data.

then a statment will be printed out for that customer with the points to date, and thier purchase the amount of point collect with the new total.

To search the full name and postcode would be adiquit as the printed statment could be lost and so could the customer id get confused by the customer.

for the report the layout would look like this:
eg

customer ID
cathy smith
e-mail,
address,
postal code,

02/12/2007 points to date 200
05/01/2008 puchase made £30.00
05/01/2008 new points total 230

if they use points it would look like

02/12/2007 points to date 200
05/01/2008 puchase made £30.00
05/01/2008 points use 125
05/01/2008new points total 100

point can be enterd manually and removed manually as customers want to save like a saving scheme

please help me with is as i have no idea where to start and if it posible, and limited knoledge of access

thanks in advance

View Replies


ADVERTISEMENT

Macro - Filter By Scheme

Feb 24, 2012

I have an open form. In that form I want a control to do a macro. The task is the following events:

Home>Advanced>Filter by scheme.

The first event in the macro should be to empty the form.

View 3 Replies View Related

Queries :: Building Rating Scheme Query?

Jul 8, 2014

I currently have 2 tables in a database that I'm trying to build a query off of. The first table lists personnel & their position #s, and the second table has a column for "rated person", "rater", "senior rater" and "reviewer" which are all part of our annual evaluations. I'm trying to program the query to display the names of the person attached to a position #, but can only get the query to return the actual position #s.

I'm using the table to assign each position # appropriately, i.e. position # 10202 is rated by 10103 and senior rated by 10101; I do this with the lookup data type. Once each position # is assigned, I'd like the query to display the name of the personnel instead of the position #, i.e. when queried, it would return under the rater column JOHN SMITH instead of 10202, and in the senior rater column JOHN JONES instead of 10103, etc.

View 1 Replies View Related

Tables :: Master Database - Several Tables With Two Reference Points

Jul 4, 2013

I have broken up by master database, table, into several tables. They all share the same ID values since they came from the master table. So each table that I split off has a unique, matching, identifier, ID, in both the master table and the new table. Plus a previous matching identifier listed immediately below.

Example: Permit the master or main table and Builder a supporting table. There are five tables that I split off and all have an identifier similar to the two listed below.

Permit->ID
Permit->BLD
Builder->ID
Builder->BLD

All my tables have the same ID. But each table also has a identification numbers such as builder BLD, Subdivision SB and inspector INS>

Permit has the BLD, SB and INS

Builder has only one occurrence for each builder in the Permit table. As in the past it was identified by BLD number and now also ID. the use of BLD is from when I used visual dBase. The big difference here is that I have two ways to identify one is ID any other is by BLD, etc. My first thought is to identified by the BLD. I don't know why, but I guess I fear using a single "ID" to identify my various split off tables unique value or BLD.

View 1 Replies View Related

General :: Creating A Database For Creating Quotations

May 20, 2015

I am creating a database for creating quotations. The quotation number is generated using the date, for example the first quote today would be quote number "05202015-1" because it is the first one today. The next quote today would be quote number "05202015-2" and so on. Is there a way to make access automatically generate these quote numbers based on the date?

View 3 Replies View Related

Creating A New Record After Update

Mar 13, 2014

I have a table called [Tasks] which has the following relevant fields:

[Task ID]
[Location]

I have a form that people use to create new tasks and update current ones. Location on the form is a combo box where people can pick from 5-6 different locations.

After someone selects a new location from the combo box and changes the task location, I want to create a new record in a table called [Task Progress] with the [Task ID] of the task whose location was changed, the new [Location], and the [Date] and [Time] it was changed. It would look like

Code:
[Progress ID] [Task ID] [Location] [Date] [Time]
1 5 Station 1 1/1/2011 12:13:01
2 8 Station 2 1/3/2011 01:53:29
3 5 Station 2 1/5/2011 11:13:05
4 5 Station 3 1/6/2011 12:35:22

What should I put in the AfterUpdate event for the [Location] combobox to make the above happen?

Note: All my tables are ODBC linked to SQL Server (can't use data macros).

View 3 Replies View Related

General :: Creating New Record After Update

Mar 13, 2014

I have a table called [Tasks] which has the following relevant fields:

[Task ID]
[Location]

I have a form that people use to create new tasks and update current ones. Location on the form is a combo box where people can pick from 5-6 different locations.

What I want:

After someone selects a new location from the combo box and changes the task location, I want to create a new record in a table called [Task Progress] with the [Task ID] of the task whose location was changed, the new [Location], and the [Date] and [Time] it was changed. It would look like

Code:
[Progress ID] [Task ID] [Location] [Date] [Time]
1 5 Station 1 1/1/2011 12:13:01
2 8 Station 2 1/3/2011 01:53:29
3 5 Station 2 1/5/2011 11:13:05
4 5 Station 3 1/6/2011 12:35:22

What should I put in the AfterUpdate event for the [Location] combobox to make the above happen?

Note: All my tables are ODBC linked to SQL Server (can't use data macros).

View 1 Replies View Related

Getting 2 Decimal Points In A Table?

Jan 28, 2008

This is probably an easy question, but I can't figure out how to get a table to show numbers in 2 decimals points when they are inputted with 2-5 decimal points. I changed the DATA TYPE to Number and DECIMAL PLACES to 2, but when I do that, it just rounds it to a whole number. Please help, thanks!

View 6 Replies View Related

SQL Round To 2 Decimal Points??

Jan 6, 2006

Hi, I have this query and I would like to have the avg display with only 2 decimal points. This is my SQL and I think I have to use this code but I'm not sure.

FORMAT(CountOfStudent Attended,'.00')

If I ad this after the SELECT statement my query will not work. What am I doing wrong?

Thanks!

~D


This works

SELECT [Attendance for Avg].CRN, Avg([Attendance for Avg].[CountOfStudent Attended])
AS [AvgOfCountOfStudent Attended]
FROM [Attendance for Avg]
GROUP BY [Attendance for Avg].CRN;

View 3 Replies View Related

Problems With Break Points

May 25, 2005

I have a very annoying problem with my break points that I can not figure out how to fix. I have a database that when I place a break points on code it will not break the code and go into debug. I have created a very basic form with one button and the following code:

Option Compare Database
Private Sub Command0_Click()
Dim str As String

str = "this is a test"

MsgBox (str)
End Sub

The message box will pop up but the program will not stop on either on the str... line or the msgbox... line. I'm sure some how or another I turned off the debugger but I do not know how to turn it back on.

Thank you for any help.

View 1 Replies View Related

Using Decimal Points In Text 1.2.3

Jan 30, 2013

Made an access data base for our company policies and procedures.

Fields are:

Section
Section Title
Policy
Explanation
Related Documents - (hyperlink field)

Running a query on the table for the report the delivers the policy.

the Section Field is Rich Text - this is the only way I can figure out how to display decimal point divisions like, 1.1.0, or 6.5.3 (for relevant sections).

Query won't return anything when I set a parameter on Section Feild and I suspect it's because of the Rich Text issue. I've tried smart tag but no avail.

And the next thing I want to do is have an index that gives me Section and Section Title with a go to. How best to achieve that???

View 3 Replies View Related

Creating An Input Field In An Update Query

Oct 29, 2007

My form contains the field Bill_Date, which may or may not be input during data entry. What I need is to run a query (I think) that allows me to input a specific date that will automatically populate all Bill_Date fields that are currently null with the date specified. Eventually this will end up on the front end where a biller will click on a link when they open the db, input the date into the field, and then process another report.

I have absolutely no idea how to even begin and was not able to locate any specific information in Help or here on the forum.

Many thanks.

View 7 Replies View Related

Update Query Creating Extra Record

Jan 5, 2005

i have this problem that is bugging the crud out of me:
sql="UPDATE bedrifter SET pr=" & Request.Form("pr") & ",totalindexedpages=" & Request.Form("tip") & ",totalinboundlinks=" & Request.Form("til") & ",description='" & Request.Form("dsc") & "' WHERE created='" & Request.Form("ts") & "'"

conn.Open connStr
conn.Execute(sql)
conn.close()
Set conn = nothing

when i run this code it updates the correct record (line in my access db) but then it also adds a new line with only that info in the update query. why is it doing this? when i update using the ID instead of using the timestamp in the WHERE clause it works fine. really frustrated...

View 1 Replies View Related

Forms :: Creating Form To Update Table

Apr 23, 2015

I've got two tables - one that works like a cypher and one with all my records.

I have 2 queries. One that is a simple query that extracts data that is not so user-friendly and puts it into a user-friendly format. The Other query is for any records that the first query excludes because the new combination of data (lets just call it a code) is not in the cypher table, but needs to be added.

How do a create a form that will show the records in the 'excluded records' query and allow me to select from a drop-down list a specific set of categories to update the cypher table ?

Example :

Record Table: Cypher Table:

Ford Focus = Sedan
Ford F-150 = Truck
Ford Freestyle = Wagon
Ford Escape = SUV

Now a new model comes in, a Ford Edge which is an SUV but is not in my cypher table.

I have the query to pull in the excluded Ford Edge, but I want a form to show "Ford Edge" in the first column and be able to select from a drop-down list "SUV", and either automatically update my cypher table or require me to press a button to update the table (whichever is easier).

View 6 Replies View Related

Modules & VBA :: Compare The Last Two Data-points With 1?

Jul 19, 2014

one more thread of mine today

I have this table:

-> tblTest

Code:

test_id | test_Name | test_Date | test_value
------------------------------------
1 | Company A | 01.01.2010 | 0,90
2 | Company A | 02.01.2010 | 0,95
3 | Company A | 03.01.2010 | 1,10
4 | Company A | 05.01.2010 | 1,05
5 | Company B | 01.01.2010 | 0,9
6 | Company B | 02.01.2010 | 1,20
7 | Company B | 03.01.2010 | 1,15
8 | Company B | 05.01.2010 | 0,95
9 | Company B | 07.01.2010 | 0,80

The important level is 1,00

Now I will, for each company, check:

- Is the value of ID-1 >1 AND the value of the ID-2 <1, THAN give me a 1
- Is the value of ID-1 <1 AND the value of the ID-2 >1, THAN give me a -1

In this example the result should look like this:

Code:
test_id | test_Name | test_Date | test_value | test_Code_result
-------------------------------------------------------------
1 | Company A | 01.01.2010 | 0,90 |
2 | Company A | 02.01.2010 | 0,95 |
3 | Company A | 03.01.2010 | 1,10 |
4 | Company A | 05.01.2010 | 1,05 | 1
5 | Company B | 01.01.2010 | 0,90 |
6 | Company B | 02.01.2010 | 1,20 |
7 | Company B | 03.01.2010 | 1,15 | 1
8 | Company B | 05.01.2010 | 0,95 |
9 | Company B | 07.01.2010 | 0,80 | -1

Probably I have to carry out this in vba.but i dont know how I can calculate across the datapoints (rows).

View 14 Replies View Related

Adding Points To A Table On A Time Period

Aug 2, 2006

Can you help we have a data with a list of jobs that scores points, I need to build a query or scirpt that will add 5 points every 30 day fro the date the job was submitted this will help old jobs come the top of the list.

View 1 Replies View Related

Enter Text As Bullet Points In A Textbox? Possible?

Apr 26, 2006

I have a textbox called txtcomments on my form. It is bound to a table field defined as Memo. Now i normally would enter text and produce a report from the comments in my table.

I want to be able to enter text like this in my form, so that my report can be formatted like this: All in one textbox (memo table field).
Like this:

*************in my txtbox************************
Accomplishments

Etc
Etc
Etc


Current / Upcoming Work

Etc
Etc
Etc


Risks / Challenges

Etc
Etc
Etc

***************end of txtbox***********
Is this possible? If not, how do you think i can achieve this? I am open to suggestions, please help :D

View 9 Replies View Related

Insert Bullet Points In Memo Field

Aug 30, 2006

My form has a Memo field that stores "To Do" descriptions. My user wants to be able to add bullet points next to their entries. There could be multiple To Do's in a single field.

Any help is appreciated.

View 9 Replies View Related

Tables :: Calculated Field With Two Decimal Points

Apr 29, 2014

I have a problem when storing a calculated field with two decimal points. If I set the field to double, fixed, 2 decimal points. For the field it will show the calculations as:

21.364 as 21.36
21.563 as 21.56
21.272 as 21.27

Which is how I want it to be, however when I run a summary of the field rather than showing 64.19 it calculates as 64.20, I know that this is the correct figure but is there any way I can get it to show me the 64.19?

View 1 Replies View Related

Tables :: Calculated Field - Tally Points For Each ID

Aug 28, 2014

So I have a simple table with Date, Points Earned, Points Used and Client ID number. Id like to tally the points for each client ID, after each time they either use or earn points. How do I do this?

View 14 Replies View Related

Tables :: Source / Reference Of Different Data Points

Apr 24, 2015

I want the user to be able to see the source/reference of (many of) the different data points in my database, so I need to store sources/references in the database itself. I want to have all references in one single/common table (list of references). Each reference may be the source of many data points, in different columns in a given table, and in different tables. Is this possible, and can it be done in an elegant way?

View 2 Replies View Related

Reports :: Generating Report With Points Fields?

Apr 15, 2013

I have a report that is purely for points gained from products. Each product is split into 3 (e.g. Investment A, B + C) and there is a indicator that means the points gained can be added up (e.g. I for Investment and S for Savings).

I have made the report which is many unbound fields. There is a summary section for all points added together with fields Total Amount, Monthly Target, Quarterly Amount and Quarterly Target.

Then the report is split into each of the 4 products (Each of these have different amounts of points. Number indicates it):

Investments (10), Savings (15), Pensions (15) and Protection of Life Savings (20).

Each of these have 4 fields - Total Amount, Target Amount, Quarterly Amount and Quarterly Target.

I need a way to generate these point scores using the Product_Points field. I already have Quarterly Target and Target Amount because there is a set field called Points_Annual_Target.

EDIT: I also don't want it to come up with the 'insert parameters' so all the info is one page.

View 1 Replies View Related

Queries :: Writing A Query With 2 Points Of Criteria?

Sep 23, 2014

I wrote a basic query that allows 1 field to search another, and if there is a match, it spits it out, however, I am getting 20,000 matches. I want to add another level of query to reduce the 20,000 matches down to 1 or 2 or none...

So I consolidated a government list, publicly available, into 1 field, and created a table that I can use as my query against the large government list:

SELECT [Consolidated Denied Party Report].*, [Consolidated Denied Party Report].[31]
FROM [Consolidated Denied Party Report]
WHERE ((([Consolidated Denied Party Report].[31]) Like "*" & [Please Enter Your Search Term] & "*"));

this allows me to search for a word, like, create, and it gives me every single result however it also gives me hits to words like PROcreate, which is fine on one hand because it shows possible false flags, but it would be nice to also be able to query down a level.

I now want to have the query look at the word "create" but also look at another column that is say the country... Germany.. and if I have text in the second column, only give me a result if the word create and germany are in the same field.. if create and Italy were in the same field, it would not be a hit.

View 2 Replies View Related

General :: Query To Calculate Points Based On Dates

Jul 1, 2015

I am trying to create an attendance database, our company introducing the point system attendance,

Called Off (CO) 2 points
Left Early (LE) 1 Point
Tardy (Tar) 1 point

Employee can reduce point if they have perfect attendance for 90 days from the last day of violation. For example, an employee absent on 01/01/2015, he will received 2 points, the credit will giving on 04/01/2015, if there is no violation, but if he absent again on 03/31/2015 not only he will received 2 more points his 90 days will start from 03/31/2015, now he will eligible to get credit on 06/29/2015 and so on.So far I have created 3 tables and 1 query.

Tables

Employees: Id, Last Name, First Name
Points: Id, Description Points
Attendance:Id, Date, Employee ID, Points ID

Query
Date
Employee ID
Last Name
First Name
Point Description
Points

how and which formula to use which calculate the points based on above example.

View 14 Replies View Related

General :: Transfer-text Defaulting To 8 Decimal Points?

Mar 23, 2014

I have a Table with a Field set to Number, Single, Fixed, 2 Decimal points in which I enter Hours (ie 11.25) then at some point I want to extract those new entries to create a Text file transfer.

I have a Macro which extracts those new entries from the main Table and copies/appends them to a new Table which contains only the new data I need to create the File to upload into a Payroll system (using TransferText option).

It all works well EXCEPT, the File it creates insists on showing 8 decimal points and I just cannot get it to show 2 only.I have tried using a calculated field, setting the secondary Table field to Text.why or where these 8 decimals are coming from.

View 2 Replies View Related

Queries :: Creating Field Names In A Query That Will Automatically Update Each Month

May 10, 2013

I am hoping to create a field name in a query that will change every month. Right now the filed name is qryTechQuintileMonth-7.am_quintile. this designates that the data is for October 2012. There are 6 other fields named similarly for Nov 2012 through April 2013.

Is there a way to name these fields with the proper month-year (mmm-yy) so they automatically update each month?

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved