Recent content by BobJones

cheers thanks alot raskew

After having to take on the work of someone else and finding that the dates were stored as text in the format yy.mm.dd I would like to change it so it is dd/mm/yyyy and stored as a Date. I was thinking about using an update query rather than go through 10000 odd records! Any ideas?

Thanks man. You are a star! :)

I have a query to go through a table and pick up the amount of money earnt during a period then I use that field to calculate commission, but the commission field just shows up as numbers and not as currency as the set field in the table does. Is there anyway in SQL to say what sort of data type...

Try SELECT COUNT(YourTable.SerialID) AS TotalEntries FROM YourTable WHERE YourTable.YourDate = # & Format(Now(), "mm/dd/yyyy") & # Because of the american date standards the date format has to be set as that, at least ive found anyway

Ok... Here are the table structures. As each of the policies by nature have different things that they cover for, this is the reason I have made policies based on these... Otherwise the tblPolicy would be a huge table with potentionally hundreds of empty fields. tblPolicy CustCode SalesAccount...

I have an insurance policy database keeping track of insurance policy details for household and commercial shops and businesses. Tables I have are tblPolicyHousehold, tblPolicyCommercialS (Shop), tblPolicyCommercialB (Business). They each contain the following fields (the other fields they...

OK well once again, I solved it by myself... So for anyone thats interested, it involved two queries. qryInvoice: SELECT tblGroup.GroupID, tblPerson.FirstName+' '+tblPerson.LastName AS Name, tblPerson.Address1+', '+tblPerson.Address2 AS Address, qryInvoiceGroupCount.CountID AS [No in party]...

I have two tables, Group and Person. A group can hold one or more persons, linked by a field called GroupID. And a person can be a leader of a group. I want to make a query to return the leaders of the group, which I can do, ie. where tblPerson.Leader = true, but I also want to calculate the...

I have trying to export some cells in Excel which have hyperlinks in. I only want to export the path though and not the text which shows in the cell in Excel. Any ideas?

I have customers, projects and work tables. projects are linked to customer via customerid and work is linked to the project via projectid. Ok.. What I'm trying to do is make a timesheet so that work done for a specific date for any project can be retrieved and concatenated into a string or...

thx very much for your help, it worked great.

Hey guys, Anyone know how to go about catching the "Index or primary key cannot contain a Null value." message box and perhaps showing a custom message instead? Thanks in advance, Bob

No one knows how to do this?!

Generate SQL String through form values I am in the process of making a reports form for my client where they will be able to generate a query on the fly as it were. I have three radio buttons, All, Active and Inactive. So all will show both the active and inactive user accounts, active will...