Hi all, I was wanting to know is it possible to make a field with unique values dependent on values from another field in the same table?

You can do just about any thing you want but this particular "thing" would violate 2nd normal form so I wouldn't recommend it. What are you trying to achieve?

well the table is for a sales made throughout the day thing and i was wanting to represent the sales number with a unique value for the amount of sales made but i was also wanting to have a link to the specific date the sales occured for storage purposes

Use an autonumber as the primary key and add a column for the SalesDate. You can specify Date() as the default in the table properties for SalesDate so data entry isn't necessary. You don't even have to show the column on the form.

ok thanks :)